Forum Discussion
Comparing Cells after Splitting
Hi dmouser ,
"So if I'm comparing this Apple; Orange; Kiwi to Kiwi; Apple; Orange they don't match even though the content align. I do have the items in another table with their own IDs. "
<---Could you share some sample data and results you want to achieve and explain more details about your requirement?
Regards,
Jimmy Tao
I don't have a public file host, but did draft up a dummy workbook based on fruit. Image of two tables is below. I also uploaded a copy of the second table before manipulation to see how the sequence affects the outcome. Youll notice on the original while all 3 fruits were deliverred, because the sequence is different the calculation thinks they don't match and are therefore late.
I located the following post on the boards which - I think - gets to the same questions solution. However, the instructions are a bit choppy and I'm having difficulty following them. Ironically, the example uses fruit too. :smileyhappy:
Creating a total score for values in a concatenated and comma separated list