I have about 150 cells With this formula. It seems this makes Excel use a lot of processor Power to calculate. Is there anyway to make it simpler? I mean, is it possible to split it ut and use another spreadsheet to make a partial calculation. Would that help?
=SUM(IF(FREQUENCY(IF('Timer spørring ekstern'!$W:$W=B1,MATCH('Timer spørring ekstern'!$C:$C,'Timer spørring ekstern'!$C:$C,0)),ROW('Timer spørring ekstern'!$C:$C)-MIN(ROW('Timer spørring ekstern'!$C:$C))+1),1))
1 thing you could do to help speed things up is to remove the (entire) column ref ($W:$W) and replace with the actuyal range you need? You mention 150 cells, so I will assume you have 150 rows...
=SUM(IF(FREQUENCY(IF('Timer spørring ekstern'!$W$1:$W$200=B1,MATCH('Timer spørring ekstern'!$C$1:$C$200,'Timer spørring ekstern'!$C$1:$C$200,0)),ROW('Timer spørring ekstern'!$C$1:$$C200)-MIN(ROW('Timer spørring ekstern'!$C$1:$C$200))+1),1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks! that helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks