+ Reply to Thread
Results 1 to 2 of 2

Extract the Value from Any Row with a Height of X (22 in my case)

  1. #1
    Registered User
    Join Date
    01-09-2020
    Location
    California, California
    MS-Off Ver
    2016
    Posts
    1

    Extract the Value from Any Row with a Height of X (22 in my case)

    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)

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    MA, USA
    MS-Off Ver
    365(PC) V:2412
    Posts
    1,477

    Re: Extract the Value from Any Row with a Height of X (22 in my case)

    Select cell A1.
    Click on Name Manager or press ctrl F3
    Select New.
    For Name put something like RowH
    Refers TO: =Get.Cell(17,A1)
    Hit Ok.

    enter =RowH+Now() in a cell you want to get the height of the row from.

    This will grab the row height when you put the formula in. If you adjust the row height after, then you need to hit F2 and then enter or change a cell so it will reupdate.
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Extract Only Upper Case Characters
    By lena_b_v in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2017, 05:44 PM
  2. EXTRACT height of picture in worksheet and paste in A1
    By Josiah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2016, 12:19 PM
  3. Replies: 1
    Last Post: 07-14-2016, 05:51 AM
  4. Extract Proper Case words
    By webbug08 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-17-2014, 01:28 PM
  5. [SOLVED] How to extract data in this case - anyone could help me?
    By wowow in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2012, 07:10 AM
  6. Look up and extract data in this special case
    By wowow in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-17-2012, 12:36 AM
  7. Extract UPPER CASE words.
    By excelkeechak in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-29-2009, 09:27 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1