latest

Dear all I would scraping a client-side webpage rendered by latest FireFox (ver. 50). Now seems not possible to do the job by using SeleniumBasic open code since this is not updated to handle FireFox newer editions. Since the web window to scrap will pops up by a javascript code activated...

Hi. I have a table containing 3 columns: Location Sample Date Transmittance % value I've added the table to the Data Model in PowerPivot. I need to summarize each location with the average Transmittance% from the latest "N" sample dates. For example, the average trans% for location "A"...

So I'm not sure how to solve my problem or what formula would be best: I am copying a scanned image of a schedule from PDF, that I have recognized text on, to my excel product. I paste the data into certain cells and it should auto-calculate things for me. My issue comes from tracking the...

Hi all, I am trying to find a formula to list the last entry from column K:4:K23 These cells may change from time to time, so need the latest entry displayed Many thanks for any help

Hi, I am trying to write some code that will go through all the data in sheet2 starting on row 5 which looks at all the employee numbers and then finds only the latest entry for each employee and then copies the date for that employee (columns B:J) to the next blank row on sheet5 starting in...

Hi I have data in a table like below: <colgroup><col span="2"><col span="2"></colgroup><tbody> Pkg Type Pkg Name DEV01 DEV02 CP cp1 20-11-2017 00:00 21-11-2017 07:00 DP dp1 19-11-2017 00:00 20-11-2017 00:00 CP cp2 21-11-2017 00:00 21-11-2017 05:00 DP dp1 19-11-2017 09:00 20-11-2017...

I'm using this to try to find the latest date with the following formula; The criteria applied is a value in column A that matches D8, with the dates being in column C. The result gives me a zero, which isn't correct, but my dates are formatted as text so will that make a difference and if so...

How can I copy the latest (newest) DATE to another cell? For example I have Cells D6 to D36, some of these cells have DATES some are blank. What I would like to do is copy the latest (newest) DATE to cell D39. Thanks

Hi All I am looking to analyse equity drawdown of a portfolio. A drawdown is the loss from a peak to a trough of a portfolio, before a new peak is attained. I would like a formula which returns me the current drawdown percentage since the latest peak, and so far I have managed the following...

I'm trying to find a formula that would return the latest date for each project. For example, here is what I would like to get: <colgroup><col span="2" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody> Proj # Date Latest Date A 4/1/2017 6/3/2017 B 5/1/2017...

So, I'm trying to get the latest information based on dates for flying. <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 113px"><col width="147"><col width="170"><col width="100"><col width="152"><col...

Hi guys I have the below code, but I am getting a mismatch error on line 11. Any ideas? I'm a newbie to all this so it's got me stumped! Sub GetLatestFiles() Dim strDir As String, fs As Object, startFolder As String, subfolder As Object, increment As Integer, latest As Integer, latestFolder...

Hi guys I wish to write a macro that opens the latest version of "EGBCIS13.TXT" in Excel. However, all of the different versions of the file are located in sub-folders within "H:\Everyone\SOFTCON PCS". Can someone please point me in the direction of being able to do this. I've tried a few...

Hi there, I have a worksheet with 5 dates in cells (A1, A101, A201, A301 & A401) - they are all formatted dd/mm/yyyy I need to copy the date from these cells to other cells on another sheet but change the formats to yyyy-mm-dd - I thought I could use: Date1 = Sheets("Sheet1").Range("A1").Value...

I have a few questions for those who use Excel in a professional environment or those who consider themselves Excel proficient. Why do you consider yourself to be an Excel expert? How do you keep up with the latest developments in Excel? How do you find if something new is going on in Excel?

Hi Everyone, I am trying to figure out a way to get the latest date a which a customer has canceled a subscription. (Our customers come on and off fairly often.) Here's an example of what the data set looks like: <tbody> Account July-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17...

Hi, Is there any way we can directly pull the latest currencies from a website every time we select a certain currency from a drop down list? Eg. I want to convert a list of rates from USD to NOK. So I have a drop down cell, A2 - "USD" and "Convert to" drop down list in cell B2 - "NOK" and...

Hello, I am trying to figure out how to display the latest non-zero value in a row. Note, I am not looking for the last value (there is plenty of help here and else where on that) but the latest/most recent. Here is an example: <tbody> <tbody> Source Data </tbody> <tbody> 19.5...

I have [income]- (REVENUE) table of accounts, each account can have multiple instances for one month. how can I find the last occurrence of all the accounts in a month (and then summarize all of these latest occurrences)? account revenue revenue_date 1 100 2010-01-01 1 200...

I tried searching the forum for this, but I have only found macros to open the latest file in a specific folder. Would it be possible to open the latest spreadsheet in the latest folder? Here is what I mean: Folder 20131002 File 20131001 File 20131002 Folder 20131101 File 20131031...