Forum Discussion
Solved
Formula to find first and last value on row and return corresponding header column
In my spreadsheet i have row L19:AZ19 which contain duplicate number data and empty cell where i want function to find the last occurrence number then return column Header $L$2:$AZ$2 which contain Mo...
=INDEX($L$2:$AZ$2,LARGE(IF((ISNUMBER($L19:$AZ19))*($L19:$AZ19<>""),COLUMN($L$1:$AZ$1)-11),1))You can try this formula to find the last value and return the corresponding header column. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=INDEX($L$2:$AZ$2,LARGE(IF((ISNUMBER($L19:$AZ19))*($L19:$AZ19<>""),COLUMN($L$1:$AZ$1)-11),1))You can try this formula to find the last value and return the corresponding header column. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
it works.... ! thank you so much, Please share the formula for the first pay.... OliverScheurich
=INDEX($L$2:$AZ$2,SMALL(IF((ISNUMBER($L19:$AZ19))*($L19:$AZ19<>""),COLUMN($L$1:$AZ$1)-11),1))You are welcome. You can try this formula to find the first value and return the corresponding header column. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
