Hi, i have to tag my old code to new code base on Date Criteria and then do a Sumif base on Date and the Old Code/New Code.
However, i seems to be stuck. Cant think of a way to do this. In my sample, I would like to return Yellow Colour portion.
Can anyone think of any formula to do?
Do we have to get the amounts (50,000 etc) from the OLD mapping??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Clean all expected results and try this in M1.
Please Login or Register to view this content.
Yes. Need. Thats y its actually Sumif with period criteria.Originally Posted by Glenn Kennedy
Please comment on the solution offered in post #3.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
@windknife
Hi, somehow if the tag has been change more than once, the formula show #na. I'm sorry, but my real life case, the tag would be change quite a number of times.
See my attached which i highlighted in Yellow form A:C
Last edited by AliGW; 02-07-2024 at 06:20 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
You should have made this added complication clear at the outset - you have effectively shifted the goalposts. Are there any other twists here??? What else HAVEN'T you told us?
Sorry for that. I re-attached the file, however, i added in the real case situation
Last edited by AliGW; 02-07-2024 at 06:36 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
This is the same as post #6 - you have not shown expected results on the new row! And are there any more curve balls coming? Has this covered ALL eventualities?
How about this,
Please Login or Register to view this content.
Hey Thanks! It works! Sorry for not explaining it clearly in my 1st post.
Last edited by AliGW; 02-07-2024 at 07:08 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Administrative Note re. Forum Guideline #2:
Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter and rarely necessary.
If you are responding out of sequence, it is usually enough just to mention the helper's user name (e.g @AliGW).
If you do need to quote, limit the quoted section just to the section to which you wish to draw your helper's attention or a direct question to which you wish to respond.
For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks