most recent

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...

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...

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...

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...

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...

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...

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...

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...

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...