Mr. Excel SSN Challenge: Import last 4 of SSN | Process vs. Formula | Dynamic Arrays & Power Query
Автор: Excel On Fire (Oz du Soleil)
Загружено: 2023-09-19
Просмотров: 2274
Bill Jelen, Mr. Excel, recently posted a video requesting input on ways to retrieve specific data while hiding sensitive data.
The challenge: how can you use a person's last initial and the last-4 of their social security number to retrieve relevant details. HOWEVER! The full social security number should be available but not easily revealed.
In this video I use HSTACK, Power Query, Dynamic Arrays, LEFT and RIGHT to achieve this. But, rather than use formulas, I use simpler Excel features and focus on a process that imports the relevant data into the workbook where the lookups will be performed.
Using 2 workbooks, adds some friction to help separate the fully sensitive data and the daily use data.
#ExcelChallenge #ImportData #PowerQueryTutorial
For a list of my Excel courses at Lynda/LinkedIn:
/ oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.
Website: http://ozdusoleil.com
My book: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guer...
My old blog: http://datascopic.net/blog-2-2
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
