List Names & Records

[alliswell]

I put name in F1 that i need to get listed from column B.
I am using this formula in G column and it lists the name only.
=IF(ROW(B1<=COUNTIF(B:B,$F$1),$F$1,"")

The date and other records are not coming with the name. Tried to add COLUMN formula to the above formula but giving error. Please help.

 

[AlanY]

is thia what you're after?

Book1
	A	B	C	D	E	F	G	H	I
1
2		Name1	Product1	1	10	Name4	Product4	4	13
3		Name2	Product2	2	11	Name2	Product2	2	11
4		Name3	Product3	3	12
5		Name4	Product4	4	13
6		Name5	Product5	5	14
7		Name6	Product6	6	15
8		Name7	Product7	7	16
9		Name8	Product8	8	17
10		Name9	Product9	9	18
11		Name10	Product10	10	19
Sheet1

Cell Formulas
Range	Formula
G2:I3	G2	=INDEX(C$2:C$11,MATCH($F2,$B$2:$B$11,0))

Cells with Data Validation
Cell	Allow	Criteria
F2:F3	List	=$B$2:$B$11

 

[alliswell]

is thia what you're after?

Book1
	A	B	C	D	E	F	G	H	I
1
2		Name1	Product1	1	10	Name4	Product4	4	13
3		Name2	Product2	2	11	Name2	Product2	2	11
4		Name3	Product3	3	12
5		Name4	Product4	4	13
6		Name5	Product5	5	14
7		Name6	Product6	6	15
8		Name7	Product7	7	16
9		Name8	Product8	8	17
10		Name9	Product9	9	18
11		Name10	Product10	10	19
Sheet1

Cell Formulas
Range	Formula
G2:I3	G2	=INDEX(C$2:C$11,MATCH($F2,$B$2:$B$11,0))

Cells with Data Validation
Cell	Allow	Criteria
F2:F3	List	=$B$2:$B$11

No. Mr Alan
Earlier you gave me this formula and i put it in G1 and dragged down
=IF(ROW(B1<=COUNTIF(B:B,$F$1),$F$1,"")
Its working well for name records. When i enter "sameer dalvi" in F1, then i get all records of "sameer dalvi" in G column but now i want is, i need all records of "sameer dalvi" including "Date", "Quantity", "Product", "Total".

Hope i make you understand properly.
Thanks and regards

 

[smozgur]

Please do not mark a post as a solution that doesn't contain an answer. You can mark the solution post either when you received a working solution or you post a solution yourself. Otherwise, other members will think that this question has been already answered.

Therefore, I removed the solution mark.

 

[AlanY]

No. Mr Alan
Earlier you gave me this formula and i put it in G1 and dragged down
=IF(ROW(B1<=COUNTIF(B:B,$F$1),$F$1,"")
Its working well for name records. When i enter "sameer dalvi" in F1, then i get all records of "sameer dalvi" in G column but now i want is, i need all records of "sameer dalvi" including "Date", "Quantity", "Product", "Total".

Hope i make you understand properly.
Thanks and regards

didn't recall that earlier post, could you point me to that?

 

[alliswell]

didn't recall that earlier post, could you point me to that?

Yes sure. Its this post.

List of names

In excel 2007 I have a database and in column A i have names database. I want to list the name of sam in column G to know how much times he had purchased goods Thanks

www.mrexcel.com