how to ignore blank cells

  • Thread starter Thread starter aloiz
  • Start date Start date
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
 
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
 
Back
Top