Text/String Version of Max formula
I have a sheet where I am writing rows and not all entries will update each column. I want to reference that column on another sheet and only return the value that is not blank. I can't quite get the ISBLANK formula to work for this.
I've done this with dates using =MAX(range). Not sure how to accomplish with text.
Thanks for the help in advance.
Help Article Resources
Check out the Formula Handbook template!