Hi!
I am trying to make a formula where the longest word in a range from a different worksheet, is reflected in the same cell where I create the formula.
For example,
Cell A4 should have the formula
and the Range would be located in a Worksheet labeled Descriptions
Cell A4 would show the longest word, with a successful formula
I can't seem to get the follow array formula to work:
=CELL("",INDEX(Descriptions!A3:D3,MATCH(MAX(LEN(Descriptions!A3:D3)),LEN(Descriptions!A3:D3),0)))
I'm hoping to not have to use it, maybe there is a better way?
Please help.
I am trying to make a formula where the longest word in a range from a different worksheet, is reflected in the same cell where I create the formula.
For example,
Cell A4 should have the formula
and the Range would be located in a Worksheet labeled Descriptions
Cell A4 would show the longest word, with a successful formula
I can't seem to get the follow array formula to work:
=CELL("",INDEX(Descriptions!A3:D3,MATCH(MAX(LEN(Descriptions!A3:D3)),LEN(Descriptions!A3:D3),0)))
I'm hoping to not have to use it, maybe there is a better way?
Please help.