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

preview_player
Показать описание
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

  1. KeyCuts
  2. excel tips
  3. google sheets tips
  4. unique IDs
  5. rand formula
Рекомендации по теме
Generate unique IDs 0:18:43

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

How to Create 0:10:01

How to Create Unique IDs from Your Excel Data - Automate Unique IDs in Excel

Generate Unique ID 0:05:56

Generate Unique ID for your record | Basics of PowerApps | Power Platform for Beginners | Now()

Generate Unique IDs 0:09:57

Generate Unique IDs in Python (UUIDs)

How to Create 0:06:15

How to Create Unique ID for SharePoint List Records Using Power Automate - Automatic ID Generator

How to Generate 0:02:40

How to Generate Unique ID for the Model

Generating Unique IDs 0:15:04

Generating Unique IDs in Python

L15: Distributed System 0:12:51

L15: Distributed System Design Example (Unique ID)

How to Use 0:17:47

How to Use Your Influences to Make Unique Music | The Album

How to Generate 0:12:57

How to Generate Unique ID for Visitors in PHP

Design a Unique 0:05:51

Design a Unique Id Generator in a Distributed System - System Design Interview - Snowflake Algorithm

Create Unique ID 0:06:59

Create Unique ID Like Youtube Video URL ID

Google Form and 0:04:24

Google Form and Google Sheet Auto generate unique ID

How to Use 0:08:17

How to Use Excel IF Function to Generate ID Number | Dynamic Excel Serial and ID number: No VBA

A quick UUID 0:00:47

A quick UUID generator (universal unique identifier)

Generate A Unique 0:06:36

Generate A Unique ID In Power Apps

SQL | Simple 0:00:30

SQL | Simple unique Id generator

System Design Interview 0:06:47

System Design Interview Basics | Unique ID Generator

Create a Unique 0:00:44

Create a Unique ID in JavaScript #shorts #javascript #javascripttip

Generate Unique ID 0:02:32

Generate Unique ID for a class key

How to Generate 0:06:38

How to Generate Unique ID for Microsoft Lists Records Using Power Automate

Unique Id Generator 0:00:48

Unique Id Generator in JavaScript

JavaScript Generating Unique 0:11:21

JavaScript Generating Unique ID and Random Numbers

Excel tip to 0:00:38

Excel tip to make your own unique ID for lookups

Комментарии
Автор

For the concantenation ID you could literaly use the countif function at the end to solve all the issues. It would ensure you get different id's every time.

THAT-PRINTER-GUY
Автор

I have a table with hundreds of stock trades. I would like exel to auto generate a new unique ID for each trade as I add it to the table. I would like that ID to stick with the row that contains the trade even when I sort the table by various columns (such as date or name of stock etc.). I can get excel to auto generate a number using concate but that makes the numbers long and awkward. Is there a way to get excel to auto generate a Unique ID for each trade so that I can re-sort by ID and get them back in chronological order?

robh.
Автор

If you had a date/time column, you might turn the date/time into a number and concatenate that number to the end which should generate a unique number.

bumpersmith