Hi
I Have two set of data in different column suppose Data1 and Data 2. Is there any formula to get all data that is present in data 1 but missing from data 2. And i want to get them in new column.
Thanks for your time.
Best Answers
-
Try something like this:
=JOIN(COLLECT([Barcode 1]:[Barcode 1], [Barcode 1]:[Barcode 1], FIND(@cell, JOIN([Barcode 2]:[Barcode 2], ", ")) = 0), ", ")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
There are a few different parsing solutions tucked away here in the community that you will need to leverage.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Here is what I came up with.
=IFERROR(IF(VLOOKUP([Barcode 1]@row, [Barcode 2]:[Barcode 2], 1, false) = [Barcode 1]@row, ""), [Barcode 1]@row)
Basically, it looks at the value in barcode 1 and compares it to barcode 2's list and then leaves it blank if it finds it but repeats it in column 3 if it doesn't find it in column 1.
I set it up as a column formula so it automatically works on the each row.
Answers
-
Is there a list of several items? Can you share a screenshot? That would help us to understand what exactly you are comparing?
-
Hi Mike,
So here in Picture Barcode 1 and Barcode 2 has some different value. I want to know if there is any formula so that i can get all the unique barcode that is not present in Barcode 2 but present in barcode 1. I want that value in column 3.
Thanks for you time,
-
Try something like this:
=JOIN(COLLECT([Barcode 1]:[Barcode 1], [Barcode 1]:[Barcode 1], FIND(@cell, JOIN([Barcode 2]:[Barcode 2], ", ")) = 0), ", ")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul,
Thank you for helping, it works but all the value are in one cell. I want one value in one cell. Is that possible?
-
There are a few different parsing solutions tucked away here in the community that you will need to leverage.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Can you share some so that I can try to work on that. Thanks
-
Here is what I came up with.
=IFERROR(IF(VLOOKUP([Barcode 1]@row, [Barcode 2]:[Barcode 2], 1, false) = [Barcode 1]@row, ""), [Barcode 1]@row)
Basically, it looks at the value in barcode 1 and compares it to barcode 2's list and then leaves it blank if it finds it but repeats it in column 3 if it doesn't find it in column 1.
I set it up as a column formula so it automatically works on the each row.
-
@Mike Wilday That's a great idea. I wish I had thought of it. Haha.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Haha. @Paul Newcome thanks! Keep in your reference for the future 😝
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!