Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables.

preview_player
Показать описание
Download Excel Files:

See how to use calculate Distinct Count with 1 Condition to create for How Many Unique Visitors To Site Each Day with Two PivotTables.

Distinct Count Formula with one condition. Unique Count Formula with one condition.
Excel Magic Trick 1318: How Many Unique Visitors To Work Site Each Day? PivotTable or Array Formula?
Bill Szysz posted:
Excel, Power Query - zliczanie unikanych wartości z warunkiem
Other Video also:
Excel Magic Trick 1320: Distinct/Unique Count with 1 Condition using Power Query (Get & Transform)
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:05:07

Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables.

Excel Magic Trick 0:06:13

Excel Magic Trick 1320: Distinct/Unique Count with 1 Condition using Power Query (Get & Transfor...

Excel Magic Trick 0:12:38

Excel Magic Trick 1318: Unique Visitors To Site Each Day? Data Model PivotTable or Array Formula?

UNIQUE vs DISTINCT 0:03:50

UNIQUE vs DISTINCT values in Excel

Excel: produce list 0:03:02

Excel: produce list of distinct values along with their count

Excel Magic Trick 0:04:16

Excel Magic Trick 1315: Create A Unique Sorted List with Power Query

Excel Magic Trick 0:05:46

Excel Magic Trick 1323: DAX Formula to Pass Many-Side Filter to One Side Aggregate Calculation

11.1. Distinct count 0:06:01

11.1. Distinct count | Excel pivot tables COURSE

Excel Magic Trick 0:08:03

Excel Magic Trick 1317: Formulas for Total Insulin Units… And Excel’s Golden Rule & MAX Replaces...

How to Count 0:00:52

How to Count Unique Items in Excel PivotTables

Excel Magic Trick 0:08:25

Excel Magic Trick 1312: Count The Number Of Mondays & Tuesdays Since Birth: NETWORKDAYS.INTL

Excel Tip: How 0:03:00

Excel Tip: How To Use Distinct or Unique Count In An Excel Pivot Table

#Exceltips #Distinct How 0:03:20

#Exceltips #Distinct How to find distinct values using distinct count option in pivot table | 2021

Excel Magic Trick 0:05:17

Excel Magic Trick 1109: Compare 2 Lists and Extract Records: Advanced Filter Method

Counting DISTINCT() Values 0:06:18

Counting DISTINCT() Values with DAX

Pivot Table Count 0:06:18

Pivot Table Count Unique Values Excel 2010

Show Distinct Count 0:04:49

Show Distinct Count in Excel Pivot Table with PowerPivot

Excel Magic Trick 0:19:34

Excel Magic Trick 1400 Part 2: Conditionally Format Row with Complex Criteria (3 More Examples)

Finding Unique Values 0:03:57

Finding Unique Values with a Pivot Table

Excel 2013 Video 0:06:45

Excel 2013 Video 19 Distinct Count in a Pivot Table

Excel Magic Trick 0:26:42

Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods)

How to add 0:03:27

How to add unique count to a pivot table

Two ways to 0:01:34

Two ways to do distinct count in pivot table (MS Excel)

How to get 0:04:52

How to get Distinct Count in Pivot Table Ms Excel 2013, 2016 and Excel 360

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

Thanks. BillSzysz is full of smart ideas!

pmsocho
Автор

Thanks Mike and Bill Szysz. You guys are the best! Hope Bill Jelen isn't reading this...he's very good also :-)

kjvstats
Автор

amazing again!!!! Always learning...Thanks a lot Mike

PedroCabraldaCamara
Автор

HI Mike,

Thanks a lot, again, for this new video. Each time I watch one of yours, I feel the rush to open Excel and try new things. :-) BTW, I'm glad you've updated your book, looking forward to get a copy of this third edition! Keep up the excellent work.

EricGiroux
Автор

Hi Mike! Interesting case as all solutions have pros and cons. Pivot on helper pivot is a super quick solution! I loved the 1 cell array solution from yesterday but I think it would be too complex for many excel users. I've got an idea...hopefully I'll have time to create a video tonight.

MySpreadsheetLab
Автор

Thanks to Bill and thanks also to mike for the translatio :-)

mohamedchakroun
Автор

Thanks for disseminating this trick :-)

BillSzysz
Автор

Hello Mike, your videos are awesome and I improved so much watching them. But I am with a problem I can't solve. Is there a way using hyperlink in a cell to return a result from a pivot table? Thank you, if you can help me I appreciate

hectorricardus
Автор

It would be better and more automated if you

1. name the helper pivot's range using Offset function = dynamic range
2. then you won't have to uncheck blank in final pivot. If there are more data/dates next time, the final pivot will still only show 3 dates you had last time. Other new dates are not "checked"

Ideally, you want to have people just add more data to the raw data=table, then click Refresh All TWICE.

konijay