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

    Lookup multiple values for items in a column

    Hi There, I am trying to perform a vlookup type of action on the items in a column, the only thing is that I am trying to lookup multiple values for each of the items from an array. Some items could return 3 values, some can 5, some can 10, etc. I counted the number of values each item...
  2. S

    Select optimum value from an array of data

    Hi there, My data is in the following format: Job# Location 1002612 L610 1002619 L610 1002622 L610 1003360 L560 1003360 L871 1003470 L2925 1003470 L244 1003470 L120 1003498 L2925 1003498 L244 1003498 L120 1003523 L2925 1003523 L244 1003523 L120 1003527 L140 1003537 L3545...
  3. S

    Add n number of empty rows corresponding to cell value

    Hi there, Below is an example of the file I am working on. I want to add empty rows corresponding to the value in Col3, so 2 empty rows below ABC and 3 empty rows below ABD and so on. Col1 Col2 Col3 ABB ABB ABC 2 ABB ABD 3 Can anyone help with that?
Back
Top