range selection date

  1. J

    LINEST with start/end conditions to select data.

    I'm looking to predict data in pumping applications. given this. I will have unknow lengths of tables that will constantly have data added and removed. I can't find a way to structure the selected data the way I would like it to be. All data is expected to be quadradic, so my basic LINEST is...
  2. S

    Range Selection based on Date and cell.value

    Hi all, Hoping someone can help me here, as im stumped. I basically want to select a range of cells and make their value = "Booked", but the range will be based on the date. So all cells less than today (and those below it) should say "booked" only. heres an example - so when a marco runs...

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