index aggregate

  1. A

    List All Rows in Database which Belong to X Employee

    Hello, I have a timesheet database which has a row for every period an employee has clocked in during a pay period (typically 30x per period). On another worksheet, I have a summary by employee (grouped every 50 rows). I've written the below formula and have successfully output the data...
  2. R

    Possible Index Aggregate formula required

    Hi All I require a formula using the below list that has been created, and using Aberdeen as an example, assuming they appear 50 times in the A column with their result in the B column. I need a formula to record their first appearance on the above list using cell A2 on the below list, and...
  3. S

    INDEX MATCH only returning first match

    I have a spreadsheet that has over 100 companies and their associated plans, locations and rating tiers (1-4). The user would manually select the company, plan and location and the formula would retrieve the 4 different rates. I tried using INDEX MATCH, but the problem is if the rates are not in...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top