+ Reply to Thread
Results 1 to 11 of 11

Whatsapp Contact filter

Hybrid View

  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    DUbai
    MS-Off Ver
    Excel 2007
    Posts
    63

    Whatsapp Contact filter

    Dear sir

    I have a contact life in excel file.... how can I filter number who are register with whatsapp.....is there any way I can filter who are using whats app

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,704

    Re: Whatsapp Contact filter

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    04-17-2014
    Location
    DUbai
    MS-Off Ver
    Excel 2007
    Posts
    63

    Re: Whatsapp Contact filter

    sample.jpg

    this is my sample file....I have thousands of contact...I want to know which number are using whats app.. or may be which number are register with whatsapp

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Whatsapp Contact filter

    I can't really see what you are after. Your picture shows a number, a name and another number and that's it.....what do you expect to get? What identifies Whatsapp entries?
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  5. #5
    Registered User
    Join Date
    04-17-2014
    Location
    DUbai
    MS-Off Ver
    Excel 2007
    Posts
    63

    Re: Whatsapp Contact filter

    if you use whataspp.... and just think that I have your number in my list then how can I filer out it.....
    http://www.youtube.com/watch?v=fntlQUj_aRg

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,704

    Re: Whatsapp Contact filter

    You will need to identify in some manner, those people in your list that are using WhatsApp otherwise, Excel will not be able to filter them for you.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Whatsapp Contact filter

    If you read Alan's post properly, he asked for a sample WORKBOOK, not picture. Upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,704

    Re: Whatsapp Contact filter

    That You tube made no sense at all. There was no sound and the picture was so blurry that I could not determine what was going on. It did not look at all like an Excel issue. Still don't understand what you want from us here at Excel Forum. Please try to explain in simple English.

  9. #9
    Registered User
    Join Date
    04-17-2014
    Location
    DUbai
    MS-Off Ver
    Excel 2007
    Posts
    63

    Re: Whatsapp Contact filter

    sorry sir...

    But I am not a programmer.. But I tell you what I want.... I am working in Bank.... and I got a huge mobile contact list of customers from my boss. i think its 250 thousand... and I need to know out of 250 thousand customer how many people are using whatsapp..... how can I know that... is there any way in VBA that can find out from whatsapp server who is register number

  10. #10
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,704

    Re: Whatsapp Contact filter

    Suggest you contact WhatsApp. Excel may be able to determine that but the WhatsApp programmers will have to provide you with an interface. Do you have access rights to the WhatsApp server with your PC? That would be the first step and that is a WhatsApp issue, not an Excel issue.

  11. #11
    Registered User
    Join Date
    10-14-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    1

    Thumbs up Re: Whatsapp Contact filter

    Hi, check this out for WhatsApp filtering of contacts
    http://www.clicks2sell.com/whatsapp-...-has-whatsapp/

    Hope this helps!

+ 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. How to contact the administrator
    By Omeir in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-12-2012, 02:23 AM
  2. Contact list the will automatically add a contact
    By mike.richards in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2008, 10:35 AM
  3. More help please with contact list....
    By ckluge in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-08-2006, 06:40 AM
  4. [SOLVED] contact details
    By NHWAHROONGANSW in forum Excel General
    Replies: 0
    Last Post: 05-09-2005, 08:06 AM
  5. [SOLVED] New contact problems
    By KRS1455 in forum Excel General
    Replies: 0
    Last Post: 03-14-2005, 01:07 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