• 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

    Data validation across sheets

    Hi Everybody, I tried to make data validation (dv) to prevent duplicated values in two sheets. Here is what I need to do: When I put a value in "Sheet1 Column Trx_No" the dv will prevent duplication if its already in Sheet1 or Sheet2 Column Trx_No and also if I tried to put a value in "Sheet2...
  2. T

    Lookup by month

    I have a list of transactions named TrxTable as follows TrxTable Date B/S Desc Qty Price Total 05 Jan '12 Buy A 100 100 10000 12 Jan '12 Buy A 50 100 5000 02 Feb '12 Buy B 50 105 5250 16 Feb '12 Buy A...
  3. T

    Data validation to restrict cell value from a certain value.

    Here is what I'm trying to do. I have a list of banned items, and if I type this item name into a cell it will pops a warning that the item is invalid. So still I can type any value in that cell but those in the banned list. Is it possible doing that by using data validation? And if there is...
Back
Top