• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    How to extract postal code from the address

    I would like to extract the postal code from the hundreds of addresses we have on file. The postal code appears in the address in different postition (see sample below). The postal code format starts with alphabet number alphabet number alphabet number (ie H9Y 2Z3) but sometimes written with...
  2. T

    display result on a list based on a given table/data

    looking/searching for a right formula that will display a cell on a list based on a given table. A match result will be based on the following criteria: 1) date 2) timing 3) name if it match then it display the time start and time end on a separate list/table. I have attached the sample file...
  3. T

    find and compare data in columns

    I need to find two cells that contains text from three columns... Based on the attached sample, I would like to know the formula on how to find and compare data please. Thank you for your help.
  4. T

    If condition

    Appreciate if somebody could help me find a proper "If" or whatever appropriate function/formula with several conditions following the requirement as commented (desc column) in the attached file. Please refer to the attached the file for better understanding please. Thank you for your help.
  5. T

    How to sort dates that includes text in pivot table and chart

    Greetings! I have thousands of items that includes the 'text' and 'date' in one field. I am using pivot table to generate the chart, however it is my desire to have the sequence sorted by the Date as appears in the ItemDate column. Attached is the sample file with few data. It is my intention...
  6. T

    Formula to get result based on two criteria from different worksheet

    Good Day! I am receiving two files from different department and usually copy/paste them on separate worksheets within my master file. -----WorkSheet1------ FRUIT STARTsupplyDate STARTprodDate STARTfinalDate BANANA 1/1/2017 2/2/2017 3/3/2017 ORANGE 4/4//2017 5/5/2017 6/6/2017 APPLE 7/7/2017...
  7. T

    Put similar data/content from three cells to one cell

    I have three columns (b1,c1,d1) with similar data/text and would like to know a formula that would result as example below. I must combine/put (b1,c1,d1) content into one cell (a1). A1 B1 C1 D1 Kuwait Kuwait n/a Kuwait France n/a France n/a Saudi Arabia n/a n/a Saudi Arabia Thank you in...
  8. T

    Display the very next top value of a row

    Greetings! I have a thousands of item that requires me to identify which item is part or belong to what item/level. I have attached an excel sample where a) Column B (level), C (Item Number) and D (DESC) are the given data. b) Column A is the output/result that I would like to have which...
  9. T

    sequential order and display functions required.

    Please help me to find a solution to my requirements: Basically, I am needing of two functions 1) Function 1 is to make a sequential list based on the ID number. It starts as "Attachment0" onwards (from Attachment0 to Attachment30). If number column has a similar value then 'attach' columns...
  10. T

    Count filled cells based on date criteria from another column

    Given the following information below where "date", "name" and "code" is column A, B and C respectively, I would like to know the formula that will count the cells of Column B with text based on the date I entered in (A9) which matches column A dates. The result will then shows in cell (A10)...
  11. T

    Copy/extract text from a cell based on defined keywords

    I am in need of formula that would copy/extract from one column (A2-A4) and show the result in different cell/column (B2-B4) based on the defined keywords (H1). SAMPLE DATA: A2: The boy and girl is walking. A3: the girl is good. the boy is good and tall. the mother is sleeping. A4: Leo...
  12. T

    Splitting text/authors name

    I have more than 10 thousands of scientific references placed under one cell and I would like to separate the authors name on another columns. I have searched the site and tried putting different formula to get the result I wanted but cant get it. Appreciate any assistance please. Example...
Back
Top