For instance:
A1 = Hey
B1 = Hello
I want C1 to display Hello since it is longer than Hey
For instance:
A1 = Hey
B1 = Hello
I want C1 to display Hello since it is longer than Hey
Hi bjcowen,
See if the attached helps answer your question.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks for the effort; however, I want to bypass having to create a Length column
OK bjcowen,
Here is your answer but get ready to study a little. You will need to use Array formulas and enter the formula with a Control-Shift-Enter key combination. Read http://www.cpearson.com/excel/ArrayFormulas.aspx and here is the attached answer.
Like this then
Formula:Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks