Forum Discussion
anupambit1797
Jun 18, 2024Steel Contributor
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...
- Jun 18, 2024
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
Jun 23, 2024Steel Contributor
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
HansVogelaar
Jun 23, 2024MVP
I don't see an easy way to do that.