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

    Look up available value to replace missing values

    Hi, I have the data below. I want to use available data to replace missing values. For example, the case 2770 appear 3 times, and all of them should have a value of "Low", but it shows #N/A N/A in the first two cases. How can I use formula to achieve this goal? 2770 #N/A N/A 2770 #N/A N/A...
  2. B

    How to link two files correctly?

    Hi Sir, I have a file 'Master' which needs to fetch data from three columns of file 'Source'. Currently it is simply specified as linking to A1, B1 ... What worries me is that if someone inserted new columns in the source file, the data fetched are wrong! Can I ask how to use some formula...
  3. B

    How to read data from the workbook selectively?

    Hi, It's been interesting to me on how to read data selectively from the other workbook. Rather than pull all data, I just want to read values of 10 cells: the 1st cell has a unique name "ID code", and from this cell downward to the 10th cell. Though this seems to be easy, I cannot get this...
Back
Top