Sheet Calculation slow

  • Thread starter Thread starter nika
  • Start date Start date
N

nika

Hello all

I have the below array formula on my worksheet in about a dozen cells
and it makes the calculations slow. I turned off the auto calc to
manual (F9) and I can cope with that but would rather have auto
has anyone got any ideas to speed up the calc or can this formula be
watered down at all


=COUNT(1/FREQUENCY(IF(($F$2:$F$243=AA$1)*($F$2:$F$243<>""),MATCH($D$2:$D$243,$D$2:$D$243,0)),ROW(INDIRECT("1:"&COUNTA($F$2:$F$234)))))


Thanks
 
Hi
no this kind of formula (counting conditional unique entries) is rather
slow. So if you really need an autmatic calculation of this information
probably not much you can do against the performance issue
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Multi-Worksheet Sumproduct & Listing 3
Sheet Calculation slow 1
Array formulas slows spreadsheet 6
How to Use two search criteria in one array. 2
Match a group of cells with another group of cells 1
Finding dynamic maxima 8
How to find best and worst grade? 5

Back
Top