Hi I am trying to find the rank based on the length of the text in the cell.
is there a way that I can do it without helper cell , using formula.
Hi I am trying to find the rank based on the length of the text in the cell.
is there a way that I can do it without helper cell , using formula.
Try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter.
In B2
and copy down.Please Login or Register to view this content.
Is this what you are trying to achieve?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thanks, this really works
You're welcome. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks