How to ignore blank cells in a summary worksheet

  • Thread starter Thread starter TR6
  • Start date Start date
T

TR6

Hi,

Here's the scenario:

A worksheet contains 10 rows for user data entry in one
category, another 10 for the next category and so on.
Users can enter 1 to 10 items into each category.

A summary sheet collects the data from the worksheets,
however, I can only obtain the data by direct cell
reference so if a category contains 1 item I get 9 blank
rows until the next category starts.

Is it possible to get excel to look at a cell reference,
ignore it if blank and move to the next until it finds
data?
 
Hi
try an array formula (entered with CTRL+SHIFT+ENTER):
=INDEX('sheet1'!$A$1:$A$10,SMALL(IF('sheet1'!
 
Back
Top