| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
create table of selected rows
Hi there. I have a sheet 'patients' with 'A' Row being an ID taking the form
S002, S003 etc. I have another sheet 'selected' with a selected list of IDs in the same form. I'd like to cretae another sheet where only the 'selected' list appears (i.e. aseletced sheet of rows from 'patients' using the ID from 'selected' as the criteria many thanks for any tips. cheeers Theo |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
create table of selected rows
forgot to note that the 'patient' sheet has multiple rows with the same ID. I
wpould want all rows with the ID to be on the new sheet "TBA" wrote: Hi there. I have a sheet 'patients' with 'A' Row being an ID taking the form S002, S003 etc. I have another sheet 'selected' with a selected list of IDs in the same form. I'd like to cretae another sheet where only the 'selected' list appears (i.e. aseletced sheet of rows from 'patients' using the ID from 'selected' as the criteria many thanks for any tips. cheeers Theo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link data in rows to columns to create table | Excel Discussion (Misc queries) | |||
| Create interactive pivot table chart based on item selected | Charts and Charting in Excel | |||
| How to create a Pivot table from text file with more than 65000 rows? | Excel Discussion (Misc queries) | |||
| Create a report with selected rows based on the content in a cell | New Users to Excel | |||
| Finding min,max in an array using selected rows from a table | Excel Worksheet Functions | |||
Linear Mode
