Forum Discussion
Select cell based on separate/non adjacent cell range
Hello everyone, I was hoping someone could please help me with a solution. The image I have attached is the spreadsheet I am working with. The yellow shaded cell (0.07%) is conditionally form...
RalphB1560 If your Excel recognises the dynamic array function FILTER, you can achieve this as demonstrated in the attached file. It will create a summary list of all rows that comply to the percent range you are interested in.
Alternatively, and since you already have conditionally formatted (yellow) the percentages that fall within the range, you could also filter the percent-column by color. This is also demonstrated in the attached file. It doesn't give you a summary table but it gives an instant overview without having to scroll down a long list.
