• 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

    SumIfs with a NOT

    Plz Check : https://docs.google.com/spreadsheet/ccc?key=0AlMNziTCmrQIdEhyQUJIODZoTTRMRVBWbk1LWHpMTWc Hope this will help, if i get your problem correctly
  2. S

    Data Validation

    if you use =isnumber(Cell number), then it VALID only for NUMBER [by default, it take the Boolean value as TRUE], so you validate the cell for only NUMBER by yourself. So why it VALID anything other than NUMBER?
  3. S

    Transposing multiple rows into one column

    Count the number of row of data area (naming as "mydata"): =ROWS(mydata) [assume @ A6] Count the number of column of data area (naming as "mydata"): =COLUMNS(mydata)ll [assume @ B6] To get the row and column number matrix: for ROW: Any cell (Say A8): 1 Next cell (A9)...
Back
Top