Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Search for Date Search for Date
Register FAQ

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,923
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Perhaps post a sample sheet showing data and desired results?
__________________
Using O365 v2503 - 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-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,923
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
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?
__________________
Using O365 v2503 - 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
  #5  
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: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
.Find and .FindNext in Excel VBA or use filtering.
Last edited by NoSparks; 09-01-2016 at 06:51 PM.
Reply With Quote
  #6  
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
  #7  
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: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
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
Reply

« Previous Thread | Next Thread »


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:19 AM.

Contact Us - Privacy Statement - Top

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