Main Profile

At A Glance

YouTubersLoveExcel#28: Complex & Amazing Excel Trick

See how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random Employee and determine if they have meet the given criteria and they apply Conditional Formatting. 1) See how to select a random employee from a huge list of employees using the INDEX, RANDBEWTEEN and COUNTA functions 2) See how determine if a randomly selected employee meets given criteria with the IF, AND and VLOOKUP functions. 3) See how to add Conditional formatting with a TRUE/FALSE formula 4) See how to use the VLOOKUP function in a TRUE/FALSE formula with a comparative operator. You will not believe the complexity and amazing result of this Excel Trick! Formula.
Length: 09:45

Contact

Questions about YouTubersLoveExcel#28: Complex & Amazing Excel Trick

Want more info about YouTubersLoveExcel#28: Complex & Amazing Excel Trick? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question