formula help

[srain001]

Hello,

I was wondering if there was a way to create a formula which captured
information from two separate cells in two separate columns but allowed you
to capture every time these two fields are in the same row. For example

Column A Column B
A 1
B 2
C 3
D 4

I would need a formula which would capture every time that "A" and "4" are
in the same row at any given time.

Hope you can help!

Thanx!

Srain

 

[Gary''s Student]

In a helper column, enter:

=A1&B1 and copy down

Then apply AutoFilter and you will be able to locate every row in which the
helper is A4

 

[Domenic]

To count the number of times a cell in Column A equals "A", and the
corresponding value in Column B equals 4, try...

=SUMPRODUCT(--($A$1:$A$4="A"),--($B$1:$B$4=4))

Hope this helps!

 

[john the confused]

If you want the result in another column you could use
=IF(AND(A2="A",B2=4),"match","no match") & drag it down.

--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)