Check out Last Name Sort In Mac Numbers at YouTube for closed captioning and more options.
Last Name Sort In Mac Numbers
Comments: 6 Responses to “Last Name Sort In Mac Numbers”
Comments Closed.
Check out Last Name Sort In Mac Numbers at YouTube for closed captioning and more options.
I'm sure I saw in the video when you showed the function help that you can use -1 in TEXTBEFORE and TEXTAFTER to select the last match, which would simplify your formula a bit as COUNTMATCHES would be unnecessary.
David: You're right!
Another fine video! How did you discover the "fake space" feature? That is option+space for Van Buren?
Gene: It has been around for years. I used it in the 1990s for desktop publishing when you want to keep two words together on the same line and for similar things.
This is great Gary, You know almost everything, right? I have another wrench for my own list. I have a mixture of people's names and company names. I have tried putting the "fake space" in the company name but I get an error. Barn Yoga Group - "Argument 3 of TEXTAFTER is invalid." I guess your formula doesn't work if there are no spaces.
Dan: Right, it needs a space to work. You can use IFERROR to just use the text as-is if you like.