Unfortunately my data will have voids in them. There could be data in Date2
and Date6 and nothing in Date3, Date4, Date5. Data location in the columns
will change on each row. I would want to be able to use the data in the last
used column (whatever column it maybe) as well as the second last column
(whatever column it maybe) and take these 2 data points with the date headers
and use them in a formula as I go down each row.

"Herbert Seidenberg" wrote:

Assuming there are at least 2 items in each row
and no gaps between items
and your data is arranged like this:
Date 1 Date 2 Date 3 Date 4 Date 5 Date 6 Results
9 1 6 5 2 5 2Date 5
5 6 7 8 1 8Date 4
4 3 5 9 5Date 3
7 9 5 9Date 2
4 3 4Date 1

Name the 5 x 6 array of numbers array1.
Name the 1 x 6 array of dates ddate.
The Results formula (in R1C1 ref style) is
=INDEX(array1,,COUNTA(array1 R)-1)&INDEX(ddate,,COUNTA(array1 R)-1)
Revert to A1 ref style, if desired, after entering formula.