1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Im going to die if i cant do this in excel!!

Discussion in 'BlackHat Lounge' started by Scotland, Aug 16, 2013.

  1. Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    Hey Folks...

    I desperately need help from someone who knows about excel.

    I have a list of 5000 address, all of which are contained within 1 column on the spreadsheet.

    The addresses in row are in various formats such as....

    1, fake street, fake town, fake county,g12 6tg
    1, fake street, fake county,
    and so on....

    There are numerous towns and cities within the addresses, and basically i need a way to find out, how many towns and cities are there in the list, and how many addresses there are within those towns and cities.

    Ive tried formulas, sorting, filtering, but im getting nowhere fast and i need someone to please help me...please....help me

    Help Me

    HELP!!
     
  2. twistedtrick

    twistedtrick Power Member

    Joined:
    Aug 21, 2009
    Messages:
    654
    Likes Received:
    376
    Location:
    United States
    If you don't mind sharing the data, I will take a look at how it is laid out and see if I can offer any help (no promises though!)
     
  3. jazzc

    jazzc Moderator Staff Member Moderator Jr. VIP

    Joined:
    Jan 27, 2009
    Messages:
    2,468
    Likes Received:
    10,143
    4iWVydH.jpg
     
    • Thanks Thanks x 6
  4. mickyfu

    mickyfu Jr. VIP Jr. VIP Premium Member

    Joined:
    Dec 14, 2011
    Messages:
    5,256
    Likes Received:
    15,398
    Location:
    Jennifers Office.
    I have a suggestion for you, count them. No need to thank me, just glad I could help.
     
  5. VinceC

    VinceC Elite Member

    Joined:
    Jun 8, 2008
    Messages:
    1,616
    Likes Received:
    728
    Last edited: Aug 17, 2013