Excel Magic Trick 1197


OR Criteria: Don’t Double Count: DCOUNTA, COUNTIFS, or SUMPRODUCT?

DESCRIPTION

See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then for each county code, list zips codes horizontally.
(00:09) OR Criteria Double Count Problem when criteria are coming from Two Columns
(01:33) DCOUNT function formula
(03:35) COUNTIFS function formula (3 COUNTIFS in one formula)
(06:35) SUMPRODUCT function formula (Array Formula)
(10:28) Timing all 2 formulas

WORKBOOKS




Be the first to comment

Leave a Reply