Results 1 to 9 of 9

Thread: results at the top of each day, not at each cell

  1. #1

    results at the top of each day, not at each cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    The below formula gives me the results for AT column at the top of each duplicated code in column AJ. How could I make it to give me the results at the bottom of the duplicated codes instead of at the top?



    =IF(COUNTIF($AJ2191:$AJ$10000,$AJ2191)=1,COUNTIFS($AJ2191:$AJ$10000,$AJ2191,$AT2191:$AT$10000,">"&0),"")

    Many thanks

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,418
    Articles
    0
    Excel Version
    365
    completely untested but try replacing
    =1
    with:
    =COUNTIF($AJ$2:$AJ$10000,$AJ2191)
    the red $2 assumes your data starts at row 2; adjust if it doesn't. The $ symbol is important.

  3. #3
    It puts it at the bottom of the duplications for me toony, not the top!

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,418
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by Bob Phillips View Post
    It puts it at the bottom of the duplications for me toony, not the top!
    It does indeed!

    Depending on what you're counting it might be this:
    =IF(COUNTIF($AJ2191:$AJ$10000,$AJ2191)=1,COUNTIFS($AJ$2:$AJ$10000,$AJ2191,$AT$2:$AT$10000,">"&0),"")
    Again, the red 2 assumes your data starts at row 2; adjust if it doesn't and the $ symbol is important.

  5. #5
    Sorry, but it doesn't seam to work. It does count from the top of first AJ countif, but I need it to count from the bottom of the first AJ countif.

    IF(COUNTIF(AJ$2:AJ2390,AJ2390)=1,COUNTIFS(AJ2390:AJ$10001,AJ2390,AQ2390:AQ$10001,">"&0),""))

    Thank you for your patience

  6. #6
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,418
    Articles
    0
    Excel Version
    365
    Please supply an Excel file with a column of data and a few expected results in the right places.

  7. #7
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,468
    Articles
    0
    Excel Version
    Excel 2016
    toony, please post links to all forums that you crossposted at. You have several people working on the same problem and we don't know it.

    Please read this article to understand the problem: http://www.excelguru.ca/content.php?184

    Last edited by NBVC; 2014-04-09 at 12:57 PM.


  8. #8
    Apologies about it. I understand. I think that I didn't apply it correctly and that's why is not working for me. I should try it tomorrow and let you know, but should work. Many thanks for your help and for your pacience

  9. #9
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,468
    Articles
    0
    Excel Version
    Excel 2016
    toony,

    where is the link to the other forums?


Tags for this Thread

Posting Permissions

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