Creating Lists of names based on a value in a column

[Helluvaname]

I'm sure this is easy to those that know, but would appreciate a "simple" way to achieve this please.
I have a list of members of a charity, and each member has volunteered to work on one or more days.
The data looks like this:

Picture1.png

I'd like to have the daily tabs of the workbook display the information like this:

Picture2.png

A final tab with "unallocated" members, ie those with nothing in the Day(s) column, would also be useful.

The simplest way to achieve this would be appreciated, bearing in mind the Members list data will be added to, or amended, by non-technical people.
Many thanks, Ian

[Glenn Kennedy]

A picture is worth 1000 words, a sample sheet is worth 1000 pictures!!

You have attached a non-editable picture of an Excel sheet. That's not very easy to work with. Also... I'm lazy. I have to re-type your information before I can begin to address your problem. That puts me off completely.

So.... Do yourself a favour and please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough). However, please give us an indication of the approximate number of rows of data you want the solution to work with (100, 1000, 100,000 or whatever).

Unfortunately the attachment icon doesn't work at the moment. So,... instead click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Make sure confidential information is removed first!!!!

[Helluvaname]

Thanks Glenn, I couldn't see how to attach the file, so hope this works.

I think around 100 rows of data will be plenty.

[Helluvaname]

I thought this would be a piece of cake for you guys
Can anyone help please?

[Pepe Le Mokko]

Administrative Note:

Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[Glenn Kennedy]

In B16:
=IFERROR(INDEX(Members!G:G,AGGREGATE(15,6,ROW(Members!A4:$A$13)/((Members!$F$4:$F$13=Monday!$A$18)*(ISNUMBER(SEARCH(Monday!$A$16,Members!$E$4:$E$13)))),1)),"")

In B18:
=IFERROR(INDEX(Members!A:A,AGGREGATE(15,6,ROW(Members!$A$4:$A$13)/((Members!$F$4:$F$13=Monday!$A$18)*(ISNUMBER(SEARCH(Monday!$A$16,Members!$E$4:$E$13)))),1)),"")

In B19, copied down:
=IFERROR(INDEX(Members!A:A,AGGREGATE(15,6,ROW(Members!$A$4:$A$13)/((Members!$F$4:$F$13="")*(ISNUMBER(SEARCH(Monday!$A$16,Members!$E$4:$E$13)))),ROWS($B$19:B19))),"")

Done for monday's sheet.

[Helluvaname]

That's great!
Many thanks Glenn
Have a good weekend.

[Glenn Kennedy]

You're welcome. Same to you. It's beer o'clock now. G'nite.

[alansidman]

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

crossposted: https://www.mrexcel.com/board/thread...olumn.1148486/

[Helluvaname]

Thanks, I wasn't aware of the rule, and was trying to help out a charity in a hurry, hence posting elsewhere.

Replies much appreciated on both forums, and will know for the future!