ranking - Excel: top 20 list but within date range (dynamic) -

ranking - Excel: top 20 list but within date range (dynamic) -

i have table of 700 items (no duplicates) taken big table info beingness added on every day. of these items in first mentioned table occur more 1 time in big table, have added count next sec table see how many times 1 item 'mentioned' in big file. alongside, made chart, displaying top 100 mentioned items.

however, want same list within date range. right fetching info results in number 1 item returning value of 14000 times beingness 'mentioned'. adding date range create more visible me see how many times item beingness 'mentioned' between specific dates.

the table 700 unique items called table4 , has columns node & count. formula find top hits:

=large(table4[count], d2)

(where d2 rank number '1', copied downwards row 100)

so conclude, know how many times item number 1 beingness 'mentioned' in big list, how find out how many times item number 1 beingness mentioned september 1st september 30th (or date range matter)?

thanks!

if using countif() formula today determine count in big table (table1) of each unique item in table4. switch countifs() formula instead:

supposing "node" in column of big table (table1) , "date" in column b of big table, alter countif('table1'!a:a,a1) to:

=countifs('table1'!a:a,a1,'table1'!b:b, ">=09/01/2014", 'table1'!b:b, "<=09/30/2014")

now have original criteria 'table1'!a:a=a1 , 2 new criteria test date range looking for.

excel-formula ranking date-range