LinkBack URL
About LinkBacks
Heelo Friends, I have large database with mapped Debet annd Credit, I have attached file and I need to result like in "Result" sheet from "Starting" sheet, without manual intervertion, could you help me accomplishing this?
Heelo Friends, I have large database with mapped Debet annd Credit, I have attached file and I need to result like in "Result" sheet from "Starting" sheet, without manual intervertion, could you help me accomplishing this?
The source data is moissing from the workbook. It needs to be included for anyone to be able to work on this for you.
Please explain in WORDS what the formulae in place are expected to do and in what way they are not working for you. What EXACTLY are you trying to improve?
You need to give more detail.
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.
If you have O356, you can use this.
Please Login or Register to view this content.
I had corrected the workbook so that, everyone could see it now.
Thnaks in advanced.
Thanks, but I have Microsoft Office LTSC Proffesional Plus 2021, no vstack functions are there..
Please update your forum profile, which says Excel 2016. Do this NOW.
I have updated.
Try this, but I have not 2021 version to test.
D5
E6Please Login or Register to view this content.
E6Please Login or Register to view this content.
all copied down.Please Login or Register to view this content.
Thnaks, but in my "Result" sheet for example in Dr site - inventory is repeated six times, but in your formula only 1 time why?
Yes, I know why.. My fault i would review more detally your formula..
Result sheet doesn't fix range, so the answer is wrong in Result sheet.
C4
=UNIQUE(FILTER('Transactions Mapped'!$J$5:$J$478,('Transactions Mapped'!F5:F478=Starting!B6)))
C7
=UNIQUE(FILTER('Transactions Mapped'!$J$5:$J$478,('Transactions Mapped'!F8:F481=Starting!B9)))
=UNIQUE(FILTER('Transactions Mapped'!$J$5:$J$478,('Transactions Mapped'!F14:F487=Starting!B15)))
Now, I have question, can we extract Map_DR and Map_CR from Transactions Mapped with unique formula in different columns? Not with concatinate in one cell?
I don't sure what you want, upload a sample file to describe, please.
Please see attached file.
Try:
=LET(m,HSTACK(TR!G3:G55,TR!K3:K55),UNIQUE(m))
Like this?
F4
=UNIQUE(FILTER(TR!G3:TR!G1000,TR!G3:TR!G1000<>""))
G4
=UNIQUE(FILTER(TR!K3:TR!K1000,TR!K3:TR!K1000<>""))
No, I don't think so. See post #15.
Hstack i dont haveOriginally Posted by AliGW
Oh, sorry - I forgot!
Try this:
=LET(m,CHOOSE({1,2},TR!G3:G55,TR!K3:K55),UNIQUE(m))
Or this:
=LET(m,CHOOSE({1,2},FILTER(TR!G3:G1000,TR!G3:G1000<>""),FILTER(TR!K3:K1000,TR!K3:K1000<>"")),UNIQUE(m))
Yes, good solution. Now I need to sumifs it with Dr_Map as criteria. And then I need to sort result descending order.. how is it possible?
What does this formula other then the previous one?
Show us what you want - mock it up manually. I am not going to guess.
Try both of them and see. Don't be lazy!What does this formula other then the previous one?
I have attached file, and there the sumifs result needs to be sorted descending order.
One way:
Please Login or Register to view this content.
Last edited by AliGW; 08-19-2023 at 06:17 AM.
Delete ALL expected results and use:
Formula:
Please Login or Register to view this content.
Your SUMIFS in column H is giving an incorrect result.
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
No HSTACK or VSTACK, Glenn.
LoL. And no BYROW either.
LOL!
I wish everybody would get 365 ...
Would be availabe on my version soon this functions? Vstack...
No - I don't think so. If there is to be a 2023 version, it will have them - only 365 at the moment, though.
Thanks, for replien. I thinked the my last question would be easly solveble. The threath is solved.
I've adapted Glenn's:
Please Login or Register to view this content.
As did I... only a little more slowly:
Formula:Please Login or Register to view this content.
Wow, good Solutions, Thanks both..
Glad to have helped.
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) 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 all those who offered help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks