Hi all - in need of some help.
I have a worksheet where first and last names appear inconsistently in a the same column, where there is no pattern to when the first and last name values appear in Column A, with a three to four digit code in a parenthetical next to the name (see below). Sometimes the first and last name values will appear in consecutive rows, and other times there's a gap of multiple rows. I tried reproducing what I am working with below.
The one thing that is consistent is the row height. Each cell with the name has a row height of 20.
Is it possible for me to extract all the values in that Column where the row height is 20? Is there a formula? Maybe there's a better way to extract that value?
I'd appreciate any insight, and feel free to point me to places where the question may have already been answered. Thanks a ton!
_____
The worksheet
Column A
First Name Last Name (123)
information
information
information
First Name Last Name (765)
First Name Last Name (394)
information
First Name Last Name (387)
Bookmarks