Last date

[Tofik]

Hi guys, I have a question about Last Date formula. Name of worker can be as in first column as in second column.
Thanks guys.

What I have
Worker 1	Worker 2	Job was done			Total Workers	Last date of work
John	Rick	01.01.2021			John
Rick	n/a	02.01.2021			Rick
Emmi	Noland	03.01.2021			Emmi
Noland	John	07.01.2021			Noland
Sam	n/a	17.01.2021			Sam
John	Sam	01.01.2021
Rick	n/a	02.01.2021
Emmi	Rick	03.01.2021
Noland	John	07.01.2021
Sam	Emmi	17.01.2021
What I need
Worker 1	Worker 2	Job was done			Total Workers	Last date of work
John	Rick	01.01.2021			John	18.01.2021
Rick	n/a	02.01.2021			Rick	20.01.2021
Emmi	Noland	06.01.2021			Emmi	17.01.2021
Noland	John	10.01.2021			Noland	10.01.2021
Sam	n/a	17.01.2021			Sam	18.01.2021
John	Sam	18.01.2021
Rick	n/a	20.01.2021
Emmi	Rick	03.01.2021
Noland	John	07.01.2021
Sam	Emmi	17.01.2021

 

[Saba Sabaratnam]

Hi

Enter this formula in G4 and copy it down

=MAX(MAXIFS($C$4:$C$13,$A$4:$A$13,F4),MAXIFS($C$4:$C$13,$B$4:$B$13,F4))

Kind regards

Saba

 

[Tofik]

Hi

Enter this formula in G4 and copy it down

=MAX(MAXIFS($C$4:$C$13,$A$4:$A$13,F4),MAXIFS($C$4:$C$13,$B$4:$B$13,F4))



View attachment 41796

Kind regards

Saba

It will be a little arrogance, but can I give another task? Because I forget the main column in my table ?‍?‍?‍ ( Procedure )

What I have
Worker 1	Worker 2	Job was done	Procedure		Total Workers	Last date of work	Procedure
John	Rick	01.01.2021	1		John
Rick	n/a	02.01.2021	2		Rick
Emmi	Noland	03.01.2021	5		Emmi
Noland	John	07.01.2021	3		Noland
Sam	n/a	17.01.2021	3		Sam
John	Sam	01.01.2021	3
Rick	n/a	02.01.2021	2
Emmi	Rick	03.01.2021	1
Noland	John	07.01.2021	1
Sam	Emmi	17.01.2021	13
What I need
Worker 1	Worker 2	Job was done	Procedure		Total Workers	Last date of work	Procedure
John	Rick	01.01.2021	1		John	18.01.2021	to choose procedure which I want as a drop window
Rick	n/a	02.01.2021	2		Rick	20.01.2021
Emmi	Noland	06.01.2021	5		Emmi	17.01.2021
Noland	John	10.01.2021	3		Noland	10.01.2021
Sam	n/a	17.01.2021	3		Sam	18.01.2021
John	Sam	18.01.2021	3
Rick	n/a	20.01.2021	2
Emmi	Rick	03.01.2021	1
Noland	John	07.01.2021	1
Sam	Emmi	17.01.2021	13

 

[Tofik]

Guys how I can lock my WPS to my MAXIFS .... ?

I want when I choose the WPS number date will find from WPS range...... Who can correct the formula ?

=MAX(MAXIFS(H5:H8;F5:F8;K5);MAXIFS(H5:H8;F5:F8;K5);MAXIFS(I5:I8;F5:F8;L5);MAXIFS(I5:I8;G5:G8;L5))

AF-099-QF-199 Welding Log FINAL VERSION W.xlsb
	E	F	G	H	I	J	K	L	M	N
2
3
4		WELDER 1	WELDER 2	WELD DATE	WPS		Welder	WPS	Last Welded Date
5		PW-010	N/A	01.01.2020	1		PW-010	1	02.01.2022
6		PW-020	PW-010	02.01.2021	1
7		PW-022	N/A	03.01.2021	1
8		PW-010	N/A	02.01.2022	2
9
10
11
12
13
WQT Weld Date

Cell Formulas
Range	Formula
M5	M5	=MAX(MAXIFS(H5:H8,F5:F8,K5),MAXIFS(H5:H8,F5:F8,K5),MAXIFS(I5:I8,F5:F8,L5),MAXIFS(I5:I8,G5:G8,L5))

 

[FormR]

Hi, you need to add the additional criteria to the existing MAXIFS() functions, using your layout for example.

=MAX(MAXIFS(H5:H8,F5:F8,K5,I5:I8,L5),MAXIFS(H5:H8,F5:F8,K5,I5:I8,L5))

 

[Tofik]

Hi, you need to add the additional criteria to the existing MAXIFS() functions, using your layout for example.

=MAX(MAXIFS(H5:H8,F5:F8,K5,I5:I8,L5),MAXIFS(H5:H8,F5:F8,K5,I5:I8,L5))

It works, thank you my friend. Good Job ?