Microsoft Office Forums - View Single Post - [Solved] find the first value and the last in row

Thread: [Solved] find the first value and the last in row

View Single Post

Old

02-06-2017, 07:46 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

0.86 =INDEX($K$1:$AV$1,MATCH(TRUE,$K2:$AV2="*",0)) (Array formula)

0.98 =LOOKUP(2;1/($K2:$AV2="*"),$K$1:$AV$1) (Non-array formula)

Array formulas must be committed by holding down Ctrl and Shift before pressing Enter.

Reply With Quote