| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"" not completely blanc if copy
I am using this formula in a range; +IF($B100,$C$3,""); if I copy paste
values this to say Data!A10:A40, why if I use counta(A10:A40), and only say A10:A12 actual has data that I can see the answer of the count formula is still 41. I want the formula to leave the cell blank if false. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable Cut & Copy then restore on exiting | Excel Discussion (Misc queries) | |||
| copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
| Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
| Copy shortcut | Excel Worksheet Functions | |||
| Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
Threaded Mode
