+ Reply to Thread
Results 1 to 2 of 2

using the frequency formula instead of countif on large spreadsheet with one criteria

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    EXCEL 2016
    Posts
    1,045

    using the frequency formula instead of countif on large spreadsheet with one criteria

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,842

    Re: using the frequency formula instead of countif on large spreadsheet with one criteria

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. adding a large, LARGE amount of text to a spreadsheet
    By Wolfpackfan in forum Excel General
    Replies: 4
    Last Post: 05-30-2016, 01:30 PM
  2. Formula help for a large spreadsheet
    By moselbee in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-17-2015, 12:29 PM
  3. [SOLVED] Counting frequency of Large Spreadsheets of text
    By wholemilk in forum Excel General
    Replies: 4
    Last Post: 07-22-2012, 11:29 AM
  4. Replies: 14
    Last Post: 05-23-2012, 08:09 PM
  5. Frequency in large data tables
    By Kasperstender in forum Excel General
    Replies: 10
    Last Post: 11-11-2009, 10:35 AM
  6. Replies: 2
    Last Post: 07-22-2009, 02:18 PM
  7. frequency formula with criteria
    By seanc in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-13-2005, 06:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1