I have a document that I need to categorize and provide the average rates for certain sub groups. For instance In the sheet I need to take the average response rate or "R.R." for companies based off their eligibles. But I need companies whos eligibles fall in to the given eligible bracket to be calculated only. So for instance companies that are less than 5,000 eligibles (main data table) need to be the only ones factored in when getting the average response rate (R.R.) for the less than 5,000 eligible bracket.
Any ideas? Thanks,
Rob
Bookmarks