Excel calculating based on new/unique row entry

[ucistudent]

Hello,

Say I have this data set (very small representation of what i really have)

1 2
1 2.5
1 4
1 5
2 7
2 8
3 5
3 6
3 7
3 8

I need to make excel recognize that whenever there is a new entry, say new entry 3, to calculate the difference between the maximum value from its corresponding column to its minimum. So in the case of entry 3, 8-5 =3. I can't have a pattern recognition since the number of times an entry stays at same value, is not constant.

One thing to know, whenever there is a new row entry in column one, the first corresponding value will always be the lowest, and the last corresponding row will always be the largest.

I appreciate any help on how I can program excel to carry this out (my actually data set has 5 columns, and 30,000 rows !)


-Reza

[martindwilson]

will the entries always be numbered? as you have 11122333333

[ucistudent]

yes, the new rows will always have a number which will be repeatable a random amount of time.

[martindwilson]

not sure but try maxif-minif arrays see attached may be a tad slow with 1000's of rows

[ucistudent]

Thank you for the reply
I'm not quite sure if that solves.
I need a value for each set of unique entries.

[martindwilson]

get a list of unique entries using advanced filter then reference those