Forum Discussion
Spreadsheet limits
Hi people I have trouble getting a complex formula to work properly. I'm trying to extract unique values from a large list of city names. The list is R986:C1 long and has empty cells in between. ...
Hi Morten,
Formula looks correct, it extracts unique names from column D of Kupong_Reg. Another story most probably it takes minutes to recalculate it. What exactly doesn't work in your case?
- Hi Sergei!
Thanks for replying :)
Well, the spreadsheet simply doesn't do any calculations on this formula. Adding another unique city in Column D, does not end up in the list in the C column.Yes, I tried to reproduce on a model - it stays forever on calculations.
Will play with it if another formula works better.
- Tried this one
{=IFERROR(INDEX(Kupong_Reg!$D$2:$D$986,MATCH(0,COUNTIF($C$1:C1,Kupong_Reg!$D$2:$D$986),0));"")}
It actually worked. except for one entry showing "0". Why do you think that is? Is there a value in the Kupong_Reg!$D$2:$D$986 range with some other formatting?
