I followed the procedure in the video and it work the first time. Now using different data, I get errors trying to complete the relationship. The error says both selected columns contain duplicate values. The calendar does not contain duplicate values. I've tried different data and different calendars with zero luck. First timer here.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Episode 2452 youtube relationship errors
- Thread starter scaron
- Start date
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,751
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
It is probably best to post your question right to the thread that has that episode. That way, Bill should be sure to see it.
www.mrexcel.com
It is probably best to post your question right to the thread that has that episode. That way, Bill should be sure to see it.
Excel Pivot Table Fiscal Year Date Rollups - 2452
Check out my Excel Guides on Retrieve: https://mrexcel.retrieve.com/store/#/ A question from the Las Vegas IMA: How do you do date rollups in Excel when the company is on a fiscal year that does not end on December 31? This video shows how to use Power Query to link to a Calendar table. The...
