Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc, microsoft.public.excel,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
Excel functions - need some guidance.
Hi. I assume that I'm missing something with functions here. Suppose
I've got the following data... Item # Type Qty Value 1 baseball 52 $40.00 2 football 31 $32.95 3 basketball 68 $107.35 4 tennis 4 $14.95 5 hockey 35 $39.50 I've used DMAX, DMIN, and DAVERAGE respectively, to return the max, min, and avg values in the table, i.e. Max Value = $107.35 Min Value = $14.95 Avg. Value = $46.95 But now I want to indicate the Item # next to the returned Max Value and Min Value, so I'd have the following: Max Value = $107.35 (3) Min Value = $14.95 (4) Avg. Value = $46.95 How do I set up a function to return the (3) and (4)? Specific instructions would be most appreciated! Thanks, Dave |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel functions - need some guidance.
You can use vlookup function..
"Dave" wrote: Hi. I assume that I'm missing something with functions here. Suppose I've got the following data... Item # Type Qty Value 1 baseball 52 $40.00 2 football 31 $32.95 3 basketball 68 $107.35 4 tennis 4 $14.95 5 hockey 35 $39.50 I've used DMAX, DMIN, and DAVERAGE respectively, to return the max, min, and avg values in the table, i.e. Max Value = $107.35 Min Value = $14.95 Avg. Value = $46.95 But now I want to indicate the Item # next to the returned Max Value and Min Value, so I'd have the following: Max Value = $107.35 (3) Min Value = $14.95 (4) Avg. Value = $46.95 How do I set up a function to return the (3) and (4)? Specific instructions would be most appreciated! Thanks, Dave |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel functions - need some guidance.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Excel Expert Certification Guidance | Excel Discussion (Misc queries) | |||
Need some guidance | Excel Worksheet Functions | |||
After much help from this forum, I still some guidance... | Excel Discussion (Misc queries) | |||
Architectural guidance, please | Excel Discussion (Misc queries) | |||
Incorrect Japanese guidance with Excel 2003 | Excel Worksheet Functions |