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

    Using Vlookup across 2 spreadsheets

    I am not sure if this is what you are looking for but try this: Workbook 1:Sheet 1: A1: Bill B1: Date of birth Workbook 2: Sheet 2: A1: Bill B1: Address So you are asking excel to look from bill from workbook or sheet1 to match bill in workbook2 or sheet2 and pull the address: here it is...
  2. Y

    Formula for Multiple criteria

    Hi Luke, Thanks for your quick reply. I am referring to multiple criteria, let me try to explain: In the division column, please filter on finance, and in finance, please return a count if length of service is less than 1 month, for the same division, please return count of length of service...
  3. Y

    Formula for Multiple criteria

    can you please suggest a formula? Example: For division x, ranging from A2:A100, please return count <=0.08,ranging from B2:B100 For the same division x, please return count >0.08 but <0.2 etc It is more like applying filters,but with formula, like filtering on divisions and...
Back
Top