Return multiple values from long list

I am trying to do the following:

Sheet 1 -

Column A Column B

Dave 44
Dave 19
Dave 27
Dave 16
Dwayne 100
Dwayne 86
Dwayne 32
Dwayne 12

Sheet 1 will have approximately 10 columns of different stats for a USER, and each USER will have approximately 25 rows (1 for each day of the month) Above will give you a rough idea of how this would pan out.

In a seperate sheet I want to pull out the stats for those USERs in an automated way, as you would with a VLOOKUP. But VLOOKUP can only return values for one entry and won't do the rest.

E.g. If I did a VLOOKUP for Dave and then pulled the formula down across multiple rows each row would return 44 (without changing the lookup array)

I need an automated way to pull out all values (1 in each cell) for each user for each row?

Can anybody help?

Hi oeldere ,

Attached is attempt so far.

Sheet 1 shows the raw data.
Sheet 2 shows an example of the Information I am trying to put together.

Note: I have changed all names to numbers and only left some example information.

The issue with the way I am doing it is that the VLOOKUP I am using would require you to know at which rows in the raw data each person sits at.

Hope this helps and someone can provide an automated formula.

Many Thanks

Originally Posted by oeldere

Why don't use the information on sheet 1 and work with a filter.

See the example.

Hi Oeldere,

Unfortunately this isn't an automated method, as it would require me to filter out each analyst (approx 30) and record each days stats.

I need an automated method that would pull all of this information into a seperate worksheet for manipulation