make list of information from different cells

A

ACTLibrarian

Hello!

I'm trying to write a string that will tell the program to look at one cell,
determine if it is emply and if it is empty (which would be true?) then add
the text from another cell to a list. Basically I'm trying to make a list of
email addresses of people who haven't finished a project.
 
G

Guest

=if
(cell_that_should_be_empty=""),the_cell_you_want_instead,ce
ll_that_should_be_empty)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Macro to Select text from a point given to a specific word 2
Function in Excel to count and list number of entries of text valuesin a row. 2
copy specific cells from sheets if the information is correct 3
Creating Labels Over 3-Up Image 2
Excel Formula - If Cell contains word and select it from a list? 0
repeatedly extract a field to create a new list in another file? 1

Top