Find cell reference for last cell with data for each row

[JSH720]

I have this spreadsheet set up. I need to find the cell reference for the cell with the last data in the row and then the date associated with that cell. Your help is appreciated

ID

First Name

Last Name

Jan 6, 2019

Jan 13, 2019

Jan 20, 2019

Jan 27, 2019

Feb 3, 2019

Feb 10, 2019

Feb 17, 2019

Feb 24, 2019

Mar 3, 2019

Mar 10, 2019

cell Reference of Last Date Attended

Date of last attendance

11713090​

Name1

AST 1

X

X

X

11713064​

Name2

AST 2

X

X

X

11714615​

Name3

AST 3

X

X

X

11714907​

Name4

AST 4

X

X

X

11713325​

Name5

AST 5

X

X

X

X

X

X

X

X

X

X

11714598​

Name6

AST 6

X

X

X

11713327​

Name7

AST 7

X

X

X

X

X

X

X

X

11714902​

Name8

AST 8

X

X

X

11713029​

Name9

AST 9

X

X

X

X

X

X

X

X

39631882​

Name10

AST 10

11712957​

Name11

AST 11

X

X

X

11714066​

Name12

AST 12

11714059​

Name13

AST 13

X

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	ID	First Name	Last Name	Jan 6, 2019	Jan 13, 2019	Jan 20, 2019	Jan 27, 2019	Feb 3, 2019	Feb 10, 2019	Feb 17, 2019	Feb 24, 2019	Mar 3, 2019	Mar 10, 2019	Date of last attendance
2	11713090	Name1	AST 1							X	X		X	Mar 10, 2019
3	11713064	Name2	AST 2							X	X			Feb 24, 2019
4	11714615	Name3	AST 3							X	X		X	Mar 10, 2019
5	11714907	Name4	AST 4							X	X		X	Mar 10, 2019
6	11713325	Name5	AST 5	X	X	X	X	X	X	X	X	X		Mar 3, 2019
7	11714598	Name6	AST 6							X	X		X	Mar 10, 2019
8	11713327	Name7	AST 7	X	X	X	X		X		X	X	X	Mar 10, 2019
9	11714902	Name8	AST 8							X	X		X	Mar 10, 2019
10	11713029	Name9	AST 9	X	X		X		X	X	X	X	X	Mar 10, 2019
11	39631882	Name10	AST 10
12	11712957	Name11	AST 11		X						X		X	Mar 10, 2019
13	11714066	Name12	AST 12
14	11714059	Name13	AST 13		X									Jan 13, 2019
Data

Cell Formulas
Range	Formula
N2:N14	N2	=IFNA(LOOKUP(2,1/(D2:M2="x"),$D$1:$M$1),"")

 

[JSH720]

This works and is easy and totally awesome! With the amount of records I have, it will save time and increase correctness. I thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.