bio | website | |
---|---|---|
location | ||
age | ||
visits | member for | 1 year, 11 months |
seen | Apr 26 '13 at 6:02 | |
stats | profile views | 9 |
Dec 23 |
awarded | Famous Question |
Nov 28 |
awarded | Notable Question |
Sep 11 |
awarded | Popular Question |
Apr 25 |
comment |
If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it?
Yes you're right, I understand you. The formula that you wrote down suited me exactly what I need. Thank you for your patience and explanation :) |
Apr 25 |
accepted | If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it? |
Apr 24 |
comment |
If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it?
Or possible to combine it with formula ---> =RIGHT(A1, LEN(A1)-1) |
Apr 24 |
awarded | Commentator |
Apr 24 |
comment |
If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it?
By the way: I found a formula that does something similar, so seems logical to me possible to do what I wanted. ---> Delete A1 cell if B1 is empty: =IF(ISBLANK(B1),"",A1) |
Apr 24 |
comment |
If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it?
There is still a way to somehow do something like this with a formula? (Somehow trick on him) [because in my work I can only use formula] |
Apr 24 |
revised |
If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it?
added 14 characters in body |
Apr 24 |
asked | If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it? |
Apr 22 |
accepted | How to compare non-similar words (excel formula) |
Apr 22 |
comment |
How to compare non-similar words (excel formula)
I'm speechless. Thank you. I mean it. Thanks for the help & explanation. It helped me a lot in my work. :) |
Apr 22 |
comment |
How to compare non-similar words (excel formula)
OK excellent!!! most Appreciate!!! :))) |
Apr 22 |
comment |
How to compare non-similar words (excel formula)
OK your right-it works great. I didn't notice, my mistake. CAN YOU PLEASE EXPLAIN A BIT THE FORMULA SO I UNDERSTAND? thanks... |
Apr 22 |
comment |
How to compare non-similar words (excel formula)
I tried it again and it still doesn't work. I used office 2003 if this matter. MY snapshot: oi34.tinypic.com/16c3rle.jpg |
Apr 22 |
comment |
How to compare non-similar words (excel formula)
I didn't understand the: ctrl+shift+enter , and your formula - it doesn't work :( |
Apr 22 |
comment |
How to compare non-similar words (excel formula)
I didn't understand the: ctrl+shift+enter , and your formula - it doesn't work :( |
Apr 21 |
comment |
How to compare non-similar words (excel formula)
Dear Siddharth Rout, I don't understand your answer & I tried it anyway and It doesn't work :( |
Apr 20 |
awarded | Scholar |