I have a large flat file of a bunch of ungrouped primary key values.
I want to filter on a key and populate cell A1 with the value selected from the dropdown list.
In the end, I want to see a sum of each primary key's associated value in column D & G after filtering on that primary key.
I'm using this function at the top of row D and G respectively:
Does anyone know, through using a function, not a macro, how to populate a cell with a filter's selected value?
Sample data & solution:
D G 7 6 id class trnsfr reg_hrs crs_no sec crs_hrs 6181191 BT R 4 INIS210 1 3 6181191 ED G 3 COMS223 4 3