...with only one cell of text. Another formula computes columns that would only have one name in it, but I can't figure out how to extract that one cell of text (A Person's Name) from that full column. Any answers? Thanks
...with only one cell of text. Another formula computes columns that would only have one name in it, but I can't figure out how to extract that one cell of text (A Person's Name) from that full column. Any answers? Thanks
Like this?
=INDEX(A:A, MATCH(REPT("z", 255), A:A) )
That's awesome! What does "z" stand for? Problem with formula occurs once I get into B columns. It works from A-Z and AA through AZ but starting with BA it returns nothing. Thanks
Attached is example of what I am doing.
In Cell G29 I need a formula that first determines that there is only one occurance of 1 in column G. Then if that is true, I need to return the last name of the person in column A. If the first question is false (multiple 1s) then it returns "no winner" as shown in Cell I29.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks