Excel Magic Trick 1159: Extract Unique List For Data Validation List with Power Query

preview_player
Показать описание


See how to use Power Query to Extract Unique List For Dynamic Data Validation Dropdown:
1. (00:08 minute mark) Problem Set, including showing how complicated Array Formula Solution is.
2. (01:16 minute mark) Power Query to Extract Column, Remove Duplicates and Remove Empty Cells. (requires Refresh)
3. (02:39 minute mark) Create Data Validation Dropdown List from a Power Query Table on the same sheet as the dropdown list. (requires Refresh, Keyboard = Ctrl + Alt + F5)
4. ( minute mark) Create Data Validation Dropdown List from a Power Query Table on a different sheet than the dropdown list. (requires Refresh, Keyboard = Ctrl + Alt + F5)

Related Video:
Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List

  1. excelisfun
  2. Highline College
  3. Mike Girvin
  4. excelisfun
  5. Michael Girvin
  6. Mike excelisfun Girvin
Рекомендации по теме
Excel Magic Trick 0:04:26

Excel Magic Trick 1159: Extract Unique List For Data Validation List with Power Query

Excel Magic Trick 0:07:33

Excel Magic Trick 1244: Transform GDP Data Set: Advanced Filter with Formula Criteria wins!

Excel Magic Trick 0:12:23

Excel Magic Trick 1353: Power Query: Extract Records w Merge Feature & Inner Join on Parameter T...

Excel Magic Trick 0:27:23

Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups

Excel Magic Trick 0:05:52

Excel Magic Trick 1441 Power Query to Extract Items In List 1 That Are NOT In List 2: Left Anti Join

Excel Magic Trick 0:03:06

Excel Magic Trick 1162: Cell Reference That Point To Empty Cells Evaluate To Zero, IF Function Trick

Excel Magic Trick 0:04:03

Excel Magic Trick 1252: Power Query To Create Unique List of Invoice Numbers with Balances

Excel Magic Trick 0:07:30

Excel Magic Trick 1152: Formula or Power Query: Cost Report When Product IDs Don’t Match

Excel Magic Trick 0:01:16

Excel Magic Trick 1161: F4 Key To Repeat Last Action

Excel Magic Trick 0:03:00

Excel Magic Trick 1168: Get Time Value From Date Time Value (2 Formula Examples)

Excel Magic Trick 0:01:43

Excel Magic Trick 1160: Jump To Next Change In Column: Go To Special, Column Difference

Excel Magic Trick 0:00:56

Excel Magic Trick 1167.5: Subtract Lowest Grade

Excel Magic Trick 0:06:55

Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transfo...

Extracting Unique Values 0:01:25

Extracting Unique Values in Excel

Excel Magic Trick 0:08:11

Excel Magic Trick 1478: Conditional Format Row When Event Code is a Duplicate AND Task = 'Spec...

Excel Magic Trick 0:14:42

Excel Magic Trick 1023 Extract Unique List of Names For Dynamic Data Validation Dropdown List

Excel Magic Trick 0:02:43

Excel Magic Trick 1167: Substitute Final Score If Greater Than Low Score: MAX, MIN & SUM Functio...

Excel Magic Trick 0:07:51

Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF?

Excel Magic Trick 0:06:11

Excel Magic Trick 1156: Count with Two Conditions / Criteria From Non-Proper Data Set (2 Methods)

Excel Magic Trick 0:24:51

Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query?

Excel Magic Trick 0:04:47

Excel Magic Trick 1165: Substitute Final Score If Greater Than Low Score: IF, MIN & SUM Function...

Excel Magic Trick 0:04:25

Excel Magic Trick 1158: Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013

Extract Unique Items 0:06:56

Extract Unique Items from List Using a Formula in Excel

Excel Magic Trick 0:06:04

Excel Magic Trick 1163: COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too.

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

Excel Magic Trick 1159: Extract Unique List For Dynamic Data Validation Dropdown Using Power Query
See how to use Power Query to Extract Unique List For Dynamic Data Validation Dropdown:
1. (00:08 minute mark) Problem Set, including showing how complicated Array Formula Solution is.
2. (01:16 minute mark) Power Query to Extract Column, Remove Duplicates and Remove Empty Cells. (requires Refresh)
3. (02:39 minute mark) Create Data Validation Dropdown List from a Power Query Table on the same sheet as the dropdown list. (requires Refresh, Keyboard = Ctrl + Alt + F5)
4. ( minute mark) Create Data Validation Dropdown List from a Power Query Table on a different sheet than the dropdown list. (requires Refresh, Keyboard = Ctrl + Alt + F5)

Related Video:
Excel Magic Trick 1023: Extract Unique List of Names For Dynamic Data Validation Dropdown List 

excelisfun
Автор

you are mr.excel perfect. thanks a ton. keep it up. indeed very useful videos.

atulsuri
Автор

You are awesome:-) I like the way you explain, you have a teaching talent! Thx, for your videos!

msoffice
Автор

Hi, thank you so much for all these awesome videos. Is there any way to combine different files from different folders yet add the file name in the column? I has been search the ways to do this in google and Microsoft site but was not able to find anything workable.

usliangl
Автор

thank you, it's extremly useful.

gerzallazreg
Автор

Can we do this for dates to remove duplicates because I need that one I tried other option but it won't work..

adnangori
Автор

PQ is amazing, is not? :-)
Thanks for great trick !!

BillSzysz
Автор

Love it but Ctrl + Alt + F5 does not refresh - right click refresh works.  Using Excel 2010

mysimonhughes