Find the minimum value from a range in multiple columns

**newbi004** · 02-14-2013, 10:36 AM

Hi

I just can't seem to get this sorted! I am trying to find the minimum value from a range which is across a number of columns. I have a range named LabourRange and am getting a Value error when I use the following formulae:

Please Login or Register  to view this content.

It works when I use a single row of data, but gives the error when I use multiple columns.

Can anyone advise what I am doing wrong?

Thanks

**bebo021999** · 02-14-2013, 10:47 AM

Where does LabourRange made from?

If LabourRange is a specific range in spreadsheet, that is OK (i.e: A1:C3). But if it is made from a formula (i.e: If(A1:C3>1,A1:C3,"")), COUNTIF(LabourRange,0)

will not work.

**newbi004** · 02-14-2013, 11:01 AM

Hi Quang

Thanks for the quick reply.

The range is selected using the Name Manager from a sheet. However the range is not A6:F15. It is A6:A15,C6:C15,E6:E15,F6:F15

Would this create an error?

Thanks

**bebo021999** · 02-14-2013, 11:13 AM

Sure this kind of range causes problem with COUNTIF. If possible, pls upload an example file to see what we can do with it,

**daddylonglegs** · 02-14-2013, 11:21 AM

This version will work with LabourRange when that range is defined as unconnected ranges

=SMALL(LabourRange,INDEX(FREQUENCY(LabourRange,0),1)+1)

**newbi004** · 02-14-2013, 12:13 PM

Great! Thanks daddylonglegs!! It worked. I would never have come up with that one.

Find the minimum value from a range in multiple columns

LinkBack

Thread Tools

Rate This Thread

Display

Find the minimum value from a range in multiple columns

Re: Find the minimum value from a range in multiple columns

Re: Find the minimum value from a range in multiple columns

Re: Find the minimum value from a range in multiple columns

Re: Find the minimum value from a range in multiple columns

Re: Find the minimum value from a range in multiple columns

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions