Please help.
I have attached a sample spreadsheet with sample data and I want to extract row and column heading based on the content of a cell. The spreadsheet will grow based on a 10 month period.
It this possible?
TIA
Output table row and column header base on the specific cell content
-
jolas
- 3StarLounger
- Posts: 204
- Joined: 02 Feb 2010, 23:58
Output table row and column header base on the specific cell content
You do not have the required permissions to view the files attached to this post.
-
HansV
- Administrator
- Posts: 78487
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Output table row and column header base on the specific cell content
See the attached version. I inserted a helper column to determine which rows contain ExA.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
jolas
- 3StarLounger
- Posts: 204
- Joined: 02 Feb 2010, 23:58
Re: Output table row and column header base on the specific cell content
This is a very creative solution. Thank you very much.