Results 1 to 2 of 2

search and count based on multiple criteria

Threaded View

  1. #1
    Registered User
    Join Date
    05-22-2005
    Posts
    38

    search and count based on multiple criteria

    Hey,

    I am looking at a list of about 4000 telephone numbers and need to search for multiple numbers and count the number of ocasions they are listed.

    I tried =countif(I2:I4550,"number1, number2, number3......)

    but this clearly isnt right, can anyone help me on this??

    Oh and each numner is prefixed with ' . eg '0778892 so that the 0 shows.
    Thanks for any help

    James
    Last edited by themax16; 04-23-2008 at 04:26 AM.

Thread Information

Users Browsing this Thread

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

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