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.

Do you want an if statement?

Formula:

Please Login or Register  to view this content.

Hi cpassons. Welcome to the forum.

Do you mean like this?

In cell C9 this formula.

Formula:

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

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