Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
Jun 18, 2024
Solved

Common items

Dear Experts,                    I have an issue like this So in Column A,B,C we have TEST sets TEST2/3/4 and have some items( rnti) in Column F/G we have the items( from another object say UE here...
BI & Data Analysis
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jun 18, 2024

    anupambit1797 

    Sorry, I forgot to mention that the values in columns A, B and C are text while the values in column G are numbers. I converted the values in columns A, B and C to numbers. The formula then works.

    See the attached version.

anupambit1797's avatar
anupambit1797
Steel Contributor
Jun 18, 2024

Thanks HansVogelaar , seems something is wrong in my case:-

Can you please share what could be the issue? also for the "O4" can you please share like how to

populate the rnti's for the UE in TEST1("O") and so on from Column "F and G"?

Thanks & Regards

Anupam Shrivastava

HansVogelaar's avatar
HansVogelaar
MVP
Jun 18, 2024

anupambit1797 

Sorry, I forgot to mention that the values in columns A, B and C are text while the values in column G are numbers. I converted the values in columns A, B and C to numbers. The formula then works.

See the attached version.

  • anupambit1797's avatar
    anupambit1797
    Steel Contributor
    Jun 23, 2024

    Thanks a lot HansVogelaar , also is it possible to populate these in a Venn diagram as below?

    For TEST2(say) where we have common items?

    Can Venn diagrams be used for number data?

     

    Thanks again ,

    Br,

    Anupam

     

     

Resources