Hi all,
I'm having trouble with a way to return the value for mapped rows. Example workbook attached.
Basically I want there to be a way to return the figure from the Num column (F) to the Group 1 and Group 2 columns (G and H) with the formula in the G and H columns.
So for example, because Group 1 is mapped to Row A and Row B only the values of 21 and 27 is returned in the Group 1 column. Because Group 2 is mapped to Row B and Row C, the values of 27 and 30 is returned in the Group 2 column.
Thanks in advance.
Bookmarks