Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #698 Aug 15, 2012 www.energyefficientbuild.com.
user gazah said: (http://productforums.google.com/forum/?zx=knoiadu3x64v#!searchin/docs/gazah/docs/co3cL7NzGlY/fl65gbfOPscJ%5B1-25%5D)
Filters Questions
Having a little bit of trouble with some stuff.
Okay i 3 sheets on in which is inputted (a database), a KEY sheet with different things that are used and i have create a new sheet.
All data that will be searched for will be entered horizontally.
This new sheet should filter through the database horizontally, it first gets an ID number that can be changed from the new sheet, it then finds the ID number in the database which are all located in the A column, i then want it to look horizontal for all then entries that there is and display them on another sheet.
However i need it to display four columns at a time in which then they will display underneath. Is there anyway of only displaying the data in a certain range?
----
Okay i got all the filter bits done however because the data is horizontal it display all the data horizontally.
Now all i need is after every 4 colmns to then put the data undernearth.
Example
ID Name1 Name2 Name3 Name4 Name1 Name2 Name3 Name4
101 1 2 3 4 5 6 7 8
Then on my display sheet i want it to do this:
Name1 Name2 Name3 Name4
1 2 3 4
5 6 7 8
---------------------------------------------------------------------------------------
following is a solution for 1 record as posted by the user and then a more generalized problem with many records in EXAMPLE TABLE
user gazah said: (http://productforums.google.com/forum/?zx=knoiadu3x64v#!searchin/docs/gazah/docs/co3cL7NzGlY/fl65gbfOPscJ%5B1-25%5D)
Filters Questions
Having a little bit of trouble with some stuff.
Okay i 3 sheets on in which is inputted (a database), a KEY sheet with different things that are used and i have create a new sheet.
All data that will be searched for will be entered horizontally.
This new sheet should filter through the database horizontally, it first gets an ID number that can be changed from the new sheet, it then finds the ID number in the database which are all located in the A column, i then want it to look horizontal for all then entries that there is and display them on another sheet.
However i need it to display four columns at a time in which then they will display underneath. Is there anyway of only displaying the data in a certain range?
----
Okay i got all the filter bits done however because the data is horizontal it display all the data horizontally.
Now all i need is after every 4 colmns to then put the data undernearth.
Example
ID Name1 Name2 Name3 Name4 Name1 Name2 Name3 Name4
101 1 2 3 4 5 6 7 8
Then on my display sheet i want it to do this:
Name1 Name2 Name3 Name4
1 2 3 4
5 6 7 8
---------------------------------------------------------------------------------------
following is a solution for 1 record as posted by the user and then a more generalized problem with many records in EXAMPLE TABLE
No comments:
Post a Comment