Hi Everyone,
I'm looking for a formula I can use to populate columns H,I,J,K with the number from columns B,C,D,E that appears most frequently under each 3 digit PC. Any help would be greatly appreciated.
Thank you
Hi Everyone,
I'm looking for a formula I can use to populate columns H,I,J,K with the number from columns B,C,D,E that appears most frequently under each 3 digit PC. Any help would be greatly appreciated.
Thank you
Last edited by Abell; 03-19-2019 at 01:27 PM.
Would you clarify your request please and add some typical results.
As far as I can see there is only ONE number e.g. 3090145 in the case of AOA for each PC number so I don;t understand wat you mean by the most frequent number.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
For some like A0A it is only one number so just pulling that number 3090145 is fine. There are other 3 digit codes where for example there might be 5 different Rep Numbers. I want it to pull the Rep number that shows up most frequently under that 3 digit code.
"The number...that appears most frequently..."
What happens if it's a draw within that the 3-digit PC under that heading, e.g. 309145 appears 5 times under A0A and 2000145 also appears 5 times.
What would you want to see then?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Sorry I should have clarified better. I only want each formula looking at each specific column. IE for A0A the reps would be 3090145,2000145,2000145,3873131 in columns H,I,J,K. If it happens to be a draw under column B if possible leave the cell blank.
Thank you
Does this right?
H2 drag across and down
=MODE(INDEX(B$2:B$26574,MATCH($G2,$A$2:$A$26574,)):INDEX(B$2:B$26574,MATCH($G2,$A$2:$A$26574))+{0,0})
That does it. Thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks