Results 1 to 2 of 2

Finding an occurrence in a column

Threaded View

  1. #1
    Registered User
    Join Date
    11-29-2007
    Posts
    12

    Finding an occurrence in a column

    I have a list of names in column A1:A20. Within that list , there are names called "Blank". There may be up to 4 of these. In Column D1:D4 I have D1="", D2="B", D3="C" and D4="". This could change.
    I need a formula to return the first non-blank letter (B), which is in D2 in Column B next to the first instance of the name "Blank". Then the next non-blank letter (C), which is in D3 next to the second instance of the name "Blank" in Column B.

    Is this possible?

    Thank you in advance for any help you can provide.
    Last edited by drltr6; 11-07-2022 at 10:45 PM. Reason: Incorrect symbols

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding last occurrence of value in row range
    By Gti182 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-19-2017, 10:28 AM
  2. [SOLVED] Finding first occurrence of weekday, then use different column
    By slade8200 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-16-2016, 01:51 PM
  3. Find each occurrence in a column and do for each occurrence
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2014, 12:29 PM
  4. Finding second occurrence is not working
    By allanpark in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-06-2014, 02:39 PM
  5. Finding second occurrence. HELP!
    By allanpark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2014, 09:50 PM
  6. [SOLVED] Finding row number of last occurrence
    By Masquerader1973 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2013, 01:45 PM
  7. [SOLVED] Finding the last occurrence of a value in a list
    By _Josh_ in forum Excel General
    Replies: 9
    Last Post: 11-09-2012, 09:23 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