Forum Discussion

jberlin's avatar
jberlin
Copper Contributor
Jul 28, 2020

Formula to Reference Two Tabs and Producing Difference

Hello - Do you know of a formula that would allow referencing two tabs and produce what is different between the two tabs? Almost a reverse on removing duplicates? Thank you in advance. 

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    jberlin 

    It very depends on how data is organized, do tabs have same structure or they are fully different, etc. As NikolinoDE suggested it's better to illustrate with sample file.

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    A file would help to better understand your problem and suggest the best possible solution for you.
    What exactly is wanted ... I can not see from the translation.

    Nikolino
    I know I don't know anything (Socrates)