Autofilter or Pivot

[johnmck]

This is probably a really question but I have to ask anyway....

Normally on Excel you would have your headers along row 1 and then you could create an auto filter or pivot however for ease of viewing I would like to put my headers in Column 1 however this then causes me problems as I dont know how to filter the data out this way (if it's even possible).

Example:

Normal Spreadsheet: A1 = Name | B1=Age | C1=Email
My Spreadsheet: A1 = Name | A2 = Age | A3 = Email

Does anyone know how to sort this?

 

[johnmck]

Sorry to bump this up but I really cant find the answer to this anywhere

 

[samitnair]

If i get u right u want to sort horizontally and what what is the criteria for the sort


Data---sort---options----left to right--ok

Add levels for advanced
thanks
sam

 

[johnmck]

No, sorry what I was after is the ability to Autofilter or Pivot...

Example:

Normal Spreadsheet: A1 = Name | B1=Age | C1=Email
My Spreadsheet: A1 = Name | A2 = Age | A3 = Email

I would like to see everyone who is (x) age and hide all the others.

 

[GlennUK]

You can't do that with native Excel, but someone has written code to do that, although it may not have the flexibility that Autofilter does:

http://blog.livedoor.jp/andrewe/archives/50283818.html

 

[johnmck]

[SOLVED] Autofilter or Pivot

You can't do that with native Excel, but someone has written code to do that, although it may not have the flexibility that Autofilter does:

http://blog.livedoor.jp/andrewe/archives/50283818.html

Absolutely BRILLIANT!!!

It worked a treat, now to see if I can make it compatible with Open Office and Lotus Symphony.

Thanks so much Glenn