List Names & Records

alliswell

Board Regular
Joined
Mar 16, 2020
Messages
194
Office Version
  1. 2007
Platform
  1. Windows
  2. Mobile
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.
 

Attachments

  • Screenshot_20230526-185955.jpg
    Screenshot_20230526-185955.jpg
    175.7 KB · Views: 10
  • Screenshot_20230526-185955.jpg
    Screenshot_20230526-185955.jpg
    175.7 KB · Views: 9

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
is thia what you're after?

Book1
ABCDEFGHI
1
2Name1Product1110Name4Product4413
3Name2Product2211Name2Product2211
4Name3Product3312
5Name4Product4413
6Name5Product5514
7Name6Product6615
8Name7Product7716
9Name8Product8817
10Name9Product9918
11Name10Product101019
Sheet1
Cell Formulas
RangeFormula
G2:I3G2=INDEX(C$2:C$11,MATCH($F2,$B$2:$B$11,0))
Cells with Data Validation
CellAllowCriteria
F2:F3List=$B$2:$B$11
 
Upvote 0
is thia what you're after?

Book1
ABCDEFGHI
1
2Name1Product1110Name4Product4413
3Name2Product2211Name2Product2211
4Name3Product3312
5Name4Product4413
6Name5Product5514
7Name6Product6615
8Name7Product7716
9Name8Product8817
10Name9Product9918
11Name10Product101019
Sheet1
Cell Formulas
RangeFormula
G2:I3G2=INDEX(C$2:C$11,MATCH($F2,$B$2:$B$11,0))
Cells with Data Validation
CellAllowCriteria
F2:F3List=$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
 
Upvote 0
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.
 
Upvote 0
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?
 
Upvote 0
didn't recall that earlier post, could you point me to that?
Yes sure. Its this post.
 
Upvote 0

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top