What's going on??? You posted at 4:58pm on 6/22/04 that the solution
posted by pikapika13 at 3:43pm that day "works like a charm". So why
are we still talking about it?

Alan Beban

foolio wrote:

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/