Home |
Search |
Today's Posts |
#1
|
|||
|
|||
EXACT comparison formula
I'm having trouble coming up with a formula to compare specific cells
in a row. I have A1 = TRUE B1 = FALSE C1 = FALSE D1 = TRUE and then A3 = "R" B3 = "" C3 = "E" D3 = "R" I would like to have a TRUE/FALSE in column E representing the evaluation of EXACT on that row; only comparing cells if Row 1 has a TRUE in it. Array entering =AND(EXACT(A3,A3:D3)) in D4 includes C3 and B3 in the example above. How can I modify this formula? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dragging a formula | Excel Discussion (Misc queries) | |||
EXACT formula | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions |