Hi All
I need to clean a database around 75000 rows, there are typo errors on an agent header.
is it possible to use the frequency formula with one criteria instead of countif as it is very slow on large spreadsheet.
Hi All
I need to clean a database around 75000 rows, there are typo errors on an agent header.
is it possible to use the frequency formula with one criteria instead of countif as it is very slow on large spreadsheet.
I don't know about using the FREQUENCY function for this, perhaps someone else here will know more, however, if you change the text in D2 from "_UNIMASA" to just "UNIMASA", and your formula in cell C2 to: =COUNTIF(A2:A24,"*"&D2) it would pull all 3 instances containing "UNIMASA" from your list.
Just thought I would throw that out there - obviously, with random typos, this kind of thing would be nearly impossible to sort through with such a large dataset.
- Moo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks