vba to find mode value for several arrays of different lengths

[rossbritton26]

Hi,

I have a spreadsheet with approx 10,000 rows, with each "person" in the spreadsheet taking up between 1 and 38 rows, depending on who they are.
In column "GR" i have a text value for each entry relating to that "persons" position.
I am trying to produce a s/sheet which has one row for each person and shows me the most frequent (mode) position for that person, no matter how many entries they have.

I think this should be possible with a not too complicated piece of vba, any ideas?

 

[wigi]

Hello there

Did you look at a pivot table and its functionality?
I would not use VBA-code here.