Iam trying to show visual representation of which agencies had what percentageof candidates on an interview slate for each department. From the examplebelow, firm 2 had two candidates on slate for the FN openings, firm 1 had 1 andfirm 3 had one. So, not only do I need a way to pull this data from the columns(vlookup?) I need to assemble it in a way that will graph. The last example isparticularly challenging as several firms had candidates for one of theopenings. Any help would be greatly appreciated.
