Excell help needed

Closed
bjacky2004
Posts
1
Registration date
Wednesday December 7, 2011
Status
Member
Last seen
December 7, 2011
- Dec 7, 2011 at 05:22 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Dec 8, 2011 at 12:12 PM
Hello, I have next problem in Excell, I have columns A1, B1, and C1 with data like this:

A1 B1 C1
ABCDEF 4444 4444
GHIJKLM 4445 4446

Now I want to check whole sheet - IF B1=C1 then COPY A1 to D1, if not do nothing and skip to other row to check.
Thanks for answers! Bob

Maybe it isn't so simple, I need when B anc C columns match each other in numbers, to be A which is to B copied near matching C.



1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Dec 8, 2011 at 12:12 PM
Why not put a formula to do that
In D1 have this formula

=IF( B1=C1, A1, "")
0