most recent

  1. H

    Selecting most recent date in slicer VBA

    I'm stumped on this one - I'm currently automating a file and I need the macro to select the most recent date slicer dynamically. My current code is selecting all of the dates listed in the slicer instead of the most recent date. Sub maxdateslicer() Sheets("FIP").Select...
  2. C

    Taking the most recent 6 scores and averaging them in an Array

    OK -another golf spreadsheet question! :) I want to take the most 6 recent weeks for handicap but having trouble with an efficient way to do that. It has to ignore any blank cells too. There will be 20-21 columns and want column B (A for name) to be a running most recent Handicap average of...
  3. F

    5 Most recent

    Hello People, I'm having a little bit of a problem, which i'm guessing is probably simple, but I just am overlooking it. Hopefully that is the case... (preferably not a macro as I am planning on using it on a mobile, which doesn't allow macros to work.) But i'll give it a go anyway I have a...
  4. C

    Finding the most recent year in a row for a type of school degree and displaying it in a cell

    Hello everyone, What is the best method or combination of methods to go about finding the most recent year for a Bachelor's degree in a row and inserting that year into the column shown below in the example picture? I've already populated the column in my example. Sometimes the most recent...
  5. M

    Need a formula to average the most recent X # of data points, non-contiguous cells & w/ blanks

    Excel ver. 2010, 32-bit OS Windows 7 Pro, 32-bit, Service pack 1 Normally I can find what I'm looking for online or on the boards but this one has me stumped. My actual sheet has hundreds of rows and columns but here is a simple example illustrating my challenge: Below is a table of students...
  6. L

    find most recent and table lookup

    I am designing a worksheet for someone who is less experienced in excel. Our goal is to be able to paste data into a table and have another table show that which people are delinquent in getting training done that has to be done on regular intervals. The other goal is to get another table to...
  7. D

    Lookup most recently entered (bottom) value

    Hi, I need to retrieve the most recently entered data (in the bottom row), if it matches a certain condition. Example: ROW SPORT VIEWERS 1 Football 16000 2 Rugby 8000 3 Football 12000 4 Tennis 5000 5 Athletics 500 6 Football 13500 7 Tennis 4500 I...
  8. Default300

    ?HowTo: Return Latest Date in One Field, Based on Matched Criteria in 2 Other Fields

    Hi. Can you help me solve this puzzle? Hope so. I've begun by showing the setup I have, but if you want to read the task and problem first, they're stated below. Tables have been stripped down to the essential columns; and cell references and sheet names have been simplified. SCENARIO / SETUP...
  9. L

    *!!*Use most recent*!!* GRAPHS Help

    Hello Everyone! I have a set of figures such as the following <TABLE class=MsoTableGrid style="BORDER-RIGHT: medium none; BORDER-TOP: medium none; BORDER-LEFT: medium none; BORDER-BOTTOM: medium none; BORDER-COLLAPSE: collapse; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 480...

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