Thread
:
Picking out the max
View Single Post
#
2
June 22nd, 2004, 11:43 PM
pikapika13
external usenet poster
Posts: n/a
Picking out the max
Assuming worksheet is sorted by Column A first, then Column B (like you
have in your example)...
enter this in C1 and auto copy down.
=IF(AND($A1=$A2,$B1$B2),"",$B1)
---
Message posted from
http://www.ExcelForum.com/
pikapika13