Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the current dataset:
Month Fund Region Name Jan A E SH Jan B W FW Feb C S WR Feb C E SH Feb C E SH I have written the following formula to return the unique values in the name column: =SUM(IF(FREQUENCY(IF('Data Sheet'!$A$3:$A $79=(CONCATENATE(CHOOSE(MONTH(TODAY()),"Jan","Feb" ,"Mar","Apr","May","Jun","Jul","Aug","Sep","Oct"," Nov","Dec"),"-",YEAR(TODAY()))),IF('Data Sheet'!$D$3:$D$79="FUND",IF('Data Sheet'!$P$3:$P$79="Region",IF('Data Sheet'!$J$3:$J$79<"",MATCH("~"&'Data Sheet'!$J$3:$J$79,'Data Sheet'!$J $3:$J$79&"",0))))),ROW('Data Sheet'!$J$3:$J$79)-ROW('Data Sheet'!$J $3)+1),1)) I want to have a formula that will return me the duplicate "Names" per Month per Fund per Region. Basically its taking the formula above and instead of it using frequency for unique values it would use some function for duplicate values. Thanks for the help. Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding duplicate serial #s | Excel Discussion (Misc queries) | |||
Finding Duplicate Entries | Excel Discussion (Misc queries) | |||
finding duplicate rows | Excel Worksheet Functions | |||
Need help with finding duplicate entries | Excel Worksheet Functions | |||
Finding duplicate data | Excel Worksheet Functions |