filtering columns not rows

[JBoy]

I need to filter a spreadsheet vertically and horizontally. is this possible and if so how?

[Ian Mac]

On 2002-05-20 16:03, JBoy wrote:
I need to filter a spreadsheet vertically and horizontally. is this possible and if so how?

Can you please expand on the problem you have, giving some example data and expected results.

[Mark W.]

No. AutoFilters operate on column labels of Excel data lists which are described in the Excel Help topic for "Guidelines for creating a list on a worksheet".

[ This Message was edited by: Mark W. on 2002-05-20 16:17 ]

[JBoy]

I have a spreadsheet with 250 names of current and ex employees across the top. Rows 1 thru to 9 show employee number, first name, surname, dept, pay type, shift, job title, supervisor,current employee?. Column A has 516 defined skill codes, and column B has the skill definitions. The various skills can be attributed to the employees. Once the matrix is completed I need to sort it and find groups of employees based on shift or dept, then sort the list to show only the cells that have C for completion in them. The skills codes are grouped 1.100 1.110 2.110 etc so a sort in that column will result in being able to see the group. that part I can do with Auto filter Custom, ends with 100 or as required but I am unable to sort across the spreadsheet.

[Ian Mac]

On 2002-05-20 16:28, JBoy wrote:
I have a spreadsheet with 250 names of current and ex employees across the top. Rows 1 thru to 9 show employee number, first name, surname, dept, pay type, shift, job title, supervisor,current employee?. Column A has 516 defined skill codes, and column B has the skill definitions. The various skills can be attributed to the employees. Once the matrix is completed I need to sort it and find groups of employees based on shift or dept, then sort the list to show only the cells that have C for completion in them. The skills codes are grouped 1.100 1.110 2.110 etc so a sort in that column will result in being able to see the group. that part I can do with Auto filter Custom, ends with 100 or as required but I am unable to sort across the spreadsheet.

First of all I think you need to re-organize your data. Where does the data come from. I think from what you described changing the format will allow you to use a Pivot Table achieve the results you require.

Also, if you can post an example of the data (If it's sensitive data post similar data) I can look at how we can do this.

the easiest way to do this is to goto an empty cell, hit '=' then highlight about 10 rows of data (not the entire row), hit F9 and copy paste what you have.

Regards

[Ian Mac]

In addition.

I have a spreadsheet with 250 names of current and ex employees across the top. Rows 1 thru to 9 show employee number, first name, surname, dept, pay type, shift, job title, supervisor,current employee?.

I'm sure what you mean by this, your saying you have Employee names across the top, but you also say that Employee Number is in row 1. which of these is the case?

[Ian Mac]

On 2002-05-20 16:28, JBoy wrote:
I have a spreadsheet with 250 names of current and ex employees across the top. Rows 1 thru to 9 show employee number, first name, surname, dept, pay type, shift, job title, supervisor,current employee?. Column A has 516 defined skill codes, and column B has the skill definitions. The various skills can be attributed to the employees. Once the matrix is completed I need to sort it and find groups of employees based on shift or dept, then sort the list to show only the cells that have C for completion in them. The skills codes are grouped 1.100 1.110 2.110 etc so a sort in that column will result in being able to see the group. that part I can do with Auto filter Custom, ends with 100 or as required but I am unable to sort across the spreadsheet.

First of all I think you need to re-organize your data. Where does the data come from. I think from what you described changing the format will allow you to use a Pivot Table achieve the results you require.

Also, if you can post an example of the data (If it's sensitive data post similar data) I can look at how we can do this.

the easiest way to do this is to goto an empty cell, hit '=' then highlight about 10 rows of data (not the entire row), hit F9 and copy paste what you have.

Regards

[Lee Attlesey]

Hi

I believe you can only filter the rows in a spreadsheet not columns and by the sounds of it Ian Mac is right is suggesting a pivot table. This would enable you to select/filter columns and rows.