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
Bookmarks