

how can one validate a student id against a list of 'accreditated StudentID' in excel using powerquery.

Femco Onuch
Member
Members

Forum Posts: 28
Member Since:
May 6, 2022
May 6, 2022

i want a suituation when a studentId as contained in sheet 1 does not match in the accredited sheet called accreditation, please remove the row of record containing that student, in sheet1, since the student was not accreditated prior to taking the the courses.
How do i achieve this.
Thank you, i will love to see the solutions to this puzzle.
See the attached file:
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Susan VanRiper, Sue Hammond, Lee Mapes, Lorna Henning, Tracy English, Joaquim Amorim, Shoua Lee
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
David von Kleek
Ronald White
Ginette Guevremont
Taryn Ambrosi
Mark Davenport
Christy Nichols
Harald Endres
Ashley Hughes
Herbie Key
Trevor Pindling
Forum Stats:
Groups: 3
Forums: 24
Topics: 6528
Posts: 28594
Member Stats:
Guest Posters: 49
Members: 32817
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
