Sir Babydum GBE
11-14-2007, 06:44 AM
Hi
I have two filter-related questions.
1) Is there a function (or combination of) where I can return the most common value in a filtered column? (that is, I may filter by Column A, but want to see the most frequent value in Column B)
2) Can I have a rank() type function in each row that will adjust accordingly when a range is filtered? These formulae would be on the rows to being filtered.
Thanks in advance
BD
I have two filter-related questions.
1) Is there a function (or combination of) where I can return the most common value in a filtered column? (that is, I may filter by Column A, but want to see the most frequent value in Column B)
2) Can I have a rank() type function in each row that will adjust accordingly when a range is filtered? These formulae would be on the rows to being filtered.
Thanks in advance
BD