Hello everybody
In my attachment I have a selection for the range A1:I11 .. the last row is blank ..
Based on selection I want to get the results in Column J based on Column G
Situations:
G1 is blank so J1 is blank.
G2 has a unique name so J2 will have the same value as in I2.
G3 and G5 and G6 and G10 has the same name so I want to sum the values in column I which related to that name and the result appear once at J3
G4 and G7 the same situation as G2.
G8 and G9 has the same name so to sum the values in Column I related to those names and to get the result in G8 only
The desired results are shown in the attachment
Bookmarks