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/