Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting Cell Information Automatically
Is it possible to delete information in cells from a certain column by
changing the information in a Cell from a different column using a formula? Or does it have to be via VB? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting Cell Information Automatically
Hi,
do you have formula in the cells you want to delete the information ??, if yes you can add something like this =if(A1="Delete"0,"",your formula) A1 is the cell you need to look for the results ="Delete", change it to fit your needs, it might be a number in the case of a number don't enclose the number between "" =if(A1=123,"",.................................... .....) "Brett" wrote: Is it possible to delete information in cells from a certain column by changing the information in a Cell from a different column using a formula? Or does it have to be via VB? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting Cell Information Automatically
Hey thank you for your reply. I just realised that i did not phrase what i
wanted to say correctly and gave little information. I just realised that i cannot enter a formula into the column that i want to delete because i want to enter different values. I apologise that none of this really makes sense but i cannot explain it throroughly enough to provide the information without explaining my whole situation that i don't have enough time to do. However, thank you very much for your reply and i may use that formula for another part of my project. "Eduardo" wrote: Hi, do you have formula in the cells you want to delete the information ??, if yes you can add something like this =if(A1="Delete"0,"",your formula) A1 is the cell you need to look for the results ="Delete", change it to fit your needs, it might be a number in the case of a number don't enclose the number between "" =if(A1=123,"",.................................... .....) "Brett" wrote: Is it possible to delete information in cells from a certain column by changing the information in a Cell from a different column using a formula? Or does it have to be via VB? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add data without deleting information in cell | Excel Discussion (Misc queries) | |||
Globally deleting part of the information in a cell | Excel Worksheet Functions | |||
deleting information from a cell | Excel Discussion (Misc queries) | |||
Deleting the same character automatically in each cell | Excel Worksheet Functions | |||
How can I make cell data automatically shift up when deleting... | Excel Worksheet Functions |