| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy corresponding cell if value is 0
Hi,
How can I copy corresponding cell if value in Col E 0..? Something like below. Col D |Col E ABC |12 MNO |2 HTR |0 UTV |0 HNC |5 XYZ |6 QTR |2 GTR |0 MTR |8 Result: Col D |Col E ABC |12 MNO |2 HNC |5 XYZ |6 QTR |2 MTR |8 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy worksheet1 to worksheet2, keep cell format eg cell size | Excel Discussion (Misc queries) | |||
| copy selected part number of text from one cell into another cell | Excel Discussion (Misc queries) | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
Threaded Mode
