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

    Counting specific values in a CSV Column

    I have a column containing several values, for example: B1, H, G B2 G4 D, D1 N,B2, L, L3, G1 O1 C G3 O2, Q2 L6 I1, I2, L4, Q2 How do i find the count for each unique value? I have used: =SUM(--NOT(ISERROR(FIND(A3,'SCR Dispo'!N:N)))) as an array (ctrl+Shift+Enter), but it counts...
  2. D

    Layered lists

    I am trying to creat a data entry form where users make a selection from list A, then based on this entry, list B provides a list of options, then List C is provided on the previous entries. I have tried with data validation, however, I want a data input form to record the entries and other...
  3. D

    forms

    I have an excel 2007 work book that requires input from the user in the form of a table. I have created the data input form, and it maps to a tab in the work book, however, resently it has started stopping when updating the data. The associated code is provided below: Private Sub...
Back
Top