Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display lines depnding on a cell critrera
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display lines depnding on a cell critrera
How do I display lines depnding on a cell critrera
Try Autofilter. DataFilterAutofilter Imp: Do not leave your message area blank. Ever. Always use it to re-explain & elaborate on your query. The subject line's just that, its not meant to be the entire posting. Do note that responders using the same MS webpage (as you) to read/respond will NOT be able to respond to any post with blank message area (it's a technical glitch). So inadvertently, you're shutting them out from helping you. -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000, Files:362, Subscribers:62 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display lines depnding on a cell critrera
HI Max
Sorry for the lack of infoamtion, this is the first time I am using this service. Let me explain... I have two options to select from and only one of the options can be selected, lets call it A1 and A2. If a person selects A1, I would like to view only lines 10 - 20, however if a person selects A2, I would like to view only lines 20 - 40. Greg "Max" wrote: How do I display lines depnding on a cell critrera Try Autofilter. DataFilterAutofilter Imp: Do not leave your message area blank. Ever. Always use it to re-explain & elaborate on your query. The subject line's just that, its not meant to be the entire posting. Do note that responders using the same MS webpage (as you) to read/respond will NOT be able to respond to any post with blank message area (it's a technical glitch). So inadvertently, you're shutting them out from helping you. -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000, Files:362, Subscribers:62 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I display lines depnding on a cell critrera
Autofilter can give you the functionality you seek
Assuming your table is in cols A to C, headers in row1, data from row2 down Use an adjacent helper col D Enter a label into D1, eg: Option Enter a marker in D2, eg: x Copy D2 down by 20 rows to D21 Enter the next marker in D22, say: z Copy D22 down by 20 rows to D41 Then just select col D, click DataFilterAutofilter to apply it. From the dropdown in D1, you would then be able to make the selection: x or z, which would filter out the required lines, giving you the functionality that you seek -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:62 xdemechanik --- "Greg S" wrote: I have two options to select from and only one of the options can be selected, lets call it A1 and A2. If a person selects A1, I would like to view only lines 10 - 20, however if a person selects A2, I would like to view only lines 20 - 40. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
Display more than 8 lines in an Excel dropdown box | Excel Discussion (Misc queries) | |||
How do I resize a cell in Excel to display two lines of data | Excel Discussion (Misc queries) | |||
display multiple lines of text within a merged cell automatically | Excel Worksheet Functions |