Comments associated to records

[Scott]

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.

 

[Ron Coderre]

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,
Data>Filter>Advanced 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]

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!