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: 1
Default Returning the smallest value above a certain criteria

Hi - I have the following array of data, where the top row is the year worked
and the following rows are number of hours worked by employees in that year.
In the last column, I would like to return either a) the first year in which
the employee worked more than 999.99 hours or b) if the first is too
complicated, the number of hours that first exceed 999.99 (and from there
I'll do a look up to figure out the year). In the example, I would like to
return either a) "2001" as the year the employee first worked over 1,000, or
b) 1002 hours (first time that a number over 999.99 appears in the array). I
am stumped, although I suspect the solution isn't that complicated. Thanks
for your suggestions

2000 2001 2002 2003 2004 2005
26 1002 999 1500 1001 990
90 600 800 14 10 1600

 
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
Returning cell value if 2 criteria are met D Zandveld New Users to Excel 4 September 23rd 08 01:02 AM
MULTIPLE CRITERIA RETURNING SUM OF RESULTS [email protected] Excel Worksheet Functions 5 November 15th 06 06:21 PM
MULTIPLE CRITERIA RETURNING SUM OF RESULTS [email protected] Excel Worksheet Functions 0 November 15th 06 05:11 PM
returning blank cell in criteria o Joop Excel Discussion (Misc queries) 3 June 3rd 05 02:11 PM
returning a value based on mulitple criteria Brad Excel Worksheet Functions 6 December 31st 04 08:14 AM


All times are GMT +1. The time now is 05:48 AM.

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

About Us

"It's about Microsoft Excel"