Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power Query help to extract unique values

So in this case, I am working with a roster list that changes weekly. I have posted a screenshot that shows a small example of what i am dealing with. We're talking literally 1000's of agents that I ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

So maybe I'm doing this wrong. This is actually within Excel and using their Power Query. Maybe I shouldn't have posted this here, but since it is here, maybe you or someone else can still help.

 

I get this error when I try to follow your steps in Excel.

 

 

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    I wrote that you should change the name of the last step to unique

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I did not even see that first part where I need to add the step and rename the step. That did it. I apologize. It's late and I've been at this for hours. My eyes are tied and I'm exhausted from a long 12 hour shift.

       

      You just saved me a crapload of work. Thank you so much.

       

      I was using a IFERROR Index kind of formula for 1000's of agents and it severely slowed the excel sheet. The Power query is so much faster and easier. I was contemplating removing the formula to make it run smoother and and manually pick them out.

       

      I need to add this to another workbook also so I can pull out unique ID's to determine what ID's were completed and which ones were not when comparing to a sheet that contains the data of all potential completed ID's.

       

      Thanks again!