Autofiltered List; cross-row formula
Posted
by Chris Gunner
on Stack Overflow
See other posts from Stack Overflow
or by Chris Gunner
Published on 2009-03-16T17:13:11Z
Indexed on
2010/04/16
16:03 UTC
Read the original article
Hit count: 224
I have a large Autofiltered list (~600 rows), with some of the rows being summary rows that I want to use a UDF to display the lowest priority listed in any of the 'child' cells. I can pass to my formula the right cells, but they are no longer correct if the list is re-ordered in any way. Is there a way to give the formula the right cell and have it recognise that I want that row and only ever that row?
I can do it with a VLOOKUP to look at a hidden column that lists wether the 'child' row matches the right criteria, but with 600 rows and each parent row requiring about a dozen 'child' cells each, it's too slow.
© Stack Overflow or respective owner