If they are in fact sorted then your second answer from

"pikapika13 " wrote ..
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)

already holds your answer, add another column
or change the above:
=IF($A1=$A2,"","-- Last")

or you could use conditional formatting and highlight the
row in yellow instead or as well
entering formula with the active cell on row 1
formula is: =$A1$A2
or if you had a header row and did not want it to be
highlighted
formula is: =AND(Row()1,$A1$A2)
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"foolio " wrote in message ...
Unfortunatly I can't download anything onto my server...

But I thought of a new way of looking at this that may work a little
better. You notice that the last price for each part number is always
the highest because of how it is sorted.

0907086 -- $40.54
0907086 -- $41.74
0907086 -- $47.70 --
0907095 -- $45.96
0907095 -- $47.31
0907095 -- $54.06 --
0907102 -- $40.54
0907102 -- $41.74
0907102 -- $47.70 --
0907111 -- $56.62
0907111 -- $58.28
0907111 -- $66.61 --

Is there a way to just figure out which part number is the last in the
list and tag it somehow.

0907086 -- $40.54
0907086 -- $41.74
0907086 -- $47.70 -- Last
0907095 -- $45.96
0907095 -- $47.31
0907095 -- $54.06 -- Last
0907102 -- $40.54
0907102 -- $41.74
0907102 -- $47.70 -- Last
0907111 -- $56.62
0907111 -- $58.28
0907111 -- $66.61 -- Last

Something like that ? Then I could just sort by Column C and I would
have my list....


---
Message posted from http://www.ExcelForum.com/