Business / Paper Business
Autor: joaomarques 27 July 2011
Words: 273 | Pages: 2
Objective: Counting the number of cells within a range that meet the given criteria.
Example: check if one item number is repeated in the worksheet.
Column B contains the item numbers
Label on the cell B1
Then formula is COUNTIF(B$2:B2,B2) if appears 1 it means that is the first time this item number appears
Example: item number 23 ---- 1 (1 means it’s the first time it appears)
Item number 23 ---- 2 (2 means the second time it appears)
On the coming cells will appears
(for example cell B4...