Thread: How to search for a specific year from a table with year range?
View Single Post
 
Old 05-05-2015, 12:40 PM
Wii Wii is offline Windows 7 64bit Office 2010 64bit
Novice
  
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, 15 views)
Reply With Quote