I apologize in advance for being combative, but your solution to the previously "complicated" solution is to make it even more complicated?I have given up on that way as it is too complicated!
Before going down this new rabbit hole you are digging, can I ask what about my suggested function did not work? As simple as that function should have been to enter and copy down, I am having trouble understanding why it was "too complicated."
Originally Posted by shg
MyShorty,
I am really not very good in Excel and to be honest I struggle my way through. I have spent hours trying to work out a solution and the only way I can kind of relate a "solution" is to do what i have done before and build a grid / use Index Match. Problem is when I tried to do that I realised (probably wrongly) that I would need to do two different matches, 1 for the month and then one for the year, again it's very complicated for me as I really am not very strong with the program.
I downloaded your spreadsheet but did not really understand it. Maybe I am just out of my depth with this one. I will try and work something out or re-do my sheet.
Thank you very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks