how to ignore blank cells

A

aloiz

Hi, I'm trying to summarize feedback from a questionnaire. In a separate tab
from the questionnaire, I would like to summarize the verbal feedback users
have entered in the original sheet. I could do a simple lookup from one tab
to the next (one cell to one cell), however, I do not want to include cells
that are empty in my summary tab.

Is there a way to get excel to read and enter only the cells that have data
entered in them?

Thanks,
Antonella
 
X

xlmate

would you provide the formula that you are using?
and an example of how your data layout is like?
--
Your feedback is very much appreciate, pls click on the Yes button below if
this posting is helpful.

Thank You

cheers, francis
 

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

Top