Display ONLY the leaders who attended a given weekly meeting

[Kamtimo]

Hello,

I am kindly requesting for your help (see attachment).

I am working on some attendance list, and I want to display only the leaders who attended the meeting each week.

Sheet 1 (called Attendance) has names of people who attended the meeting, there are two categories: visitors and leaders.
Sheet 2 (called Leaders_only) is where I want to display ONLY the leaders who attended a given weekly meeting. In simple terms I want someone's name to display on sheet 2 (Leaders_only) on condition that (YES) he or she is a leader according to sheet 1 (Attendance).


Kind Regards,

Kamtimo



Meetings.xlsx

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Cell value based on a value of another cell" could describe almost any formula. I have updated it for you this time because you are a new member. --6StringJazzer

[sandy666]

is that what you want?

9.JAN.2023	16.JAN.2023	23.JAN.2023
Meeting_01	Meeting_02	Meeting_03
First Name	First Name2	First Name5
Jerome	Mark	Daniel
Michelle	Michelle	Jesse
Joel	Jerome	Peter
Britah	Louis	Faith
Sharon	Denis	Michelle
Mercy	Mercy	Jerome
Jacob	Terry	Denis
Mercy	Liz	Mercy
Jeremy	Rita	Jane
Job	John	Jacob
Rachel	Patience	Joel
Harrison	John	Rita
Peter	Daniel	Peter
Louis	Halimah	Destiny
Terry	Donah	Comyn
	Debbie	Brian
	Mark

[Kamtimo]

Yes, exactly.
That is the table I want to generate on the second sheet.

[sandy666]

use Power Query

[Kamtimo]

I didn't know about that.
Thank you so much.

[sandy666]

so you'll need to read more about Power Query (Get&Transform)

[Kamtimo]

Yeah, thanks for the link you have shared, I am already learning more about power query. In case you have more resources to recommend I'll be glad.

[sandy666]

I never needed more than this link but google is your friend

[Kamtimo]

😁oh yeah. Great. True there's google too.

[sandy666]

anyway

---

if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful)
and then mark the thread as SOLVED (top above your first post - Thread Tools)

[Kamtimo]

All is done!

[sandy666]

Great, thanks
Have a nice day