max date

Hi, In column A I've got dates and in column B I've got different text strings. I would like to find the most recent text string (maximum value in A with corresponding value in B). This to be inserted into a comment, such as this: SisteRev = Range("J10").ClearComments...

Do you know how I would do the opposite? Meaning take another control date (this one later than the first one), matching it against the same list (sorted descending), and finding the first date BEFORE the date in question? In other words, or this second number, the period does NOT count the...

I have a growing log of sales activity where each row contains a Sales Stage, a $$ value, a sales rep name, and a date of creation. Each time a sale is progressed to the next stage, a workflow adds another row to the log containing. I want my reporting tool to create a history of "How much $$$...

I am working on a project sourcing and supplying aprox 400 temp mining crew with accomodation varying from hotels, Guesthouses to private homes. Sheet 1 contains all the owners details Sheet 2 Contains all the various properties pulling info from sheet 1 via Vlookup Sheet 3 Contains all the...

Hi all - I have a query that I am trying to return the closest matching date (but in the past) where I do not get a hit between the joins. Something like this: iif(A.DateVal is null, (Select Max(B.DateVal) From B Where (B.DateVal<=A.DateVal)),A.DateVal) This returns a -1 What am I missing?