I have a spreadsheet I'm trying to use to sort through data on. I have
the data arranged in a chart and I'm using the AND command to sort
though the data. The problem is I'm using the same formula for all the
rows but only some of them work. Here’s the way the data is laid out:


A B C D
1 1
2 1/4
3 1.5
4
5
6
7
8
9
10 1 1/4 1.5 =AND(A10=$A$1,B10=$A$2,C10=$A$3)
11 1 1/4 2 ABOVE FORMULA COPIED TO ALL ROWS
12 1 3/8 2.5
13 1 3/8 3
14 1 1/2 3.5
15 2 1/4 1.5
16 2 1/4 2
17 2 3/8 2.5
18 2 3/8 3
19 2 1/2 3.5
20 3 1/4 1.5
21 3 1/4 2
22 3 3/8 2.5
23 3 3/8 3
24 3 1/2 3.5
25 4 1/4 1.5
26 4 1/4 2
27 4 3/8 2.5
28 4 1/2 3
29 4 1/2 3.5

This will give a solution of TRUE like its supposed to, but if I change
A1 to 2, 3, or 4 it won’t doesn’t work. Anybody know why?


--
KEVIN GUNN
------------------------------------------------------------------------
KEVIN GUNN's Profile: http://www.excelforum.com/member.php...o&userid=24501
View this thread: http://www.excelforum.com/showthread...hreadid=380979

Seems to work to me. What do you mean by, "it doesn't work?" What are
you expecting it to give you?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=380979

By changing the variables in rows 1, 2, and 3 it should just change
which row is TRUE, but if I have anything but 1 in the first variable
it just gives FALSE for all. I think it may be a problem with excel and
not so much my formulas. I could be wrong though. I have more happening
on the same worksheet, if you would like I'll e-mail it to you.
. send a message here and I'll send you
the document.


--
KEVIN GUNN
------------------------------------------------------------------------
KEVIN GUNN's Profile: http://www.excelforum.com/member.php...o&userid=24501
View this thread: http://www.excelforum.com/showthread...hreadid=380979

here is the file...


+-------------------------------------------------------------------+
|Filename: eq calc 3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3521 |
+-------------------------------------------------------------------+

--
KEVIN GUNN
------------------------------------------------------------------------
KEVIN GUNN's Profile: http://www.excelforum.com/member.php...o&userid=24501
View this thread: http://www.excelforum.com/showthread...hreadid=380979