Posted to microsoft.public.excel.misc
|
|
Eliminating Blanks in a Summary Sheet
Max:
I am somewhat confused by your formulas...
can you break it down (dumb it down) for me.
Thanks.
"Max" wrote:
Another approach is illustrated in this quick sample:
http://www.savefile.com/files/911334
Pull over only source lines with key col filled.xls
Assuming source table in cols A to C in sheet: Input,
with key col = col A, data running in row2 down
In sheet: Summary,
B1:D1 carries the same col headers as in A1:C1 in Input
In A2:
=IF(Input!A2="","",ROW())
Leave A1 blank
In B2:
=IF(ROWS($1:1)COUNT($A:$A),"",INDEX(Input!A:A,SMA LL($A:$A,ROWS($1:1))))
Copy B2 to D2. Select A2:D2, copy down to cover the max expected extent of
data in "Input". Hide away col A. Cols B to D returns the required results
from "Input", ie only lines from the source table where the key col A is
filled, with all lines neatly bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"thaenn" wrote:
I have created a worksheet that allows me to input various types of data,
which direct inputs the data to a Summary Sheet (separate tab). Is there a
way to have the Summary Sheet be more condensed by eliminating the blank
(empty) information from the Data sheet (not all of the data areas will be
filled in every time). Any help is appreciated!
Tom
|