Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2016, 12:19 PM
ep2002 ep2002 is offline Search for Date Windows 7 64bit Search for Date Office 2010 64bit
Advanced Beginner
Search for Date
 
Join Date: Jun 2012
Posts: 83
ep2002 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-01-2016, 12:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Search for Date Windows 7 64bit Search for Date Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 09-01-2016, 10:53 AM
ep2002 ep2002 is offline Search for Date Windows 7 64bit Search for Date Office 2010 64bit
Advanced Beginner
Search for Date
 
Join Date: Jun 2012
Posts: 83
ep2002 is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 09-01-2016, 03:04 PM
NoSparks NoSparks is offline Search for Date Windows 7 64bit Search for Date Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

.Find and .FindNext in Excel VBA or use filtering.

Last edited by NoSparks; 09-01-2016 at 06:51 PM.
Reply With Quote
  #5  
Old 09-02-2016, 06:39 PM
ep2002 ep2002 is offline Search for Date Windows 7 64bit Search for Date Office 2010 64bit
Advanced Beginner
Search for Date
 
Join Date: Jun 2012
Posts: 83
ep2002 is on a distinguished road
Default

Quote:
Originally Posted by NoSparks View Post
.Find and .FindNext in Excel VBA or use filtering.
Ok, I already tried find/replace & it doesn't find them.

How do I use filtering?

Thanks
Reply With Quote
  #6  
Old 09-02-2016, 10:26 PM
NoSparks NoSparks is offline Search for Date Windows 7 64bit Search for Date Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Quote:
How do I use filtering?
Not knowing what you're working with nor the layout of your data, I'm afraid this link is all I can suggest

http://lmgtfy.com/?q=Excel+2010+how+to+use+filters
Reply With Quote
  #7  
Old 09-03-2016, 04:03 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Search for Date Windows 7 64bit Search for Date Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by ep2002 View Post
I don't understand why you can't just visualize what I'm saying.
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
Reply With Quote
Reply



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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft