I have a spreadsheet that I want to autofilter, but the design of the
spreadsheet is preventing me from picking up all of the data. I downloaded
some data out of Oracle and it's set up like this
A B C
D
Customer Name Project Name 2004 2005
Customer XYZ Project 1 100
200
Project 2 0
150
Project 3 280
0
Customer ABC Project 1 240
100
Project 2 0
120
and so on...
So when I filter column A and make a selection I only see Project 1, and
none of the other projects under that customer. Is there any way to get all
of the projects under a customer, or is there an easy way to get excel to
populate those cells in column A? For example using the above data, get
cells A3 and A4 to read Customer XYZ, and get A6 to read Customer ABC?
Ted
Bookmarks