LinkBack URL
About LinkBacks
Hi,
I am looking for a small and sweet formula that does the work.Existing formula is in A9 with correct result but the current formula seems to be very vast.Is there any alternative to it.
Hi,
I am looking for a small and sweet formula that does the work.Existing formula is in A9 with correct result but the current formula seems to be very vast.Is there any alternative to it.
One way,
Please Login or Register to view this content.
Hi, thanx for the reply.Can u explain me what does 'z',x,y represent ?including LAMBDA,REDUCE function here ?
You can learn it from the documentation of microsoft.
https://support.microsoft.com/en-us/...8-0642b568b7cb
https://support.microsoft.com/en-gb/...8-b7f7a2192bfb
https://support.microsoft.com/en-au/...a-ccbf254b8b67
Ok.Now I am using another function representing above formula as 'f' and using below formula now which is
LET(f,F10:F12,SORTYBY(f,XMATCH(INDEX(f,,1),TOCOL(Sheet2!D2:D35,1))))
So how to merge into one single formula.
Note:F10:F12 is the resulting figure from above attachment.Secondly Sheet2 is not reflected as it is simply using Sortby and it's refrences.
Last edited by Ekac; 06-13-2024 at 12:38 AM. Reason: Adding additional information
Attach an updated workbook, please.
There is no sheet 2 in the sample attached to post #1.
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.
Ok I will attach it.
OK - not there yet.
Ok.Kindly find in attachment.
Two formula 1st is at A9 from above forum contributor & 2nd is at A14.Kindly produce a single formula to get result which is below A14.
Last edited by Ekac; 06-13-2024 at 01:24 AM.
Like this:
Please Login or Register to view this content.
No,its not like that.You haven't touched Sheet2.
Pls see first in A15:A17-1st is Orange then Apple then Grapes as per the pattern in Sheet2!D2:D7 whichever do exists in Sheet1 and Grand Total at last if possible.
I am not your servant - please explain your requirements politely.
Try this:
Please REMOVE Office 2021 for your profile if you are asking for 365 solutions.Please Login or Register to view this content.
If you want solutions to work with 2021 and above, remove 365.
I didn't mean to hurt you or any one If it does then I am extremely sorry for that.You all of you are real mentor to me and there are no any other words that I can express it for immense contribution here.
Just use "please" in your requests.
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. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.
Also, if you have not already done so, remember that you can reward 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 each of those who offered help.
Please sign off the thread as requested in post #14 - I presume you are now satisfied with the solution?
Thank you so much. Yes it has definitely worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks