Excel Magic Trick 1056: Excel 2013 Slicer Formulas

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

See how to add Slicers to Excel 2013 Tables and then:
1. Slicers for Total Row to calculate MIN value for two criteria
2. Slicers for SUBTOTAL function to calculate MIN value for two criteria
3. Slicers for AGGREGATE function to calculate MIN value for two criteria
4. SUMPRODUCT, SUBTOTAL and OFFSET Function to create formula to multiply filtered columns based on Slicer Criteria
  1. excelisfun
  2. Excel 2013
  3. Excel 2003
  4. Excel 2007
  5. Excel 2010
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:12:45

Excel Magic Trick 1056: Excel 2013 Slicer Formulas

Excel Magic Trick 0:12:45

Excel Magic Trick 1056 Excel 2013 Slicer Formulas (nowtelugu.com)

Excel Magic Trick 0:03:10

Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,'0000-00-00')

Excel Magic Trick 0:06:43

Excel Magic Trick 1057: Calculate Hours Worked From Text Time Values, Including Night Shift

Excel Magic Trick 0:06:20

Excel Magic Trick 1544: FILTER Array Function to Filter Between Upper & Lower Text Number Limits

Excel Magic Trick 0:09:19

Excel Magic Trick 1055: Grading: Calculate Current Percentage & Decimal Grade

Mr Excel & 0:06:23

Mr Excel & excelisfun Trick 145: YYYYMMDD Numbers To Dates: TTC, Flash Fill, DATE or TEXT Functi...

Excel Magic Trick 0:01:21

Excel Magic Trick 1050: Excel 2013 Sheet Navigation Arrows For Go To Last Or First Sheet Where?

Excel Magic Trick 0:01:32

Excel Magic Trick 1061: Copy Formulas Quickly With Name Box and Shift Key (Horizontal or Vertical)

Excel Magic Trick 0:08:46

Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Rang...

Excel Magic Trick 0:08:58

Excel Magic Trick 1040: Formula To Extract & Sort A Unique List Of Numbers, No Empty Cells Or Te...

Excel Magic Trick 0:02:48

Excel Magic Trick 1025: Remove Asterisk From All Text Items In Column: SUBSTITUTE & TRIM

Excel Magic Trick 0:07:23

Excel Magic Trick 1062: SUMIFS: Year Over Year Sales Calculations From Transactional Data Set

Excel Magic Trick 0:01:51

Excel Magic Trick 1049: Copy Page Setup From One Sheet To Another

Excel Magic Trick 0:02:27

Excel Magic Trick 1147: Incorrect Formula To Calculate Retirement Year

Excel Magic Trick 0:10:25

Excel Magic Trick 1153: Unique Count For Name & Date: Array Formula, 2013 PivotTable, More…

Excel Magic Trick 0:06:24

Excel Magic Trick 1293: Single Cell 'Lookup Adding' w Proper Data Set for Myers-Briggs Tes...

Excel Magic Trick 0:05:11

Excel Magic Trick 1059: Conditionally Format Top 5 Numbers That Are Also Greater Than 65

Excel Magic Trick 0:06:16

Excel Magic Trick 1033: Re-do Duel 134: Join Product and Sub-Product Text Using PivotTable

Excel Magic Trick 0:07:25

Excel Magic Trick 1021: Implicit Intersection or #VALUE Error: No Ctrl + Shift + Enter

Excel Magic Trick 0:02:15

Excel Magic Trick 1052: Best New Feature In Excel 2013: Recommended Charts & PivotTables

Excel Magic Trick 0:07:17

Excel Magic Trick 1053: Unique Count With Criteria: Excel 2013 PivotTable Distinct Count Function

Excel Magic Trick 0:03:20

Excel Magic Trick 1084: ISODD or ISEVEN Functions to Help Add Every Other Column

Excel Magic Trick 0:08:30

Excel Magic Trick 1044: Formula To Extract & Sort Unique List Of Numbers Contains Empty Cells &a...

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

Hi Mike: Thank you for another super clear and super useful Excel trick. I've been looking for this answer for a while and sure enough you had it. Duh, I should have started with you! Seriously, you're a great teacher, thanks for your commitment to helping us.

Jim-zmfw
Автор

Excel Magic Trick 1056: Excel 2013 Slicer Formulas.
Amazing Formulas that work with Slicers!!!!

excelisfun
Автор

I think the Slicer feature is one of the best features in Excel especially when used with pivot tables to sync the report filters.

MySpreadsheetLab
Автор

Aggregate function combined with slicers! Very useful combination. Thanks Mike. 

MySpreadsheetLab
Автор

Question: is there any way to set ranges in slicers? ie. sorta like "bins"

jeffreystockdale
Автор

Awesome! Thank you very much
Can we reverse the process? By reversing the process i mean i want to slice the pivot table using cell values?

nishantkumar
Автор

Hi... can you help with how to connect slicers from different pivot sources?

bharadhanenenu
Автор

Cell by 1. So say this months numbers is e1 so I would change it to e2. Notes each Amorts is different so the cells don't all match up

Kevlar_soul
Автор

Best For

One Query : - how to highlight particuler cell via drop downlist

" Condition :- 50 Document names in my list, highlight list via Country name & Party name, using Dropdown

indianmonster
Автор

I have a question. I have an excel file with multi tabs of amortization. On the cover I need the currents months numbers from each tab. So each month I have been manually increasing the cell by 1. Is there a way to increase cell numbers by 1 for multiple line item. I have around 75 tabs so it takes allot of time.

Kevlar_soul
Автор

So practically you are the one who’s invented, by using the OFFSET(#;{1, 2, 3, 4, ...}) tricks, the dynamic array 7 years before of Microsoft 🙂

Franceskineos