Previous Topic Next Topic

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 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Excel help!
Jo -
rizvisa1 -

1 response
help in excel
mnbvc -
mnbvc -

2 responses
Score predictor in excel help??
alandiamond -
rizvisa1 -

1 response
need help going down a line in Excel VBA
mndude -
ac3mark -

1 response
How to hide text in a Excel cell and display it when needed
john_thomas -
TrowaD -

1 response