View Single Post
  #1  
Old June 22nd, 2004, 10:32 PM
foolio
external usenet poster
 
Posts: n/a
Default Picking out the max

Okay I have a table like this.

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

I want to pick out the biggest dollar value for each part number and
write it by the part number.

For instance

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

Any way of doing this ?

And something else I would like, although not necessary is on the last
section you will notice that I would like only one of them to have the
66.61 printed beside it.

Chow


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