LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 275
Default Lookup function in Excel

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Lookup function Howard Excel Worksheet Functions 10 November 30th 08 09:41 PM
Help with Excel lookup function please Victor Delta[_2_] Excel Discussion (Misc queries) 12 September 11th 08 10:53 PM
advanced use of the Excel lookup function Norm Excel Discussion (Misc queries) 2 October 12th 06 01:27 PM
Lookup function in Excel Feldy Excel Worksheet Functions 4 February 17th 05 04:25 PM
IF/ LOOKUP FUNCTION - Excel 2000 Chandrashekhar Excel Worksheet Functions 3 November 5th 04 11:02 AM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"