last date

I have searched through many sites looking for what seems to me to be a very simple answer but nothing seems to work. This is a bogus workbook that somewhat matches a confidential workbook, thus the fictitious amounts. In column B you see text from a legend that indicates a specific activity. In...

Hello everyone I would like to find the last date on which a certain value occurred. There are a bunch of people and assigned to them are letters which change as the month progress. I would like to be able to see for an example; when was the last time the letter "W" occur for Floyd Martineau...

Hi guys, I have a question about Last Date formula. Name of worker can be as in first column as in second column. Thanks guys. What I haveWorker 1Worker 2Job was doneTotal WorkersLast date of workJohn Rick 01.01.2021John Rick n/a02.01.2021Rick EmmiNoland03.01.2021EmmiNolandJohn...

Hi - I was hoping somebody could help me out with an excel formula. I'm in operations at a landscaping company, and I'd like a better way to keep track of how many days it's been since the property was last serviced. Below is an example of the spreadsheet I have. Let's say today's hypothetical...

Hello All, I am having a bit of trouble, and am hoping someone can help me. I have a table below containing two columns: One with a planned submission, and another with an actual submission. If the submission isn't submitted, I input "Not Submitted" and if it is not required I input "Not...

Good day, I am struggling to put a formula together. I need to get the opening and closing from sheet1 (Below) and put it into sheet2. I need the balance from the last date but not later 2015-03-31. Some accounts the last date is in 2014. I need to do this for +- 23000 accounts. any assistance...

Good day. I have a puzzle that I know someone out there is able to help me with. I have a workbook where on one tab I have information about a city, and then 20+ additional pieces of information for each city in the same row. Each city has multiple entries stored here for history purposes. What...

Greetings excel guru's, I have a maintenance spreadsheet that has the following information (A)Tag #, (B)Date...(G) Condition What I'm trying to do is on a master spreadsheet, lookup the latest entry for the matching tag # and input the condition. I have tried using INDEX/MATCH, and am able...

The raw data I am working with is in the following format: <TABLE style="WIDTH: 145pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=192 border=0 x:str><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" width=74><COL style="WIDTH: 89pt...