Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-05-2015, 12:40 PM
Wii Wii is offline How to search for a specific year from a table with year range? Windows 7 64bit How to search for a specific year from a table with year range? Office 2010 64bit
Novice
How to search for a specific year from a table with year range?
 
Join Date: May 2015
Location: California
Posts: 1
Wii is on a distinguished road
Default How to search for a specific year from a table with year range?

Hi, can anyone help? Please see below message and attached snapshot.



Purpose: to show all cell that contains year 2014 by search 2014.

The 1st table is the original data.

The 2nd table is showing after search by 2014

The 3rd table is the result I'm trying to get by search by 2014. How can I achieve this?

Thank you!
Attached Images
File Type: png Excel_Question_Search_specific_Year.png (13.3 KB, 13 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate a rolling year-to-date percentage by quarter as the year progresses sleake Excel Programming 2 04-23-2015 11:51 AM
How to search for a specific year from a table with year range? Spread whole number across specific months in a year rkobeyer Excel Programming 2 10-18-2014 11:46 PM
How to search for a specific year from a table with year range? Networkdays per fiscal year in a 6 year range jabnm Excel 1 10-16-2014 11:51 AM
Year to Year in Fillable form Lara Word 1 04-09-2013 03:19 PM
Creative Ways for a year-to-year comparison??? ridonkulous5 Excel 1 03-23-2011 04:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:14 AM.


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