Combining the first 3 columns in a 5-columns dataset. If there is the same value (Combined) in different rows than the value I have combined, I want them to count and give the relevant 3 column information.
I want it to warn messagebox: EXAMPLE 1003889 -50,000.00 4 count same...
Column1
Column2
Column3
EXAMPLE0
1003338
-2,386,230.68
EXAMPLE2
2007246
-75,659.00
EXAMPLE1
1003889
-50,000.00
EXAMPLE1
1003889
-50,000.00
EXAMPLE1
1003889
-50,000.00
EXAMPLE1
1003889
-50,000.00
Best answer by LoganPrice
It sounds like you only want to be warned about one row value at a time. If that is that case, here is what I would do:
Add a column at the end of your Excel dataset that combines the first three column values.
Extract your Excel dataset to a DataTable variable
Use the “search for a value” DataTable action to search the new column for your desired value. This will create a list of all matches.
Count the number of items in the list and now you have your number of duplicates.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
