Can anyone help me my issue?
I have probs that
i want get the a value base on id and earliest date whitin 2 multiple sheet.
please access below google sheet url
SUMMARY SHEET RESULT SHOULD BE LIKE COL A
ID TAG 1ST AMOUNT 1ST DATE A 60,000 19/08/2024 23:49:57 B C
DATA1
DATE IDTAG AMOUNT 19-08-2024 23:58:12 A 50,000 19-08-2024 23:54:15 B 600,000 19-08-2024 23:50:03 C 48,000
DATA2
DATE IDTAG AMOUNT 19/08/2024 23:49:57 A 60,000 19/08/2024 23:43:33 B 12,558 19/08/2024 23:41:58 C 70,000
Try stacking the data then use SORTN to pull the first row
If you need further help then please try creating a sample file.
Heres a link to a sample file into which you can build your sample:
https://docs.google.com/spreadsheets...it?gid=0#gid=0
Let us know once you have created the sample.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
Hi janmorris,
Thank you for your reply.
i have been created the sample. you may check is
Where is the sample? Please provide a read/write enabled link to it. There is nothing added to the sheet at janmorris' link.
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.
https://docs.google.com/spreadsheets...it?gid=0#gid=0
here is the link mam
Thanks - I see the extra tabs now.
The earliest date for A is the one you have losted, but the amount for that date is 60,000, not 50,000.
What gives?
I think this gives what should be the right answer. In J2 copied down:
=let(v,sort(VSTACK(DATA1!$A$2:$C$5,DATA2!$A$2:$C$5)),choosecols(INDEX(filter(v,index(v,,2)=A2),1),3,1))
In addition to the solution offered by AliGW, heres another method:
=BYROW(A2:A,LAMBDA(idtags,QUERY(SORT(VSTACK(DATA1!A:C,DATA2!A:C),1,true),"select Col3, Col1 where Col2 matches '"&idtags&"' limit 1",0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks