Hi,

I have one column with numbers, can be repeated or missing - e.g. 1,1,1,1 -
2 - 3,3,3,3,3 - 5,5 - 6 - 8,8,8 etc. highest number is 10, but list can be
up to 250 rows. A second column has percentages for each entry in the first
column, can be repeated within a number group - e.g. 65,68,65,54 - 48 -
76,49,76,54,76 - 68,69 - 90 - 42,43,44 (percentages can actually be to 2
decimal places, simplified for example). Into a third column I want to
insert a number, 1 for the maximum or equal maximum within a number group
and 0 for all others. Results for the example would be as follows: 0,1,0,0 -
1 - 1,0,1,0,1 - 0,1 - 1 - 0,0,1

would be grateful for any help with a Vba solution for this

Steve W