| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
clear cell based on text in opposing 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing opposing pages | Excel Discussion (Misc queries) | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| Clear Cell based on event w/o macro? | Excel Worksheet Functions | |||
| How do I clear blank space at the top of a word-wrapped text cell? | Excel Discussion (Misc queries) | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Threaded Mode
