• 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.

Recent content by tango

  1. T

    How to extract postal code from the address

    Thanks for your help Bosco and it works on some address with similar nomenclature/format of the address above however, results are not appropriate given different address/format below. If I have few list of addresses, I can manually fix it however, I have hundreds of addresses and hopefully you...
  2. T

    How to extract postal code from the address

    Thanks AlanSidman. Tried it and helps a little. Hope there is an alternative please.
  3. 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...
  4. T

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

    Thanks Bosco.... This is great but I forgot to add the "Sunday" column... sorry for this and appreciate if you could update it please. I tried...
  5. T

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

    Hi Bosco, It works however I am not able to put it together due to worksheets I have in my actual file. I attached here a new document where you may please incorporate the formula once again please. Thanks for your help.
  6. T

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

    Thanks Bosco. PM sent.
  7. 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...
  8. T

    Display the very next top value of a row

    You are the best. Your code rocks and execute 131k rows in a blink of an eye. Big thanks. Furthermore, willing to wait for a month or so ;-) if somehow the line of codes could be explained for learners information. Thank you.
  9. 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.
  10. T

    Display the very next top value of a row

    Its me again.... I have asked a friend to modified Peter's code but one way or the other, the process still takes so much time (131711 rows) and need to wait for so looong to get the results everytime I run the code, and most of the time, my computer hangs. Is there an altrnative way/code to...
  11. T

    Display the very next top value of a row

    Thanks Peter.
  12. T

    Display the very next top value of a row

    Thanks Peter. Thanks Bosco. I recorded a Macro and run it on the original attachment above and it works Bosco.... Would it be possible to have the code below converted in VBA with an objective that every output/result in each cell will simply contains 'text' and not with "code/function...
  13. T

    Display the very next top value of a row

    Just to bump this thread to whoever can provide an alternative formula for =IF(B2=1,"",LOOKUP(2,1/ISERROR(1/($B$1:B1-(B2-1))),$C$1:C1)) My excel/computer hangs due to a file of mine that contains tens of thousand of rows being processed. Please help.
  14. T

    If condition

    Hi, additional request with similar issue as I modified the requirement by adding a new "No Order" comment. I need formula/function please. Attached is the file for your reference. Thanks for your help.
  15. T

    If condition

    Thanks a lot Bosco. It works....
Back
Top