index match date before

  1. N

    How to Look Up an Excel Timestamp between Two Dates

    Hi All, I have a spreadsheet that will eventually contain a lot of data and I want to be able to use formulas and data validation to populate that data onto another sheet by date. I can't use the filter tool in my case. On the sheet with all the data column A has a timestamp formula...
  2. C

    Alternative to Array Formula for summarizing/counting table information

    Hello, I am trying to summarize information contained in a "calendar". The information looks like this: 27/Mar/16 28/Mar/16 29/Mar/16 30/Mar/16 31/Mar/16 01/Apr/16 John 1 1 1 1 Oliver 2 2 2 2 Mac F F F F F F I basically need for each name a count...
  3. M

    Latest result before a certain date

    Hi everyone, I'm battling with this one...would like an Index Match formula to find the last test result before a certain date for a certain userid e.g. at Oct 31 mchansa04 result of her last test was 60% written on 18th Sept. For techima05 its 68%. Thanks in advance! Excel...

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