# Maximum/Minimum value from range and then from cell color

1. ## Maximum/Minimum value from range and then from cell color

 3.6 Formula Range 4.02 3.97 3.93 3.89 3.8 3.68 3.3 3.7 3.69 3.79 3.72 3.72 3.74 3.61 3.58 3.5 3.6 3.5 3.55 3.57

I want to take a value in Cell "A2" that is less then or equal to the value in cell "A2" from range of "E2:W2"
The problem is, there are 6 values which are that are less then or equal to 3.6
I only want to take the value which comes first by using a formula.

2. ## Re: Maximum/Minimum value from range and then from cell color

welcome to the forum
=IFERROR(INDEX(E2:W2,MATCH(TRUE,INDEX(E2:W2<=A2,0),0)),"")
try this

3. ## Re: Maximum/Minimum value from range and then from cell color

Or perhaps this...
=MIN(A2,INDEX(\$E\$2:\$X\$2,MATCH(SMALL(\$E\$2:\$X\$2,1),\$E\$2:\$X\$2,0)))

4. ## Re: Maximum/Minimum value from range and then from cell color

Originally Posted by nflsales
welcome to the forum
=IFERROR(INDEX(E2:W2,MATCH(TRUE,INDEX(E2:W2<=A2,0),0)),"")
try this
Nflsales thanxxx

This worked like a charm can you please also explain me the syntax of this formula how it worked

5. ## Re: Maximum/Minimum value from range and then from cell color

Originally Posted by FDibbins
Or perhaps this...
=MIN(A2,INDEX(\$E\$2:\$X\$2,MATCH(SMALL(\$E\$2:\$X\$2,1),\$E\$2:\$X\$2,0)))
Thank you for trying but it did not worked. it is only taking minimum value

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1