If statement in Excel looking for text
Closed
xmtler
Posts
1
Registration date
Sunday November 22, 2009
Status
Member
Last seen
November 23, 2009
-
Nov 23, 2009 at 01:31 PM
Conner - Apr 29, 2011 at 04:12 PM
Conner - Apr 29, 2011 at 04:12 PM
Related:
- If statement in Excel looking for text
- Fenix internet on bank statement - Guide
- Excel if statement - Guide
- An if statement nested within another if statement will produce how many possible results? - Guide
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 23, 2009 at 08:17 PM
Nov 23, 2009 at 08:17 PM
see whether you can do this
highlight column A (this column should heave column heading)
click date(men bar)-filer-autofilter
there will be small arrow in the column heading of column A
click that arrow
click "pencil" in download list
you will get pencil filtered. highlight the visible cells and copy anywhere
click <all> in the download box
again repeat same steps for eraser.
lastly click date-filter-autofitler
the filter will be removed.
highlight column A (this column should heave column heading)
click date(men bar)-filer-autofilter
there will be small arrow in the column heading of column A
click that arrow
click "pencil" in download list
you will get pencil filtered. highlight the visible cells and copy anywhere
click <all> in the download box
again repeat same steps for eraser.
lastly click date-filter-autofitler
the filter will be removed.
Apr 29, 2011 at 04:12 PM
That was just a quick shot, you will need to play with the parenthesis.
Hope this helps.
-Conner
http://www.oneclickcommissions.com/excel-statements.html