I currently have 1,004,000 people and that is the maximum number of rows in Excel. I cannot add any more collected account names to be able to remove

mateomateo · Jul 17, 2021

I send bulk messages on Instagram. I gather a group of people, which I paste in Excel and delete duplicates. I currently have 1,004,000 people and that is the maximum number of rows in Excel.

I cannot add any more collected account names to be able to remove duplicates.

As I paste in the column next to it and want to remove these two, it doesn't show duplicates.

What should I do?

I've been sitting on it for four hours and I'm in a black ass.

Ababba2 · Jul 17, 2021

use another sheet

mateomateo · Jul 17, 2021

what do you mean? please explain how to be able to

Aleksandar916 · Jul 17, 2021

This doesn't work?
1. Select cells
2. Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.
3. Click OK

mateomateo · Jul 17, 2021

Ababba2 said:
use another sheet

what do you mean? please explain how to be able to

mateomateo · Jul 17, 2021

Aleksandar916 said:
This doesn't work?
1. Select cells
2. Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.
3. Click OK

just doesn't work.

For the test, I took the test in column A and entered the test in column B and marked two of them to remove the duplicate and it does not work. Shows that no duplicates lol were detected

HoNeYBiRD · Jul 17, 2021

You can't increase that limit in Excel.

Copy-paste the data into an empty Notepad++ document. Install the TextFX plugin and remove duplicate lines: https://stackoverflow.com/questions/3958350/removing-duplicate-rows-in-notepad

mateomateo · Jul 17, 2021

HoNeYBiRD said:
You can't increase that limit in Excel.

Copy-paste the data into an empty Notepad++ document. Install the TextFX plugin and remove duplicate lines: https://stackoverflow.com/questions/3958350/removing-duplicate-rows-in-notepad

okay, and how to mark later, for example, only these new names after duplication from, for example, 1.004.000 to 1.050.000?

HoNeYBiRD · Jul 17, 2021

mateomateo said:
okay, and how to mark later, for example, only these new names after duplication from, for example, 1.004.000 to 1.050.000?

I'm not exactly sure, if i understand you correctly.

Notepad++ with TextFX re-orders the lines alphabetically while removing the duplicate lines, so the fresh data you're adding each time is not at the end of the document anymore. If it's an issue, try TED Notepad, which doesn't do this. Go to Tools/Lines/Find Duplicates and see if it's better for your purpose.

mateomateo · Jul 17, 2021

HoNeYBiRD said:
I'm not exactly sure, if i understand you correctly.

Notepad++ with TextFX re-orders the lines alphabetically while removing the duplicate lines, so the fresh data you're adding each time is not at the end of the document anymore. If it's an issue, try http://jsimlo.sk/notepad/, which doesn't do this. Go to Tools/Lines/Find Duplicates and see if it's better for your purpose.

It worked, thank you! How to mark selected lines, for example 500 - 50,000 without manually selecting?

HoNeYBiRD · Jul 17, 2021

mateomateo said:
It worked, thank you! How to mark selected lines, for example 500 - 50,000 without manually selecting?

Try this: https://stackoverflow.com/questions/19161262/select-range-of-lines-in-notepad/19161689

beckham999 · Jul 23, 2021

Did you try using AccessDB?

I currently have 1,004,000 people and that is the maximum number of rows in Excel. I cannot add any more collected account names to be able to remove

mateomateo

Newbie

Ababba2

Power Member

mateomateo

Newbie

Aleksandar916

Power Member

mateomateo

Newbie

mateomateo

Newbie

HoNeYBiRD

Elite Member

mateomateo

Newbie

HoNeYBiRD

Elite Member

mateomateo

Newbie

HoNeYBiRD

Elite Member

beckham999

Newbie

Main Menu

Marketplace

Making Money

BlackHatWorld

Other