Returning the date for the most recent value.

[cajunlibra]

I wasn't sure how to word my search query so I'm asking here. I can't post HTML due to being on a work computer.


I'm using the following formula to get the most recent(farthest right) value in a row. I have no idea how this formula works but I know that if gives me what I want.

Please Login or Register  to view this content.

The data is set up by date. The oldest date is in the far left column after the list of names.

Column 1 is a list of names.
Say there are 5 people.
Row 1 has Dates for headers. Say there are 10 dates.
Each cell may have anything in it. I'm concerned with only the most recent number value.

For instance:
Person 1: 5 on 1/1/17, 6 on 2/1/17, Nothing on 3/1/17, 0 on 4/1/17. In this case, the above formula would give me 0.


I'd like to also return 4/1/17 somehow. Is this possible?

Thanks in advance.

[FlameRetired]

Do you mean like this?

If so array enter this formula in B2 and fill down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Please Login or Register  to view this content.

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1			1/1/2017	2/1/2017	3/1/2017	4/1/2017	5/1/2017	6/1/2017	7/1/2017	8/1/2017	9/1/2017	10/1/2017	11/1/2017	12/1/2017
2	Person 1	4/1/2017	5	6		0
3	Person 2	8/1/2017	8	7				0	2	9
4	Person 3	5/1/2017	3	8	6	8	0
5	Person 4	7/1/2017	6	1	4	7	9	9	9	giraffe	snake	lion
6	Person 5	10/1/2017	3	6	1	2	2	5	10	1	5	10

[cajunlibra]

Yes. Is it possible to have the formula in B in column O instead?

[cajunlibra]

Nevermind. I did. Thank you very much.

[FlameRetired]

Good deal. You are welcome. Thank you for the feedback.