Copying multiple Rows of Data based on a customer name

1. Copying multiple Rows of Data based on a customer name

Good Afternoon,

I am creating a customer knowledge and communication database and creating a front page that the staff will use to select the customer.

Then all the information on this customer will be pulled through from sheets behind. I have done most of the formulas as either Index, Match or Vlookup as most only have 1 set of data.

I now need to get it to pull all issues from one sheet and all complaints from another. The issue i have is there could be multiple entries for each customer over the years and I need it to pull each one through.

Has anybody got an idea how i could do this. My excel skills are very basic.

Thank you in advance for your support.

Kind Regards
Lewis W

2. Re: Copying multiple Rows of Data based on a customer name

Can you please post a sample file (nor image) showing expected results.

To upload a file, click "Go advanced" (next to "Reply" button) then scroll down "Manage Attachments". Click on this, browse, select a file, Upload and Close window.

It likely to be combination of INDEX/MATCH/SMALL to retrieve all data for a particular customer

As an example

=IFERROR(Index(\$B\$2:\$B\$100,small(IF(\$A\$2:\$A\$100=\$X\$2,row(\$a\$2:\$a\$100)-row(\$a\$2)+1,""),rows(\$a\$2:a2))),"")

Column B is data to retrieved

Column A contains Customer Numbers

X2 contains Customer number we are interested in

The above formula has to be entered with CTRL+SHIFT+ENTER (Hold down CTRL and SHIFT keys) then ENTER

Drag formula down column until (at least) you get a blank line

3. Re: Copying multiple Rows of Data based on a customer name

Good Afternoon John,

Thank you for your response. I have attached the file.

If you have any further questions please let me know.

Lewis

4. Re: Copying multiple Rows of Data based on a customer name

The general form of the array entered formula* used in this solution is:
Formula:
`Please Login or Register  to view this content.`
Note: to use an array entered formula Merge and Center was changed to Alignment > Across the Selection.
* Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let me know if you have any questions.

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1