#1
|
|||
|
|||
Search for Date
Hi there,
So I have a column that has all dates in them & I want to be able to search for all rows that have those dates. How can I do that? Thanks |
#2
|
||||
|
||||
Perhaps post a sample sheet showing data and desired results?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
No I'm sorry, I am not providing a SS of my excel file which is information only for my eyes.
I don't understand why you can't just visualize what I'm saying. There's a column & I insert the current date every time I make a note. I want to be able to search for comments only on the dates I need to find. |
#4
|
|||
|
|||
.Find and .FindNext in Excel VBA or use filtering.
Last edited by NoSparks; 09-01-2016 at 06:51 PM. |
#5
|
|||
|
|||
Ok, I already tried find/replace & it doesn't find them.
How do I use filtering? Thanks |
#6
|
|||
|
|||
Quote:
http://lmgtfy.com/?q=Excel+2010+how+to+use+filters |
#7
|
||||
|
||||
Perhaps post a small mock up with some similar data, and expected results?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Use CSV as search criteria for Outlook search folder | lonesoac0 | Outlook | 0 | 03-07-2016 02:31 PM |
Onenote 2013 search is not identifying search terms correctly | Delta223 | OneNote | 0 | 08-12-2014 06:40 AM |
Search for date and then apply mutliple search criteria in huge dataset | maxtymo | Excel | 2 | 12-01-2013 04:52 AM |
2013 search results take a long time - they fill in as results in reverse date order | themookman | Outlook | 0 | 10-11-2013 12:01 PM |
Looking for Windows Search app with ability to search by content | gopher_everett | Office | 1 | 02-28-2013 09:23 PM |