Get List of Sorted Unique Codes Excluding Errors & Blanks in #Excel 365

  • 7 months ago
Get List of Sorted Unique Codes Excluding Errors & Blanks in #Excel 365

=SORT(UNIQUE(TOCOL(B6:D14,3)))

Recommended

0:30
I
Up next
How to Select Random Names from a List in Excel
Rahim Zulfiqar Ali
0:30
Dynamic Cross Tabulated Report in Excel
Rahim Zulfiqar Ali
0:31
Convert HHMMSS Time Format to Hours as Numbers Excel
Rahim Zulfiqar Ali
0:54
Calculating Total Working Hours in Microsoft Excel
Rahim Zulfiqar Ali
0:59
How to Add Quickly SubTotals Excel
Rahim Zulfiqar Ali
0:29
Extract Numbers only with Comma Delimiter from a cell in Excel 365
Rahim Zulfiqar Ali
5:32
08 - Worksheet and Workbook Protection - Microsoft Excel
Rahim Zulfiqar Ali
13:08
07 - Named Ranges in Microsoft Excel
Rahim Zulfiqar Ali
11:55
06 - Data Validation Tips and Tricks
Rahim Zulfiqar Ali
0:22
Compare List for Missing Names or Values Excel
Rahim Zulfiqar Ali
0:28
Currency Exchange Rate Tracker (USD) Excel 365 and Google Sheets
Rahim Zulfiqar Ali
3:39
Get the Countries Flags Image in Google Sheets
Rahim Zulfiqar Ali
0:54
Count or Sum Multiple Values in a Cell - Excel 365
Rahim Zulfiqar Ali
0:50
Extract First Middle and Last Names from a list of Names in Microsoft Excel 365
Rahim Zulfiqar Ali
0:29
Get stock price (latest close) Excel and Google Sheets
Rahim Zulfiqar Ali
8:27
05 - Data Filters and Sorting
Rahim Zulfiqar Ali
6:48
04 - Excel Tables
Rahim Zulfiqar Ali
0:56
Multi Color DataBars based on Conditions Excel
Rahim Zulfiqar Ali
0:57
First and Last Working Days of a Month in Microsoft Excel
Rahim Zulfiqar Ali
0:58
Candle Stick Chart in Excel 365 - STOCKHISTORY
Rahim Zulfiqar Ali
0:30
Extract the TOP Marks Attained - EXCEL 365
Rahim Zulfiqar Ali
0:29
Count Employees Age numbers by range and Salaries Excel 365
Rahim Zulfiqar Ali
4:15
03 - Formatting Paste Special - Excel
Rahim Zulfiqar Ali
11:43
2 - Relative and Absolute Cell References - Excel
Rahim Zulfiqar Ali
0:34
Tested: The Best Meal Delivery Services for Easy Planning
Food and Wine