Hi all, is there a way to put below logic:
1) If number in column A = # in column B then in column C comment "OK"
2) next I would drag the formula down for thousand rows, but I want it to not overwrite if something is in column C already, basically populate comment "OK" only for blank cells
Any help is much appreciated
thanks so much
in column D
=IF(C1<>"",C1,IF(A1=B1,"OK",""))
Copy column D
Paste values back over column D
Now delete column C if you like as column D is the result you wanted
Regards
Special-K
I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.
To skip any cells that currently have something in them...
1) Enter your formula in the first cell
2) Copy that cell
3) Highlight the full range of cells downward
4) Press F5, click on Special > Blanks > OK
5) Press Ctrl-Enter
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
hmm =IF(C1<>"",C1,IF(A1=B1,"OK","")) does not work..just returns blank cells.. should this work in excel 2003?
Using this technique, the formula I would use in C1 (for step #1 above) is:Originally Posted by JBeaucaire
=IF(AND(A1<>"", A1=B1), "OK", "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks