Hello,
I would like to make a formula like Index-Match or any other idea to return with all results from the Dates Column based on the selected Year Criteria as described on the attached Excel Sheet.
Any help will be highly appreciated
Hello,
I would like to make a formula like Index-Match or any other idea to return with all results from the Dates Column based on the selected Year Criteria as described on the attached Excel Sheet.
Any help will be highly appreciated
Hi
in C8 formatted as date to be copied to the right
=IFERROR(AGGREGATE(15,6,$D4:$L4/(YEAR($D4:$L4)=$B8),COLUMNS($A:A)),"")
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Dear canapone,
Many many thanks for your reply, and your equation works like magic.
Thank you very much
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks