![]() |
|
#1
|
||||
|
||||
![]()
Thank you p45cal. My first PQ solution involved 2 queries, yours is just 1. I will open and see on Monday how you did it.
Please help me understand the step by step process so I could apply it to the actual data. Where did the Table (CurrentYearRegistration) that was merged to the Source come from? 3 pm: I was able to follow through the steps until the fnLastReg. The error message says that the PQ is of lower version. Google says I must update my Excel to later version than 2013 but travel restriction is still in effect in this part of the planet. ![]() Last edited by Marcia; 09-26-2020 at 12:05 AM. |
#2
|
||||
|
||||
![]()
Often when you get the warning that you have an earlier version of Power Query than what the workbook was developed in you can just dismiss the warning and carry on. However, I attached a diagnostic version of fnLastReg which I'd like you to go in as if to edit it and select the steps one by one until it complains, then tell me which step it complained at and what the error message says. I might be able to write a work-around.
Link to picture: Image at Box ps. The CurrentYearRegistration is just your table filtered for the current year and all but the Registration number columns removed. |
#3
|
||||
|
||||
![]()
Thanks p45cal. I just finished going through all the steps and ended up with the same result. I felt so overwhelmed. I will try them in the actual data and see how they behave.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Highlight Duplicate Values Across Multiple Sheets | Bo_Knows_04 | Excel | 1 | 07-11-2020 11:41 PM |
VBA to highlight specific values in the spreadsheet | daiwuliz | Excel | 6 | 05-23-2018 10:30 AM |
Getting pop-up saying that my copy of Office is not registered. | dzuk | Office | 0 | 05-28-2015 05:09 PM |
find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |
Interface not registered | dezwakke2 | Outlook | 0 | 12-03-2006 12:27 AM |