latest data

  1. S

    Pulling values from certain columns based on criteria from multiple sheets on the same workbook and populating in a separate workbook.

    Hi All, I have a real problem which I just cannot resolve, struggling to even know where to start to be honest! So.... I have a workbook called "Subcontractor Order Record". Within that work book are 2 worksheets, once called "Order Record", as follows: and one called "Payment Record", as...
  2. H

    Find Latest value that meets Criteria

    I am wondering how can i find the latest information that meets my criteria, because all my table are run form a formula we the "Blank" cells will always read as a')', there fore i am having a Countif, Sumif, Maxif, etc issues, i am probably just typing my formula incorrectly. Based on the...
  3. S

    Recursive lookup, get last, newest occurrence of a value

    Excel 2010 - I have data that is in the following format. It is sorted in date order, ascending. Excel 2010ABC1keyValdatenewKeyVal20-40872016-02-17 13:40:21.8430B410530-40922016-02-17 13:40:21.970044-61940-40872016-02-17 13:40:22.017044-61950B41052016-02-17...
  4. R

    Remove repeated headers in Imported Text file

    Hi Guys I have a problem at work where I need to remove the repeated headers that appear on excel because of the text file I import data from. If I am to state the required task it is such- I need to write a macro to choose the latest text file from a particular folder and then put it in the...

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