little dove
New Member
- Joined
- Nov 5, 2022
- Messages
- 7
- Office Version
- 2021
- Platform
- MacOS
I have a spreadsheet with 100 columns and 50 rows.
I want to highlight the cells with the 8 smallest numbers in each column.
I have tried conditional formatting but it will sometimes highlights a lot more than 8 cells in each column when one of the 8 lowest is repeated.
If there is a duplicate I would like it to highlight the one in the first row it comes to (from row one working down) and then ignore duplicates.
Any help much appreciated, thanks
I want to highlight the cells with the 8 smallest numbers in each column.
I have tried conditional formatting but it will sometimes highlights a lot more than 8 cells in each column when one of the 8 lowest is repeated.
If there is a duplicate I would like it to highlight the one in the first row it comes to (from row one working down) and then ignore duplicates.
Any help much appreciated, thanks