Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter & clear cells
Hi all,
I apologise for the delay, time difference, below is an example; I need to sort by #N/A which was a formula, but copyied and then pasted as special-values only. I then need to clear the cells v to AB ONLY as all the other cells in the same row have data that i require V W X Y Z AA AB 2163254 11 01 18-Apr-05 J N #N/A 11 #N/A 21-Jan-04 2078426 11 01 18-Mar-05 J J 2078427 11 01 10-Jan-05 J J 2077697 11 01 03-Mar-05 J J 2028870 11 01 23-Mar-05 J J 1933445 11 01 14-Dec-04 J J Hopefully this will help Tempy *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I clear an Advanced Filter | Excel Worksheet Functions | |||
The clear filter from a a heading cell is grey out | Excel Worksheet Functions | |||
Clear Auto Filter on Close (or open) | Excel Discussion (Misc queries) | |||
How to clear advanced filter in excel | Excel Discussion (Misc queries) | |||
Excel Formulas to Clear/Match/Filter Entries | Excel Programming |