BrutalLogiC
Active Member
- Joined
- Feb 26, 2006
- Messages
- 274
- Office Version
- 365
- Platform
- Windows
hello!
I'm analysing a number of job adverts and want to find out the most popular roles from different recruitment websites.
G3:G116 is the column with the recruitment websites, there are 4 in total and they are Hays, M&C, FM World and Eden Brown, each one appears on multiple occasions
F3:F116 is the list of adverts, just a number from 1 to 114, not sure you need this
H2:AV2 is the row with different roles, there are 41 in total, no duplicates
H3:AV3 is the row for advert number 1 which happens to be from M&C, under each role it's got either TRUE or FALSE whether that role was applicable..
I want a formula that counts the most popular role from Hays, from M&C, from FM World and from Eden Brown (ideally I want a top 3 from each :P). Hopefully I explained that!??
some sort of sumproduct countif thingy?!
I'm analysing a number of job adverts and want to find out the most popular roles from different recruitment websites.
G3:G116 is the column with the recruitment websites, there are 4 in total and they are Hays, M&C, FM World and Eden Brown, each one appears on multiple occasions
F3:F116 is the list of adverts, just a number from 1 to 114, not sure you need this
H2:AV2 is the row with different roles, there are 41 in total, no duplicates
H3:AV3 is the row for advert number 1 which happens to be from M&C, under each role it's got either TRUE or FALSE whether that role was applicable..
I want a formula that counts the most popular role from Hays, from M&C, from FM World and from Eden Brown (ideally I want a top 3 from each :P). Hopefully I explained that!??
some sort of sumproduct countif thingy?!
