Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
big problem with =if(countif funtion
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
big problem with =if(countif funtion
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" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
big problem with =if(countif funtion
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 "Max" wrote: 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" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif funtion | Excel Worksheet Functions | |||
Countif problem | Excel Discussion (Misc queries) | |||
countif problem | Excel Discussion (Misc queries) | |||
countif problem | Excel Worksheet Functions | |||
Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions |