In my spreadsheet I have two values, Column A being 900 and Column B Charlie. When those values in column A and B match I want column C to have a value of Great. If these two values do no match nothing should be populated into column C.
900 Charlie 900 Charlie 650 Charlie
What I want
900 Charlie Great 900 Charlie Great 650 Charlie
Do you mean you want to identify where two or more row records are exactly the same?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi,
If data starts in row 1, then paste this formula in C1 and then drag down. If it starts on another row just change the 1's.
The value part is not needed if A is numerical, but I thought this way both cases are covered.
Formula:
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
I want to identify column A for an exact value of 900 and column B exact for an exact value of Charlie. To then give me a result of Great to be populate into column C
Originally Posted by Arkadi
Hi,
If data starts in row 1, then paste this formula in C1 and then drag down. If it starts on another row just change the 1's.
The value part is not needed if A is numerical, but I thought this way both cases are covered.
Formula:Please Login or Register to view this content.
I'm in need of a macro. The spreadsheet I'm working with cannot have a formula in column C
Last edited by yuenk; 12-07-2016 at 12:44 PM.
I want to identify column A for an exact value of 900 and column B exact for an exact value of Charlie. To then give me a result of Great to be populate into column C
Ok...
Please Login or Register to view this content.
Thank you for taking your time to provide this!
My pleasure
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks