Hi I am trying to bulti a formula to compare both the values in column A and the compare the corresponding values in column B. Please help me as i am really stuck. Find the attached file to use as a reference.
Hi I am trying to bulti a formula to compare both the values in column A and the compare the corresponding values in column B. Please help me as i am really stuck. Find the attached file to use as a reference.
Hello.
There are two sheets with the same company names but with different values next to them. What exactly do you want to compare? How do you want to do it? File with your vision of result (just numbers and how you operate with them manually) will be helpful.
Best wishes and have a nice day!
Adding this formula in C2 and copy down of sheet2 will gives you a false or a true result. Is this what are you looking for?
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks