Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEATransposed grid data to list; split out salary from I/J Flag
Cross tabbed the Rate table and then add multi row tool to add in from salary range (assumed that the salary in original table is the top level of that rate)
Cross product joined the above two (using the Append fields tool) and then applied formula to flag if row is in the salary range. Filtered out only valid Rates and then finish off with a summary tool to count for each rate and sorted descending. Did not use the company table as its not adding any value, if the table had another column with a meaningful company name then would use to join in or use replace tool
Easy path for me this time!