Search results

That would not be possible as the claim could not have been processed without documents being received. This did bring up a very good point. The query that I used to mine the data just pulled the last date each document was received, not all the dates that each doc was recevied. I re-wrote the...

1) It is possible for all the docs to be received on the same day. There are 7 different docs. 2) That is correct. 3) That is correct. 4) Yes, I want the max date prior to the date processed (first column)

Maybe I am not explaining it properly, I put what you suggested in the cell, only change was to reference the correct cells. =IF(MAX(G2:L2)>D2,"",MAX(G2:L2)) If the max from G2:L2 is greater than the date in D2, then the cell is blank. If the max from G2:L2 is less than the date in...

For each row. That works, but if any of the dates in columns G thru L are later than the date in Column D, it returns a blank cell. I need it to return the max date prior to the date in Column D.

I have a spreadsheet that has 6 columns of dates, G thru L, that I need the max date that it is not later the date in column D. I need the result in column N Sample data: D F G H I J K L 7/30/2012 12/27/2012 blank 12/27/2012...