| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to clear cell based on text in other column
I am attempting to clear a cell in column V based on the text of the
same row in column G. With actual numbers, I can do SUMIF(G9:G123,"5",V9:V123) - but I want to actually clear the respective cell in V if "payments" is in column G, and leave it alone if blank or other text exists. How can I do that? DLR |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to clear cell based on text in other column
Pls post in ONE group ONLY. See ans in your other post -- Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ... I am attempting to clear a cell in column V based on the text of the same row in column G. With actual numbers, I can do SUMIF(G9:G123,"5",V9:V123) - but I want to actually clear the respective cell in V if "payments" is in column G, and leave it alone if blank or other text exists. How can I do that? DLR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a column based on the length of text in a cell in anothercolumn | Excel Worksheet Functions | |||
| clear cell based on text in opposing column | Excel Worksheet Functions | |||
| Clear cell based on shading | Excel Programming | |||
| Formatting Cell Based on Text in Column Beside It - Round 2 | Excel Programming | |||
| Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming | |||
Linear Mode
