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???
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???