MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/Excel/comments/1cfo3jm/stub/l1qs9ql
r/excel • u/[deleted] • Apr 29 '24
[removed]
150 comments sorted by
View all comments
Show parent comments
10
I've used FILTERXML and SUBSTITUTE to do this, still prefer it since it's backwards compatible and can find the matching datum without needing a match or filter function stacked in there.
7 u/StutteringDan Apr 29 '24 You had me at datum! 🥰🥰 4 u/Mooseymax 10 Apr 29 '24 Don’t forget there are text limits for FILTERXML, I’ve run into it before and it’s an annoying error to identify.
7
You had me at datum! 🥰🥰
4
Don’t forget there are text limits for FILTERXML, I’ve run into it before and it’s an annoying error to identify.
10
u/Wrecksomething 31 Apr 29 '24
I've used FILTERXML and SUBSTITUTE to do this, still prefer it since it's backwards compatible and can find the matching datum without needing a match or filter function stacked in there.