Hi

In column A, I have names that appear as ABC 01, ABC 02,ABC 03, I want to sum
the group ABC, XYZ or any other groups which appear in the column A and put
a value in column B depending on the sum total figure. For example, if the
total sum
for ABC is more than 100, all the entries in the column B related to ABC, ie
ABC 01, ABC 02, ABC 03.....so on, will have a Y in the respective rows,
otherwise, N will be input in the related entries.

Thanks in advance.

regards, xlsops