Hello,
I was playing with some MAXIFS formulas to try and get the highest count based on multiple criteria.. without luck.
I made an example attached that shows what I am looking to do.
But basically I am looking for the highest count of a value based on date & shift.
I appreciate any help.
Thank you,
Nick
Please add manually the expected results of the formula, so I understand exactly what you mean and want.
Is this what you want? In C3:
=MAXIFS(G$10:$G100003,F$10:$F100003,$A3,B$10:$B100003,C$2)
As Hans has said, and as you know from previous threads, you really need to provide at least SOME manually calculated expected results to give us a steer on this.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
A guess. two formulae. Here's one:
=IFERROR(ROWS(FILTER($F$10:$F$10000,($F$10:$F$10000=$A3)*($B$10:$B$10000=C$2))),0)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you for the feedback. I uploaded another sample, color coded with manual values.
I appreciate the help.
My proposal.
Formula:
Please Login or Register to view this content.
Last edited by DJunqueira; 02-10-2024 at 01:47 AM.
Another way:
Please try in C3 and copy to the right and down:Formula:Please Login or Register to view this content.
Thank you both! Each of those works great.
Hi DJunqueira, I had to change the wording in my worksheet from Issue to Issued and Return to Returned.
I see how to edit the formula for Issued, but I am not sure where to edit for the change in the wording Returned.
Thanks,
Nick
You are Welcome!
Thanks for the feedback and rep.
Glad to have helped.
You may change the 'S' by 'd'.
Formula:Please Login or Register to view this content.
Thank you DJunqueira, I changed it like this,But the Issued and Returned counts are not showing.
Please Login or Register to view this content.
Example attached.
Hi DJunqueira, I am still playing with this, I think there must be another change that is needed, that I can't figure out.
If you are able to help out. thanks
Kind of same situation.
You were taking out the "D" that you added in ISSUED.
Formula:Please Login or Register to view this content.
Thank you! That did it. I appreciate your help.
Tks for the feedback, glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks