Forum Discussion
Matching pair of values in two columns
When you click "reply" you have a link to the left above the Post button where you can open full text editor.
Well there you can attach the file just above the Post Button.
Make sure there is no names or secret data in it and I will take a look.
George_Jokha Seems ok with version 2201 (Excel 365, jan 2022).
In cell i3, you may want to add sort but it will give you different group numbers. If group name is important you can use XLOOKUP instead of XMATCH (in attached file)
output;SORT(UNIQUE(dimensions));
- But.. ooh, "x" formulas seems to work only for higher version of the windows. I have windows 10 😞
- You're welcome 🙂
XMATCH and XLOOKUP are not very new but quite. Both of the are available without X and be functional in this case. But... LET, SEQUENCE and UNIQUE takes more effort to implement in older versions. 365 holds the latest possibilities, inluding the fantastic lambda (different chapter since it so far is not in use here).bosinander Hi (Good morning from me 🙂 )
I have tried many times to apply formulas you've provided, but unfortunately, my system bocks the excel with "No responding" result.
Is it possible to upload my file (about 350 rows in total, two columns) and you could help me to group the pairs? If it won't bother you much...
P.S. BTW - I can not find the button here to upload the any excel file, as you did.
bosinander Thank you very much. It seems to be good dessision. Difficult, but good! :))