HWL
Active Member
- Joined
- Dec 1, 2009
- Messages
- 462
Is there a simple way of getting the row number of the filtered row (supposing the user has filtered to a single row)?
Code so far:
=IF(SUBTOTAL(3,DB_LIST!B2:B300)=1,"yes 1 row","")
Where it says "yes 1 row", I'd like to return the row number that is actually filtered. I have done this will helper columns but I should be able to do it without a helper column. Thanks
Code so far:
=IF(SUBTOTAL(3,DB_LIST!B2:B300)=1,"yes 1 row","")
Where it says "yes 1 row", I'd like to return the row number that is actually filtered. I have done this will helper columns but I should be able to do it without a helper column. Thanks