Forum Discussion

dmouser's avatar
dmouser
Frequent Visitor
8 years ago

Comparing Cells after Splitting

I had an issue with a data set that I previously posted about.  However, I've been given additional information/direction from the owners so now I'm dealing with a different challenges.   I have a ...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi dmouser,

 

"How, I can I return the same if x, then true,fale results to compare the collective value of a series against the column B grouping?"

 

<--- Could you clarify more details about your logic to achieve this?

 

Regards,

Jimmy Tao

dmouser's avatar
dmouser
Frequent Visitor
8 years ago

I may have solved this, but identified another challenge as a result.  So I could leave my formulas unaltered, I added a step to copy the column, then split.  Not sure if this is a best practice or not, but it allowed me to keep the original column and values to base my formula from.

 

However, my formula was comparing values of Column A to Column B to determine if they align.  However, I noticed the sequences are not consistent, even though the values are.  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. 

 

Can I sum of the values in the cell if they are found? 

 

Fruite | ID

Apple = 1

Pear = 2

Orange = 3

Kiwi = 5

Peach = 4

 

Identified Fruits: Apple; Orange; Kiwi - sum of IDs = 9

Deliverd Fruits: Kiwi; Apple; Orange - sum of IDs = 9

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    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

    • dmouser's avatar
      dmouser
      Frequent Visitor
      8 years ago

      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.