6/1/2019

  1. R

    List of accounts if match date

    I have two tabs. The first tab has a list of numbers numbers with dates. The second tab has the same loan numbers but has amounts with the account number. I know a VLOOKUP will work here but my boss is wanting a formula. I know a pivot table will work. So if I had a cell with a date and can...
  2. M

    Sorting, grabbing, and averaging a lot of data into a few cells by date...

    I need some assistance trying to grab some data from one column and move it to another. Let’s say I have column P with dates of the month, the data in this column will change at times. Say 10 samples per day. Column “Q” has a number for each sample. I would like to scan “P” and report the...
  3. F

    Offset Match Match with multiple Vertical Criteria

    I'm using the below formula <colgroup><col span="13"></colgroup><tbody> End Result Chart (ER) Model (M) Basis Tab (BT) A B A B C… A B C… 1 5/1/2019 1 5/1/2019 6/1/2019 1 5/1/2019 6/1/2019 2 OK 510 2 Total OK 510 500 2 Total OK OK 3 TX 690 3 Total TX 690...

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