Consulting

Results 1 to 8 of 8

Thread: Return data not duplicated via formula?

  1. #1

    Return data not duplicated via formula?

    My friends.
    I want a formula to....
    I need to count (without duplication) the data in my database, based on 3 criteria (Date, PRP, AGR).

    how to return data not duplicated via formula?
    Attached Files Attached Files

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,903
    Location
    You can use =SumIfs or =SumProduct. For example in O4:
    =SUMPRODUCT(($J$4:$J$37=J4)*($L$4:$L$37=L4))

  3. #3
    i need make it considering range(A3:C454).
    the range used by you, I left the tab only to explain how to get where I want.


    how to get this result used (original My Data Base)?

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,147
    Location
    Try this array formula

    =COUNT(1/IF(($A$4:$A$454=$E4)*($C$4:$C$454=F$3),MATCH($B$4:$B$454,$B$4:$B$454,0)=ROW ($A$4:$A$454)-ROW($A$4)+1))
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    I make something wrong, because result it ZERO in all cells.

  6. #6
    Sorry, i find my error.

    it's work great!!

    Thank you very much!!!!!!!!!

  7. #7
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,903
    Location
    I usually have fits with array formulas.

    Obviously, my method can be adapted to your range. I tried to show you that it validated what you had.

    For the actual data, in H2, copy and fill to I2.
    =SUMPRODUCT(($A$4:$A$454=$E4)*($C$4:$C$454=F$3))

  8. #8
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,147
    Location
    I don't think so Kenneth, he seems to want the number of unque Valores within the two given conditions.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •