+ Reply to Thread
Results 1 to 7 of 7

Formula to find blank cells in a range, then if blank to give the name of the column

  1. #1
    Registered User
    Join Date
    02-27-2018
    Location
    Greece
    MS-Off Ver
    MS 2003
    Posts
    3

    Formula to find blank cells in a range, then if blank to give the name of the column

    Hello all-

    I can usually figure out formulas for excel on my own, either through trial and error, or research, but this one has me stumped. Please help!

    I need a formula that looks at specific range of cells say C8:N8. Then if there is a blank cell in that range to look at cells C4:N4 and give me the title of that blank cell column. This is just a broken down version, but ultimately, the formula will look at another sheet in the cell range I give and find blank cells, then tell me the Title of the column for hundreds of people for 30-50 task.

    Thanks in advance.

    EDIT-

    I will give a quick example. Let's say in row C1 there is a name. In A1:G1 there are items. I want the formula to search C2:G2, look for blanks, then if it finds one tell me the title from A1:G1. A report of missing items for a particular person. This is just an example, but I am using to search about a hundred names and 50-60 items.
    Last edited by cpassons; 02-28-2018 at 12:30 AM. Reason: adding information

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,143

    Re: Formula to find blank cells in a range, then if blank to give the name of the column

    Do you want an if statement?

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-27-2018
    Location
    Greece
    MS-Off Ver
    MS 2003
    Posts
    3

    Re: Formula to find blank cells in a range, then if blank to give the name of the column

    Maybe. It get's me one cell at a time. I want the formula to look at a range of cells. Then only return the title of the blank cells in C4:N4.

  4. #4
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Formula to find blank cells in a range, then if blank to give the name of the column

    I'm going to assume that the titles of Columns C through Column N are in the first row.

    Select the range C4:N4 and hit ctrl+G and then click on "Special" then click "Blanks" and click on OK. Go up to the formula bar and type in =C$1 and then (VERY IMPORTANT) hit ctrl+enter. Do not hit JUST enter. This will fill in all blanks with whatever is in the column heading, which i've assumed is in the first row (C1:N1). Adjust as necessary.

    When done, you can just select everything and then copy and paste/values to replace the formulas.

  5. #5
    Registered User
    Join Date
    02-27-2018
    Location
    Greece
    MS-Off Ver
    MS 2003
    Posts
    3

    Re: Formula to find blank cells in a range, then if blank to give the name of the column

    Hoyasaxa215-

    Sorry this is not what I am looking to accomplish. This fills in the blanks, I don't want to fill them in, I just want to know what column title they are under.

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365, rarely 2007
    Posts
    12,624

    Re: Formula to find blank cells in a range, then if blank to give the name of the column

    Hi cpassons. Welcome to the forum.

    Do you mean like this?

    In cell C9 this formula.
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    1
    2
    3
    4
    Person 1
    Person 2
    Person 3
    Person 4
    Person 5
    Person 6
    Person 7
    Person 8
    Person 9
    Person 10
    Person 11
    Person 12
    5
    6
    7
    8
    Bob
    John
    Mike
    Kelly
    Martha
    Joe
    Rachel
    Liz
    Elsie
    JoAnne
    Allen
    9
    Person 4
    Dave

  7. #7
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,143

    Re: Formula to find blank cells in a range, then if blank to give the name of the column

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.


    To add a file to a post

+ 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. [SOLVED] Formula Index Column to find first blank cell and sum cells in different Column
    By Hood in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-18-2017, 07:57 PM
  2. [SOLVED] Formula to find the last cell value in a column range that contains blank cells
    By Bonzopookie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-29-2014, 07:50 PM
  3. Replies: 12
    Last Post: 09-19-2014, 10:18 PM
  4. [SOLVED] using a max formula on a column with no data to give a Blank result
    By Brentsa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2013, 05:42 AM
  5. Find & select 1st blank cell in a range of formulated column cells
    By jnbroek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2013, 09:26 AM
  6. Replies: 4
    Last Post: 06-24-2013, 07:17 AM
  7. [SOLVED] Find first non-blank cell after a group of blanks copy offset cells, find next blank, loop
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-21-2012, 06:11 AM

Tags for this Thread

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