View Single Post
 
Old 10-04-2020, 08:07 AM
p45cal's Avatar
p45cal p45cal is online now Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

In the attached, in column B is a Power Query offering, just right-click somewhere in that table and choose Refresh.
This is a separate table from the original table in column A, so should you sort the table in column B, the results may no longer line up with the items in column A, even after a refresh.
So for the sake of data integrity, there's a second offering in columns E:F. This is a single table so you can sort it however you want safely. It takes its data from column A.
Attached Files
File Type: xlsx msofficeforums45746Sample1.xlsx (20.2 KB, 6 views)
Reply With Quote