YTLE#56: Excel Count Unique Values Greater Than $30

  • Length: 10:51
  • Rating Average: 5.00 from 4 people
  • View Count: 81
  • Author: ExcelIsFun

Tags: Array  College  Community  COUNTIF  Excel  Formula  function  Gel  Girvin  greater  Highline  Mike  SUMPRODUCT  than  Unique  Values 

See SUMPRODUCT and COUNTIF together in one amazing Array Formula from Aladin at the Mr Excel (mrexcel) Message Board. See the amazing logic of the count unique records formula that uses division and the fact that 1/3 + 1/3 + 1/3 = 1. See how to use an Array Formula and the COUNTIF function to...

Excel Magic Trick #180: COUNTIF function formula 21 Examples

  • Length: 9:42
  • Rating Average: 4.86 from 7 people
  • View Count: 240' favoriteCount='2
  • Author: ExcelIsFun

Tags: College  Community  conditions  COUNT  COUNTA  COUNTBLANKS  COUNTIF  criteria  Excel  functions  Gel  Girvin  Highline  Mike 

See methods for counting: specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values than are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, not words, and more!Learn about the syntax that the COUNTIF...

Excel Magic Trick #184: Database in Excel

  • Length: 7:50
  • Rating Average: 4.80 from 5 people
  • View Count: 235' favoriteCount='4
  • Author: ExcelIsFun

Tags: 2003  2007  College  Community  database  Excel  field  Gel  Girvin  Highline  in  List  Mike  names  records  rows  Table 

See how to create a simple database in Excel using the List or Table feature.A simple database can be created in Excel using the Excel 2003 "List" feature or the Excel 2007 "Table" feature.Fields names must be in first row (no blanks).Records are in rows (no blanks).Other data in the sheet cannot...

Excel Magic Trick #183: Income Statement by Year & Month

  • Length: 7:35
  • Rating Average: 5.00 from 5 people
  • View Count: 157
  • Author: ExcelIsFun

Tags: array  Col  Community  Excel  formula  functions  Gel  Girvin  Highline  IF  Income  LEFT  Mike  Month  Statement  SUMPRODUCT  TEXT  Year 

See how to sum revenue from a table of data by year and month using the SUMPRODUCT & TEXT & SUM & IF & LEFT functions in an array formula.SUM items based on Two Conditions. SUM items based on two criteria. SUM items based on multiple conditions criteria.Also see these...

Excel Magic Trick #181: Count Words Case Sensitive

  • Length: 2:30
  • Rating Average: 4.80 from 5 people
  • View Count: 100' favoriteCount='1
  • Author: ExcelIsFun

Tags: an  array  Case  College  Community  Count  EXACT  Excel  formula  functions  Gel  Girvin  Highline  in  Mike  Sensitive  SUM  Words 

See how to Count Words Case Sensitive using the SUM and EXACT functions in an array formula.

Excel Magic Trick #179: Are All Four Word The Same?

  • Length: 4:50
  • Rating Average: 4.83 from 6 people
  • View Count: 105' favoriteCount='1
  • Author: ExcelIsFun

Tags: AND  case  Colleg  Community  EXACT  exactly  Excel  formula  functions  Gel  Girvin  Highline  IF  Mike  same  sensitive  text  words 

Determine whether four words in four cells are exactly the same (case sensitive). Use the IF, AND and EXACT functions in 2 different formulas:A long IF formulaA short array formula.Check to see whether More than 2 two words are exactly the same (case sensitive).Compare Four 4 text strings to...

Excel Magic Trick #178: Best Value Per 1 Unit Of Stats Value

  • Length: 1:23
  • Rating Average: 4.50 from 4 people
  • View Count: 68
  • Author: ExcelIsFun

Tags: (Statistics)  categories  College  Community  Compare  Divide  Division  Excel  Gel  Girvin  Highline  Mike  Of  two  Values 

Excel Magic Trick #178: Best Value Per 1 Unit Of Stats Value.See how to calculate the best value from two categories of values. Find the Best Dollar Value Assigned for Every One Unit Of Statistical Value./ is the division symbol in Excel. How to divide in Excel.Fantasy League Football Baseball...

Excel Magic Trick #177: Data Validation Trouble

  • Length: 4:3
  • Rating Average: 4.75 from 4 people
  • View Count: 65
  • Author: ExcelIsFun

Tags: cannot  College  Community  Data  Excel  Format  Gel  Girvin  Highline  in  list  Mike  Number  Text  Trouble  type  Validation  value 

See how to format a column with the Text Number Format to avoid Data Validation Trouble.Excel interprets 10-8895 as the date Oct, 8895Excel interprets 0856 (if there is no custom format to allow leading zeroes) as 865So if you have data validation based on those values, you can only use the drop...

Isaac Plays w Loader & Blocks and Hurts Hand (All Better!)

  • Length: 1:31
  • Rating Average: 5.00 from 2 people
  • View Count: 61
  • Author: ExcelIsFun

Tags: All  and  Better!  Blocks  dumps  Gel  Girvin  Hand  Hurts  Isaac  Kid  Loader  loads  Mike  Plays 

Isaac Girvin plays with his Toy Loader and Blocks. He loads the loader with blocks and then dumps the blocks. Isaac hurts his finger and then it is made all better!Toy Tonka TrucksKid Plays w Loader & Blocks and Hurts Hand. Kid loads and dumps blocks.

Kid Uses Toy Drill To Fix Toy Car

  • Length: 0:49
  • Rating Average: 5.00 from 2 people
  • View Count: 64
  • Author: ExcelIsFun

Tags: car  drill  Excel  Excelisfun  fix  Fun  Gel  Girv  Girvin  his  Is  Isaac  Kid  Mike  to  toy  uses 

Isaac Girvin uses a toy drill to fix his toy car.Tonka Toys

Page: 1 of 56

Next Page