Posted to microsoft.public.excel.worksheet.functions

Alex

external usenet poster

Posts: 11

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 02: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 06:17 PM

All times are GMT +1. The time now is 03:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us