I have one table with project data in it. What I would like to do is, have unique values based on multiple columns automatically populate into another table. I can do this manually by copying the 3 columns into the 2nd table and removing duplicates, however I'm looking to have it run automatically. I have a sample of how I would like it to be, but this was created manually.
Sometimes members forget to update their profile.
Do you have Excel Office 365 or even Excel 2019. If so there are new functions that could do this for you.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
You're correct, I did forget to update my profile. I have office 365. I was thinking of using the unique function however it causes a spill error when I try to use it in a table.
Nope, you can't use that in a real table
You can do it easily with power query or use a macro
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by JEC.; 02-03-2022 at 05:23 PM.
The power Query worked, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks