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

    Pivot table help

    Just to spot the trends. Latest visits received for each patients and how many more to go in each of them.. From there use formualae to get the future extrapolated dates..
  2. C

    Pivot table help

    The table structure may not be clear in the post above.. trying again Patient Visit Date 1 1 01 Jan 1 2 02 Jan 1 3 03 Jan 2 1 15 Jan 2 2 17 Jan
  3. C

    Pivot table help

    Hi All I need help in Pivot tables. I have data as follows Patient Visit Date 1 1 01 Jan 1 2 02 Jan 1 3 03 Jan 2 1 15 Jan 2 2 17 Jan I want to create a Pivot as follows Patients in the row label, Visit in the column label and raw data of...
  4. C

    find the max date

    I have a dataset that looks something like this 1 13/05/2012 1 14/05/2012 1 15/05/2012 2 11/03/2012 2 12/03/2012 2 13/03/2012 3 01/01/2012 3 02/01/2012 3 03/01/2012 In the column C, I want a formula that will return the highest(max date) in column B for every value in column A. So...
  5. C

    incorrect duplicate values

    Hi, I am working through a huge list of incorrect duplicate values. To explain it further the list has some medication names and the corresponding unique alphanumeric code. I have to flag all the instances where the medication name is duplicated but the alphanumeric code is not same. The data...
Back
Top