??List...CountIF...Print???

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

Good Morning Gang!

I have a column with item numbers with a variable number
of rows between them ie;

A B C
1
2
3 1.1
4
5
6
7 1.2
8
9 2.1


I would like to create a new sheet that will reference
this column and list all the "item numbers", irnoring
blanks. ie:


A B
1 1.1
2 1.2
3 2.1


Using Sub Totals and pivot tables do not work, Any
Ideas???
 
Wayne said:
Good Morning Gang!

I have a column with item numbers with a variable number
of rows between them ie;

A B C
1
2
3 1.1
4
5
6
7 1.2
8
9 2.1


I would like to create a new sheet that will reference
this column and list all the "item numbers", irnoring
blanks. ie:


A B
1 1.1
2 1.2
3 2.1


Using Sub Totals and pivot tables do not work, Any
Ideas???
Click to expand...

Take a look here:
http://www.cpearson.com/excel/noblanks.htm
 
Back
Top