Forum Discussion
Solved
Grab specific information based on the month
I'm trying to grab specific information that is given to me for only specified months. I have messed around with a bunch of functions to try and achieve this but have had no luck. I was wondering if ...
The attached file shows an easy way to extract the data (for thousands of parts if required) for November 2023 and November 2022. For other months the formulas have to be adapted however e.g. for November 2023 the formula is
=INDIRECT(ADDRESS(MATCH(J9,A:A,0)+4,2))
and for August 2013 it would be
=INDIRECT(ADDRESS(MATCH(J9,A:A,0)+7,2))
The attached file shows an easy way to extract the data (for thousands of parts if required) for November 2023 and November 2022. For other months the formulas have to be adapted however e.g. for November 2023 the formula is
=INDIRECT(ADDRESS(MATCH(J9,A:A,0)+4,2))
and for August 2013 it would be
=INDIRECT(ADDRESS(MATCH(J9,A:A,0)+7,2))
- This works great and in a way that seems so simple. It takes a second to set up but it's better then doing it manually. I was trying so many different functions and combinations. I will read up more about these functions as they probably going to get used for other things in the future.
Thank you for this!
