mole999
Well-known Member
- Joined
- Oct 23, 2004
- Messages
- 10,524
- Office Version
- 2019
- 2016
- 2013
- Platform
- Windows
I have a doc with 90000 rows. I need to visualise a status.
I.e row 10 has on, then row 20 has off, so 11 to 20 have the ON flag and is visible.
trying to do this manually and it is taking for ever to identify the start point, double click so it fills down
The statuses are in Y, and i want AA to show SO as the output for every entry between 10 and 20, for the 90000
Ideas appreciated.
I will then change to suit other necessary highlights.
Just a thought I think I saw a @Fluff routine, fill to totals or something like that, which i will look for in the meantime
I.e row 10 has on, then row 20 has off, so 11 to 20 have the ON flag and is visible.
trying to do this manually and it is taking for ever to identify the start point, double click so it fills down
The statuses are in Y, and i want AA to show SO as the output for every entry between 10 and 20, for the 90000
Ideas appreciated.
I will then change to suit other necessary highlights.
Just a thought I think I saw a @Fluff routine, fill to totals or something like that, which i will look for in the meantime
Last edited:
