PC requirement for Excel to run Properly

ajcarlos18

New Member
Joined
Sep 4, 2017
Messages
15
Hi,

I have an excel database worksheet and occupied 65,000 rows and 15 columns.Column A had this formula (=IF(COUNTIF(B:B,B7)>1, "Duplicate!","Not Duplicate")), Column B had this forumula (=CONCATENATE(SUBSTITUTE(SUBSTITUTE(C2,",",".")," ",""),D2,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(G2,",","")," ",""),".",""),SUBSTITUTE(SUBSTITUTE(I2,",","")," ","")). My Excel freezes and when I tried to filter the duplicate and not duplicate, it will not be responding along with the prompting memory issue. I'm working on a laptop with 64 bit and 8gb RAM. Do you think upgrading my specs will do?

Thank you very much
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,825
Office Version
  1. 2010
Platform
  1. Windows
The formula in column A copied down 65,000 rows requires 422 billion comparisons. I'd expect Excel to complain.

If you sorted by column B, a formula would only need to look at two or three cells to detect duplicates.
 

ajcarlos18

New Member
Joined
Sep 4, 2017
Messages
15
Thank you very much. Do you have any suggested formula to use to detect duplicates using the column B formulas?
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,825
Office Version
  1. 2010
Platform
  1. Windows
A​
B​
C​
1​
2​
2​
A2: =IF(COUNTIF(B1:B3, B2) > 1, "Dup", "")
3​
5​
4​
Dup
6​
5​
Dup
6​
6​
10​
7​
Dup
11​
8​
Dup
11​
9​
12​
10​
14​
11​
Dup
15​
12​
Dup
15​
13​
Dup
15​
14​
16​
15​
Dup
17​
16​
Dup
17​
17​
18​
18​
19​
19​
20​
20​
22​
21​
23​
22​
25​
23​
Dup
29​
24​
Dup
29​
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,825
Office Version
  1. 2010
Platform
  1. Windows
You're welcome.
 

Forum statistics

Threads
1,148,293
Messages
5,745,912
Members
423,983
Latest member
blackworx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top