#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Minimum Value

Hi, using an accounting format on Row E, I am trying to extract thje lowest
value from E6:E34 where B6:B34 = 2006.

I am using: =MIN($B$6:$B$34,"2006",E6:E34), but Excel is returning a value
for a row that does now have the cell in Column B set to 2006.
Can some kind person tell me what I'm doing wrong please - thanks

A


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Minimum Value

try
=min(if(B6:B34="2006",E6:E34)) entered as an array control-shift-enter

or
=min(if(year(B6:B34)=2006,E6:E34)) entered as an array control-shift-enter

depending on the format of column B (Text or date)

Min by itself does not have a qualifier capability so your equaiton was
looking for the min in B6:B34 and E6:E34

"Alex" wrote:

Hi, using an accounting format on Row E, I am trying to extract thje lowest
value from E6:E34 where B6:B34 = 2006.

I am using: =MIN($B$6:$B$34,"2006",E6:E34), but Excel is returning a value
for a row that does now have the cell in Column B set to 2006.
Can some kind person tell me what I'm doing wrong please - thanks

A



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default Minimum Value

=min(if(b6:b34="2006",E6:e34))

Enter with Ctrl+shift+Enter

Is 2006 text or number: remove quotes if latter.

"Alex" wrote:

Hi, using an accounting format on Row E, I am trying to extract thje lowest
value from E6:E34 where B6:B34 = 2006.

I am using: =MIN($B$6:$B$34,"2006",E6:E34), but Excel is returning a value
for a row that does now have the cell in Column B set to 2006.
Can some kind person tell me what I'm doing wrong please - thanks

A



Reply
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
How to lookup the minimum, 2nd minimum and 3rd minimum......... Mark McDonough Excel Worksheet Functions 8 July 15th 06 09:39 PM
minimum ridash Excel Worksheet Functions 4 June 23rd 06 03:00 PM
Minimum but One?? twogoodtwo Excel Worksheet Functions 3 November 29th 05 03:52 PM
Minimum Value ceemo Excel Worksheet Functions 2 August 9th 05 06:34 PM
second minimum value Ken Excel Discussion (Misc queries) 3 March 16th 05 07:17 PM


All times are GMT +1. The time now is 05:38 PM.

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"