Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Sub CountCategories() Dim NumPivotCat As Long Worksheets("Sheet1").Range("C2").FormulaArray = "=SUM(IF(FREQUENCY(IF(LEN(A1:A11)>0,MATCH(A1:A11,A1:A11,0),""""), IF(LEN(A1:A11)>0,MATCH(A1:A11,A1:A11,0),""""))>0,1))+(COUNTIF(A1:A11,"""")>0)" End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|drag and drop (but keep all) lines||11||46|
|count values within multiple bands||7||34|
|how to read data from all excel sheet and copy it in in Master sheet||2||27|
|Create a list of Worksheets based on Cell Value||14||28|
Join the community of 500,000 technology professionals and ask your questions.