Find the current status

[tahir573]

Hi All,




I need help creating an excel sheet for my project. I am posting my excel sheet data for your attention:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	S#	Name of Work	Month	Year	DateReceived	DateCreated	Last Dateof Validity	Marketing									Accounts & Finance
2								OfficerSigned	Sent toManager		Received fromManager		Sent toDirector		Received from Director		Officer Signed	Sent toManager		Received fromManager		Sent toDirector		Received fromDirector
3									O/W No.	Date	I/W No.	Date	O/W No.	Date	I/W No.	Date		O/W No.	Date	I/W No.	Date	O/W No.	Date	I/W No.	Date
4	1	Project Name: Mkt/Spl/2018/001Project Short Description:Attached Products:Approved Marketing Plan:	July	2018-19	07-Jul-2018	10-Jul-2018	10-Aug-2018	11-Jul-2018	001/O/W	12-Jul-2018	001/I/W	12-Jul-2018	002/O/W	12-Jul-2018	002/I/W	14-Jul-2018	15-Jul-2018	001/O/W	15-Jul-2018	002/I/W	18-Jul-2018	002/I/W	18-Jul-2018	002/I/W	19-Jul-2018
Master

Here you can see that I have columns (Department Names - Merged - You can say it Primary) and progress date, inwards and outwards numbers (Single Columns - not merged - You can say them secondary).


Now I want to get the current status of my file. I am trying to get the last non-blanked cell (or you can suggest me if there's another way) by using some logical formulas (if, or, and = "") but failed to get the results. Please help me solving this problem.


Best Regards!

 

[trimmjens]

Try to put following formula in cell Z4:

=LOOKUP(2,1/(E4:Y4<>""),E4:Y4)

 

[tahir573]

Try to put following formula in cell Z4:

=LOOKUP(2,1/(E4:Y4<>""),E4:Y4)

Thank you so much @trimmjens. Now my Sheet is much better and also saving my time. Thanks dear!