big problem with =if(countif funtion

[Dylan @ UAFC]

I though this question was pertiaing to if function.
Max if you can help I have spreedsheet with a very complex
series of vlookup fromulas pull off a data base that is
500,000 deep and about 15 columns out.
The mail data page is set down 25000 rows right now.

It was running good speed was super but efficient.
The whole thing is driven off a phone #, completely unique and
in ascending order.

The problem is that In the main data page can not have duplicate
phone # entry, it tells us a lot, very important to the concept.

I incerted,
=IF(COUNTIF($b$1:$b$25000,a1)>1,"TRUE","FALSE")

now the spreedsheet is so slow it can barly run.any sujjestions

 

[Max]

The problem is that In the main data page can not have duplicate

phone # entry, it tells us a lot, very important to the concept.
=IF(COUNTIF($b$1:$b$25000,a1)>1,"TRUE","FALSE")

I don't have xl2007. But maybe you could try/use a pivot table instead to
handle this part of it. It would be a much faster/easier way to drill out a
uniques list of phone#s which is imo, core to your overall set-up. Just
insert a new top row, enter a col label, say: Tel for the phone# col, then in
step 3 of the pivot table wizard, click Layout & drag n drop "Tel" into both
ROW and DATA areas (set it as Count in DATA).
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---

 

[Dylan @ UAFC]

Interesting I'll give it shot.
Pivot table are not my specilaty though.
but that formula just overloads the system
I have to look for alternatives