Results 1 to 10 of 10

Filter, where certain line is missing

Threaded View

  1. #8
    Registered User
    Join Date
    10-15-2007
    Posts
    11

    Re: Filter, where certain line is missing

    Uhh, i went afk meanwhile and my laptop went to sleep! On AC power!!! Calculations ruined..

    Ok, did some some sorting and filtering. Now i have only 2 columns and 5500 rows of data.
    There is about 1800 phone numbers, which makes about 3 lines of services per phone number. About 300 of them dont have the "Service 2" - these are the ones i need to list.

    Applied the formula again, i dont know, now i calculates only about 1 number in 10 minutes. That cannot be right. My beard is growing faster.

    martindwilson, i tried Your formula, but what should i substitute "filter me" with? Forgiveme for my ignorance.

    Maybe there's a way to do this via multiple manual filterings and copy/paste?
    Maybe delete every mention of the numbers which have "Service 2" on some row? And then remove duplicates from others?

    Thank You
    Last edited by qingpool; 02-15-2011 at 01:03 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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