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 |
Excel functions - need some guidance.
assuming values in col K, to get min 14.95
=MIN(K:K) assuming your 1-5 in col H to get 4 =INDEX(H:H,MATCH(MIN(K:K),K:K,0)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Dave" wrote in message ... 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 |
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 |
Excel functions - need some guidance.
|
All times are GMT +1. The time now is 03:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com