| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments associated to records
I need a function that will list comments associated with records if they
exist! Records: DataA(1-n) DataB(1-n) DataC(1-n) Comment (some of 1-n) I want to list the comments that exist like so. Comment(n) DataA(n) DataB(n) Kind of a stumper for me. -- Scott Miller University of Washington Chemistry |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comments associated to records
Try this:
Assuming your data is in columns A,B,C A1: Data_A A2:A100 data items B1: Data_B B2:B100 data items C1: Comments C2:C100 (Sporadic comments) E1: Comments F1: Data_A G1: Data_B I1: Comments I2: * Next, DataFilterAdvanced Filter Select: Copy to another location List Range: A1:C100 Criteria range: I1:I2 Copy to: E1:G1 Click OK That should list only items with comments under cells E1:G1 Does that help? *********** Regards, Ron "Scott" wrote: I need a function that will list comments associated with records if they exist! Records: DataA(1-n) DataB(1-n) DataC(1-n) Comment (some of 1-n) I want to list the comments that exist like so. Comment(n) DataA(n) DataB(n) Kind of a stumper for me. -- Scott Miller University of Washington Chemistry |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Comments associated to records
I ended up just sorting the rows by the comment column, then I copied the
rows I needed and re-sorted the data. I thank you for your suggestions! -- Scott Miller University of Washington Chemistry "Ron Coderre" wrote: Try this: Assuming your data is in columns A,B,C A1: Data_A A2:A100 data items B1: Data_B B2:B100 data items C1: Comments C2:C100 (Sporadic comments) E1: Comments F1: Data_A G1: Data_B I1: Comments I2: * Next, DataFilterAdvanced Filter Select: Copy to another location List Range: A1:C100 Criteria range: I1:I2 Copy to: E1:G1 Click OK That should list only items with comments under cells E1:G1 Does that help? *********** Regards, Ron "Scott" wrote: I need a function that will list comments associated with records if they exist! Records: DataA(1-n) DataB(1-n) DataC(1-n) Comment (some of 1-n) I want to list the comments that exist like so. Comment(n) DataA(n) DataB(n) Kind of a stumper for me. -- Scott Miller University of Washington Chemistry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top 90% of records - Bring out number | Excel Discussion (Misc queries) | |||
| display set of records in a form with previous and next button | New Users to Excel | |||
| Deleting specific records | Excel Discussion (Misc queries) | |||
| Deleting specific records from a column | Excel Discussion (Misc queries) | |||
| Can I reference comments by Cell Name? | Excel Discussion (Misc queries) | |||
Linear Mode
