Excell help needed

[Closed]
Report
Posts
1
Registration date
Wednesday December 7, 2011
Status
Member
Last seen
December 7, 2011
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Why not put a formula to do that
In D1 have this formula

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