Autofilter on a worksheet with merged cells

[Guest]

Hi,
I am prepaing a worksheet where I have one column containing employee names,
with each employee name spread across 10 merged cells. The rows of those
merged cells containing information specific to each employee..so what I need
to know is whether there is a way for autofilter to work such that when I
select a particular employee name from the list, it should show the 10 rows
for that employee, and not just the first row, as is happening now..
Please help.
Regards,
Ashish

 

[Bernie Deitrick]

Ashish,

Solution 1:
Select all the merged cells, and unmerge them. Without changing the selection, use Edit / Go to..
Special Blanks, and then type = and press the up arrow key once, and press Ctrl-Enter. Then copy
the entire column and paste special values to remove the formulas.

Solution 2:
Insert another column, and in the 10 cells of that column for each employee, put in references to
the cell with the name. Do that for every employee. Then copy that column and paste special values
to remove formulas.

Then your autofilter, which works on Databases, will work fine.

HTH,
Bernie
MS Excel MVP

 

[Guest]

Hi Bernie,
I found solution #1 good for me..thanks for your help.
Cheers!
~Ashish