# Help with a formula for frequency

1. ## Help with a formula for frequency

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  Register To Reply

2. ## Re: Help with a formula for frequency

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.  Register To Reply

3. ## Re: Help with a formula for frequency

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.  Register To Reply

4. ## Re: Help with a formula for frequency

"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?  Register To Reply

5. ## Re: Help with a formula for frequency

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  Register To Reply

6. ## Re: Help with a formula for frequency

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})  Register To Reply

7. ## Re: Help with a formula for frequency

That does it. Thanks very much  Register To Reply