Solved

how many different data are in a excel column

  • 10 April 2023
  • 1 reply
  • 46 views

Badge

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
icon

Best answer by LoganPrice 13 April 2023, 22:52

View original

1 reply

Userlevel 3
Badge +9

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:

  1. Add a column at the end of your Excel dataset that combines the first three column values.
  2. Extract your Excel dataset to a DataTable variable
  3. 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.
  4. Count the number of items in the list and now you have your number of duplicates.

 

Reply