Oct 08 2021 02:14 PM
Hi all. I have two questions and after spinning my wheels for several hours I'm hoping you can help.
1. I work with large datasets and often I would like to know the top, say, 2 values in each column of numbers. There may be hundreds of columns, and say 90 rows. It's fine if the top values are all colored the same, but each column needs to be analyzed separately from every other column. I cannot seem to create a formula that works. :(
Similarly,
2. I am working on a file where I want to know if any of the large number of columns are greater than or equal to 5% of the value in the first column. So IF D1:ID1=(=>($C1*.05)) use red fill, and if D2:ID2=(=>$C2*.05)) use red fill, etc. The same color in each row is fine, but I need each row analyzed individually to highlight only those columns where the value is greater than or equal to 5% of the first value in the row.
Any assistance would be greatly appreciated!
Oct 08 2021 02:45 PM
Oct 08 2021 03:00 PM
Oct 09 2021 05:28 AM