most recent data

  1. C

    Importing Most Recent .txt File from Folder

    I am doing some research that involves importing data sets collected by an external instrument that can only be stored as .txt files. They are always stored in the same folder and importing them with the correct formatting is extremely repetitive and can be tedious. Is there a way for Excel 2016...
  2. J

    Formula for calculations using dates under certain conditions

    Hi I'm trying to build a spreadsheet that will be able to calculate current stock levels by taking into account what the last action was (e.g. stocktake, purchase, order), etc but I don't know how to write formulas that will do what I need them to do. Any data from before the stocktake...
  3. L

    VBA code to return the most recent data

    Hi, I had posted a question for an If formula but i am thinking there might be a way of fixing my issue through VBA? This is my problem : I have a worksheet that will be constantly updated. In D53:CU54 i currently have an IF formula which looks at newly Inserted data in D100:DH101 (Via...

Watch MrExcel Video

This Week's Hot Topics

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
Top