Generate unique IDs for your dataset for building summary reports - Excel & Google Sheets

Описание к видео Generate unique IDs for your dataset for building summary reports - Excel & Google Sheets

Learn 3 different methods for creating unique IDs in your dataset when no unique ID exists. You can apply these methods to Excel or Google Sheets. Having a unique ID in your table of data makes it easier to reference specific rows of data when you are building out your summary reports and dashboards.

* Intro - 0:00
* Method 1: Sequential list of numbers - 2:32
* Method 2: Create random numbers as ID - 5:17
* Method 3: Concatenate columns together - 10:45

👉 Copy the Google Sheet: https://docs.google.com/spreadsheets/...
👉 Original blog post for this podcast episode: https://www.thekeycuts.com/dear-analy...
👉 Subscribe to Dear Analyst: https://podcasts.apple.com/us/podcast...
👉 Excel for the Real World online class: https://skl.sh/2lsi6up

Комментарии

Информация по комментариям в разработке

Похожие видео