Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a large spreadsheet, and I am attempting to aggregate data contained
in this spreadsheet. Here is what I am trying to do: I have labels across the top row of the spreasheet. The spreadsheet is set up like this: ABCDEFG 1 11345 2 12145 3 12341 What I'd like to do is determine for each row, what the minimum value is, the number of instances the minimum value is achieved, and the corresponding value for the first row ON THE LAST OCCASION OF THE MINIMUM VALUE going from left to right. FOr example, if the function I am trying to use were entered correctly, it would return (for Row 1) a minimum value of 1 that is recorded on two instances AND the final instance occurs at Column B (top row of values). Similarly for row 3, my function would return a minimum value of 1 that is recorded on two instances AND the final instance occurs at Column E (note that in my example above, things might not line up). In any event, any help would be greatly appreciated. Many thanks -- Anthony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Lookup function | Excel Worksheet Functions | |||
Help with Excel lookup function please | Excel Discussion (Misc queries) | |||
advanced use of the Excel lookup function | Excel Discussion (Misc queries) | |||
Lookup function in Excel | Excel Worksheet Functions | |||
IF/ LOOKUP FUNCTION - Excel 2000 | Excel Worksheet Functions |