# Help on Fequency function

1. ## Help on Fequency function

Whelp, looks like I'm stuck again.

Thanks to all who helped get the counts earlier. Much appreciated.

But like all reports once you get a proof of concept done, everything changes.

Now they are wanting to calculate both the number of unique documents that were actual within a given month as well as the number of details. The export I'm using gives both in one file. The earlier solution worked fantastic for the number of details...but I'm struggling with the number of unique docs.

 Doc Number Schedule Actual Projected DOC-03 DOC-03 DOC-01 16-May-13 16-May-13 DOC-01 16-May-13 16-May-13 DOC-01 16-May-13 16-May-13 DOC-01 16-May-13 16-May-13 DOC-06 DOC-06 DOC-05 16-May-13 16-Jun-13 DOC-05 16-May-13 16-Jun-13 DOC-02 16-May-13 16-May-13 DOC-02 16-May-13 16-May-13 DOC-06 DOC-06

There's more detail to each row to make them all unique...and that may come into play later..but for right now, this is all the columns I'm currently looking at.

Any ideas on how to count the number of unique docs? I've attached a sample spreadsheet using the above data.

gvldavis_sample.xlsxgvldavis_sample.xlsx

2. ## Re: Help on Fequency function

Is this what you're looking for?
In cell G3 put this array formula* in
=SUM(IF(FREQUENCY(IF(MONTH(\$C\$2:\$C\$1500)=5,IF(\$A\$2:\$A\$1500<>"",MATCH(\$A\$2:\$A\$1500,\$A\$2:\$A\$1500,0))),ROW(\$A\$2:\$A\$1500)-ROW(\$AS\$2)+1),1))

This array formula is checking for unique 'Doc Number' and 'Actual' combinations for the month of May.

*Array formulas must be entered using ctrl+shift+enter, otherwise it will NOT work.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1