Lookup help (hlookup,vlookup,lookup??)

[jpleau]

I have a beautiful spreadsheet that is exported from Crystal 8.0. It has columns with groups 1 through 15 for 100 rows of records. Record 1 may have numbers in Group 1, 2 and Group 7, while Record 7 may have numbers in Group 3, 6, 8 and 15.

I would like to develop 6 columns (from the 15) by selecting the 3 highest numbers of each record, and I would like to display the column heading (i.e. group 1, group 2) in the column (and row) directly before the high number display.

|GROUP1|100.00|GROUP2|700.00|GROUP7|200.00

TIA

jillybean

 

[Juan Pablo González]

Hi, welcome. Can you post your some example of your source data ? it's not clear what you have, and it's not clear how you want it... some examples might work.