Thanks a lot Roger
I will try with this



Roger Govier Wrote:
Hi

In a cell, say C1 enter your Minimum value AAA_0001
In D1 enter you rmax value AAA_1000

then the test is
=AND(A1$C$1,A1<$D$1)

Your value of AAA_560.1 would return FALSE, but AAA_0560.1 woul
return
TRUE


--
Regards

Roger Govier



Jayanthi
wrote:
I am having the minimum and maximum values in two columns in a
excel
spread sheet.I need to check whether the given value falls betwee
the
maximum and minimum values.

For e.g Minimum column contains value like AAA_0001 and Maximu
column
contains AAA_1000
Let the given value be AAA_560.I need to check whether this value is
between those two columns.
Could anyone help me out in solving this .....?


regards
Jayanthi


--
Jayanthi

------------------------------------------------------------------------
Jayanthi's Profile:
http://www.excelforum.com/member.php...fo&userid=3003
View
this thread: http://www.excelforum.com/showthread.php?threadid=49722

--
Jayanth
-----------------------------------------------------------------------
Jayanthi's Profile: http://www.excelforum.com/member.php...fo&userid=3003
View this thread: http://www.excelforum.com/showthread.php?threadid=49722