Column B just gives me random numbers.

Max wrote:
In Sheet2, the dynamic results should appear in col B.
(Col A is the criteria, hide it away, as mentioned)
Give it another try. I tested it fine over here. It dhould work over there.
I'm getting what appear to be random numbers from these formulas.

--
Message posted via http://www.officekb.com