1. E


    Hi, Is it possible to sync an excel file on the computer with an excel file on android phone? Thanks
  2. J

    Finding Duplicates

    Not an advanced Excel user at all, but trying to figure some things out. Was hoping to get some advice on my situation and hopefully come up with a solution. I have a Column that holds phone numbers in the their traditional format, (123) 456-7890 and receive a CSV report of these phone...
  3. C

    Compare 2 spreadsheets

    Hopefully this isn’t too confusing… I have two spreadsheets containing several thousand rows each and need to compare the two. The first (AV) is from our internal database and the second is from an online source (XYZ). AV contains: Name, Email, Phone, Status XYZ contains: Name, Email...
  4. R

    How to sort cells in a column that contain the pattern XXX-XXX-XXXX

    I have a long list of contact information that I'd like to sort by ones that have a phone number in the name column. An example: Bob Johnson Joe WALMART John Smith 555-555-5555 There are numerous entries but I'm trying to sort a column so I can group the entries that have a phone number like...
  5. muhammad susanto

    Custom Number in Phone Number Format

    hi all... how to make in custom number format phone number like this (insert mark "-) e.g 0812-5265-9999 0817-6325-8743 0878-6986-410 thanks in advance.. m.susanto
  6. M

    IFERROR not Working

    Hello Folks, The Following Code is not working =IFERROR(IF(E6<>"",(INDEX(Prowatch!AI:AI,MATCH(E6,Prowatch!H:H,0))),""),"No Number Listed") So in E6 theres and email address On Prowatch Tab AI:AI is a range of email addresses IF E6 email matches anywhere in Range Match E6 Prowatch H:H which...
  7. T

    How to remove extra characters from a data set when transferring data via text to column

    Here's the situation. we are moving to a new CRM (or to a single REAL CRM if you want to be honest) and we need each phone number in a new column with out the jargon (random notes) behind it. The phone number are in one column now, separated by an alt return. The phone number look like the...
  8. I

    Color last word in a range of cells

    Hello I want to know which is the simple vba code to color last word from a range of cells. <tbody style="margin: 0px; padding: 0px; border: 0px; font-family: inherit; vertical-align: baseline;"> 1 John cell phone //991612 2 Maria cell phone //842246 3 Bill cell phone //892246 </tbody> i...
  9. R

    Copy outlook e-mail to Excel

    Good morning guys I really need your help.. I tried to find a VBA for me but i didn't, and those i found i didn't understand at all! hahaha I would like a VBA to copy 4 specific things from na e-mail, there are: "CNPJ", "E-mail", "Phone" and "Name" (CNPJ and E-mail are the most important, and...
  10. J

    Help with IF / And / OR

    I am not sure that I'm using the most efficient approach to what I'm trying to achieve. Input and advice is most welcome. I'm sure this is a simple formula, but I'm not having and success with it. <tbody> IF(AND( A1 > 9, and < 20, and B1 = "PHONE"), (DO THIS) </tbody> <tbody>...
  11. G

    Insert formula into cell works until I introduce the formula I actually want (it has " and *)

    I'm trying to automate taking a phone number and blanking out the first 7 digits, so 07779287640 becomes *******7640. As an additional complication the phone number needs to be stored with " at the front and back of it and sometimes there is no phone number so I'll have to return "". I have the...
  12. C

    Pull Specific Data from Outlook body 2016 and Export to an Excel File

    Hi, I have tried several scripts (and modified them) but I seem to be missing something. I would like to export, from a specified folder in Outlook, specific body items. This is from the body: SM Form 2018-05-11 11:19 AM was submitted by Guest on 5/11/2018 11:19:03 AM (GMT-05:00) US/Eastern...
  13. C

    Export Specific Fields from Outlook 2016 to Excel 2016

    Hi, I have tried several scripts (and modified them) but I seem to be missing something. I would like to export, from a specified folder in Outlook, specific body items. This is from the body: SM Form 2018-05-11 11:19 AM was submitted by Guest on 5/11/2018 11:19:03 AM (GMT-05:00) US/Eastern...
  14. W

    Pivot Chart displaying 0s inconsistantly

    Hello, I've run a survey using Email, Phone and Facebook. I'm combining the results into a series of pivot charts, 1 pivot chart for each question, each question has multiple answers Some of the questions have 0 responses for some of the options(no one on the phone chose option b in question...
  15. C

    If Vlookup for data base matching

    Hi there guys, Been a while since I've been using excel and the brain is a bit rusty.... I'm Just trying to get a formula right so that if someone enters a name, the matching phone number comes up next to it... breaks down like this.. I have a column A with names and a column B of phone...
  16. S

    UDF to extract phone numbers from cell content

    Hi Friends. I have list of customer information in excel cell ColumnA like list of 1000 customers. I want to extract all phone numbers present in each cell data. But phone numbers formats are different in each cell like 201.337.3900 or 213373900 or 1213373900 or 1(201 337-3900 or (201)...
  17. L

    Phone Number Formatting

    Hi everyone! I'm currently creating a VBA that formats phone number. All numbers must follow a standard format. The scenario goes like this: In the user's selection, or highlighted part/selected part, all phone number formats will be "three numbers" "-" "three numbers" "-" "four numbers"...
  18. S

    Visualising Telephone login sessions per 15 minute

    Hello, First post/long time lurker! I want to visualise the amount of time a telephone Agent has been logged in, per 15 minute interval. The below example shows the time an Agent has been on the phone, went to a break and then returned on the phone. I've got about 95% of the way there with...
  19. E

    Duplicates VBA

    Hello! Duplicates. In Column F I have different numbers. The numbers are sorted ASC. I would like to have VBA script: If a number occure in column F more than once, I want to put "DOUBLE" in column "V" in according row but only for second value and so on (first must not be marked. Colors...
  20. S

    help. need a formula

    i have a spreadsheet with many rows that i need sorted. it looks something like what's below... (there are ~2500 companies in total) A <tbody> Company A Name Address City, State, Zip Phone Fax Email Fluff Fluff Fluff...

Some videos you may like

This Week's Hot Topics