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

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
--
Gary's Student
gsnu200704


"srain001" wrote:

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

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!

In article ,
srain001 wrote:

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

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)


"srain001" wrote:

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