Year Finder

[sadasivan]

How to find year from sales register ??
Find the attached work for the reference

 

[Somendra Misra]

Hi,

Try below formula in K3 and copy down:

="Last Sold On "&INDEX(TRIM(MID($C$2:$J$2,FIND(" ",$C$2:$J$2),255)),,LOOKUP(9.9999E+307,IF($C3:$J3<>"",$C3:$J3),COLUMN($C$2:$J$2)-COLUMN($C$2)+1))

Note this is an array formula so must be entered with Ctrl+Shift+Enter.

Regards,

 

[shrivallabha]

This also works with your data. Normally entered.
=IFERROR("Last Sold on "&TRIM(SUBSTITUTE(LOOKUP(9E+307,C3:J3,$C$2:$J$2),"Year","")),"")
Copy down

 

[sadasivan]

This also works with your data. Normally entered.
=IFERROR("Last Sold on "&TRIM(SUBSTITUTE(LOOKUP(9E+307,C3:J3,$C$2:$J$2),"Year","")),"")
Copy down

Thank you ...Thank you ...Thank you ... Thank you very much

 

[sadasivan]

This also works with your data. Normally entered.
=IFERROR("Last Sold on "&TRIM(SUBSTITUTE(LOOKUP(9E+307,C3:J3,$C$2:$J$2),"Year","")),"")
Copy down

Hi,

Try below formula in K3 and copy down:

="Last Sold On "&INDEX(TRIM(MID($C$2:$J$2,FIND(" ",$C$2:$J$2),255)),,LOOKUP(9.9999E+307,IF($C3:$J3<>"",$C3:$J3),COLUMN($C$2:$J$2)-COLUMN($C$2)+1))

Note this is an array formula so must be entered with Ctrl+Shift+Enter.

Regards,

Hi,

Try below formula in K3 and copy down:

="Last Sold On "&INDEX(TRIM(MID($C$2:$J$2,FIND(" ",$C$2:$J$2),255)),,LOOKUP(9.9999E+307,IF($C3:$J3<>"",$C3:$J3),COLUMN($C$2:$J$2)-COLUMN($C$2)+1))

Note this is an array formula so must be entered with Ctrl+Shift+Enter.

Regards,

Thank you ...Thank you ...Thank you ... Thank you very much