Hi,

I am faced with this problem. I have data as follows:

Col1 Col2 Col3
S1 H1 Value 1
S1 H2 Value 2
S2 H1 Value 3
S2 H2 Value 3

I need to roll this data up so that I get
ColR1 ColR2
S1 "Multiple"
S2 Value3

Basically if S1 has multiple values then shown "Multiple". If it has the
same value for all occurrences, as is the case for S2, show that value.

These are formulas with dynamic data which I need to calculate
automatically. I cannot use a pivot table. I do not want to use a macro
unless I have to.

I tried to think of a logic saying if min(value)<max(value), but these
functions only work with numeric data.

Please help.