Hello Xelers,
I need a formula/function that fills column D to which group the data of column B ( group to be found in
column G) AND the data of coumn C (group to be found in column H)
The data are refreshed daily. That is why I need the formula/function itself
The first 2 lines D2 and D3 showing you of how I need the data to be presentd (no coloring)
Thank you very much for your kind help
Thomas
In D2 copied down:
=INDEX($G$2:$G$20,XMATCH(B2,--TEXTBEFORE($G$2:$G$21," "),-1))&" / "&INDEX($H$2:$H$54,XMATCH(C2,--TEXTBEFORE(SUBSTITUTE($H$2:$H$54,",",".")," "),-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.
Hello Ali,
would you mind adding that formula into my spreadsheet? Reason is that the englisch formula is not working in my german version. The function "xmatch" and "textbefore" are nor found in the german version of XLSX365.
Thank you very much
Thomas
Sorry Ali.... my mistake... I see the formula is already added.
All good...
Sorry again...
Thomas
Yes - that's why I provided a workbook.
Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks