Simple Macros Table Count
Hi,
I'm trying to build a formula that will count the position of a cell relative to a list. You'll find a pic attached.
When I select "34" from the drop down menu, the table automatically populates cell h10 with the #34. I need to know what position 34 is relative to the list (report 34 would be the second report on the list)
How can I do this? The match function does not work.
Thank you!
|