Mark Wilson
asked on
Lookup Values
Hi
I have an excel sheet with values like the following
A B C
Number Type Created
123 Call Opening 26/09/2017
123 Show 26/09/2017
123 Total 26/09/2017
124 Call Opening 05/10/2017
124 Show 05/10/2017
124 Total 05/10/2017
I need to bring to sheet 2 values where created is in the last month and where type = 'Total' only
From the above example the output would be
A B Created
Type Number Date
Total 123 26/09/2017
Using excel 2010
Thanks
I have an excel sheet with values like the following
A B C
Number Type Created
123 Call Opening 26/09/2017
123 Show 26/09/2017
123 Total 26/09/2017
124 Call Opening 05/10/2017
124 Show 05/10/2017
124 Total 05/10/2017
I need to bring to sheet 2 values where created is in the last month and where type = 'Total' only
From the above example the output would be
A B Created
Type Number Date
Total 123 26/09/2017
Using excel 2010
Thanks
Roy Cox
ttach an example workbook
ASKER
Example spreadsheet attached
Example.xlsx
Example.xlsx
Will there be multiple items to find?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes there will be multiple items to find
ASKER
Neeraj - thanks for the workbook this worked fine - is there anyway to limit it by last months data only - using the created date - i.e. for October will show Septembers data, for November October etc. Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Chosen answers resolved the original question.