Excel Magic Trick 1172

Multiple Dot Plots With Single Formula, INDEX, COUNTIFS & REPT

DESCRIPTION

See how to:
(00:38) INDEX and MATCH functions to lookup a column
(00:50) Highlight non-contiguous ranges using Ctrl
(03:13) Enter Formula into non-contiguous ranges using Ctrl + Enter
(04:04) COUNTIFS to count with criteria
(05:00) REPT function to repeat dots for Dot Plot
(05:23) Cell Formatting For Cell Chart




Be the first to comment

Leave a Reply