LinkBack URL
About LinkBacks
Hi
Please help
I have a list of data and I just want to bring back the clients that belong to a specific person. What formula would I use.
Thanks so much in advance for any help you can give
Regards
Jane
Hi
Please help
I have a list of data and I just want to bring back the clients that belong to a specific person. What formula would I use.
Thanks so much in advance for any help you can give
Regards
Jane
I think we need a little more information: post a small sample file.
Click" Go Advanced" then "Manage Attachments"
Hi
Data file attached ( I think)
If I want to bring back all the clients in column A that belong to operator Jodi Gill in column B what formula will help with that
Regards
Jane
Try
For Operator Unique name Try
Assuming in column I
I2=IFERROR(INDEX($B$2:$B$23,MATCH(0,INDEX(COUNTIF($I$1:I1,$B$2:$B$23),),0)),"") With control+SHIFT+enter and drag down. It will retrieve Unique list of Operator
Formula:
Please Login or Register to view this content.
Try
J2=IFERROR(INDEX($A$2:$A$23,SMALL(IF($B$2:$B$23=I2,ROW($B$2:$B$23)-ROW(B1)),1)),"")&" , "&IFERROR(INDEX($A$2:$A$23,SMALL(IF($B$2:$B$23=I2,ROW($B$2:$B$23)-ROW(B1)),2)),"")&" , "&IFERROR(INDEX($A$2:$A$23,SMALL(IF($B$2:$B$23=I2,ROW($B$2:$B$23)-ROW(B1)),3)),"")&" , "&IFERROR(INDEX($A$2:$A$23,SMALL(IF($B$2:$B$23=I2,ROW($B$2:$B$23)-ROW(B1)),4)),""&" , "&IFERROR(INDEX($A$2:$A$23,SMALL(IF($B$2:$B$23=I2,ROW($B$2:$B$23)-ROW(B1)),5)),""))
and drag down
Formula:Please Login or Register to view this content.
Check the attachment.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
In Sheet2
Operator in A2 e.g. Jodi Gill
Clients in B2 down
in B2
=IFERROR(INDEX(Sheet1!$A$2:$A$30,SMALL(IF(Sheet1!$B$2:$B$30=$A$2,ROW($A$2:$A$30)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")
Enter with Ctrl+Shift+Enter
Copy down column B
Adjust range to suit
You could make A2 a drop-down list of all operators.
Post removed - others said it first
Example with drop_down
John
that's great but I have hit a snag when I change the data range as the rows on Sheet one go above 30 the data comes back blank
What am I doing wrong?
Jane
***ignore me I have solved thanks so ,much for your help
Last edited by Janey_1980; 01-18-2016 at 07:58 AM. Reason: solved query
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks