This is what I am trying to do based on the table below...
a b c
FALSE
FALSE 0080
TRUE 0080
TRUE 0080
TRUE 0080
TRUE 0080
TRUE 0080
TRUE 0080
The results I want to insert in column "c".
If a is "FALSE" and b is "blank" then c = "H"
If a is "FALSE" and b is "any value" then c = "D"
If a is "TRUE" and b is "any value" then c = "D1"
The table has over 500k rows. What are my options? Thanks!
RM
Last edited by rpmulli; 06-04-2012 at 06:34 PM.
=IF(AND(A1=FALSE,B1=""),"H",IF(AND(A1=FALSE,B1<>""),"D",IF(A1=TRUE,"D1","")))
and copy down?
If I've been of help, please hit the star
That worked perfectly! Now another issue... This data table is very large.... Everytime I sort a column and try to copy and paste it I get this message/error. Any ideas?
error.jpg
If I had a dollar for every time I've seen that message I'd be a very rich man!
Excel has its limitations and when you're dealing with such large numbers of rows and use filters, it often cannot cope with copying and pasting or dragging formulas.
Options are to conduct your actions in chunks or get a much higher spec computer!
Haha, disregard... I read a few threads on this after I posted.Originally Posted by Spencer101
If I had a dollar for every time I've seen that message I'd be a very rich man!
Excel has its limitations and when you're dealing with such large numbers of rows and use filters, it often cannot cope with copying and pasting or dragging formulas.
Options are to conduct your actions in chunks or get a much higher spec computer!
Well glad I could be if help on the original post
I don't think the formula provided fulfills the third scenario.
The formula will return D1's value when A1 is TRUE but does not test for B1 having a value. Shouldn't that third condition also be in an AND()?
Actually, D1 is going to be TRUE regardless if there is a value in c column
Nice to see pedantry isn't dead
And on that note, scenarion3 returns the value D1 rather than the value of D1.
Admittedly I agree with you and the formula should have another AND to say A1=TRUE and B1<>”” but the OP seemed happy enough...
OP has changed the scenario so MOOT is the word.
And a great word at that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks