counting the number of duplicate entries with excel

[anmac1789]

I came across this video on youtube about counting the number of blocks of dupes using excel. Is there a way to do this with everything ?

video: https://www.youtube.com/watch?v=mJrEVHYlgqY

Also, can we have isnumber() excel function in everything 1.5a ?

[NotNull]

Is there a way to do this with everything ?

No.

Also, can we have isnumber() excel function in everything 1.5a ?

Take a look at the N() formula or the[N:] search preprocessor function.

[anmac1789]

Is there a way to do this with everything ?

No.

Also, can we have isnumber() excel function in everything 1.5a ?

Take a look at the N() formula or the[N:] search preprocessor function.

which one is this ?

[NotNull]

which one is this ?

Please explain?

[anmac1789]

Take a look at the N() formula or the[N:] search preprocessor function.

[NotNull]

That doesn't help ... at all.

[anmac1789]

That doesn't help ... at all.

I meant to say, where is N() formula or the[N:] search pre-processor function ?

[void]

Everything is not Excel.

To export your results to Excel:

• In Everything 1.5, from the File menu, click Export.
• Change the Save as type to: CSV
• Choose a filename and click Save.
• Click OK.

All added columns are exported.



To open the exported CSV file in Excel:

• In Excel, from the Data ribbon, click From Text.
• Change File origin to: 65001 : Unicode (UTF-8)
• Click Next.
• Uncheck Tab.
• Check Comma.
• Click Next.
• Set your desired column types. (or leave as General)
• Click Finish.
• Click OK.

[N:]
N()

[anmac1789]

Everything is not Excel.

To export your results to Excel:

• In Everything 1.5, from the File menu, click Export.
• Change the Save as type to: CSV
• Choose a filename and click Save.
• Click OK.

All added columns are exported.



To open the exported CSV file in Excel:

• In Excel, from the Data ribbon, click From Text.
• Change File origin to: 65001 : Unicode (UTF-8)
• Click Next.
• Uncheck Tab.
• Check Comma.
• Click Next.
• Set your desired column types. (or leave as General)
• Click Finish.
• Click OK.

[N:]
N()

Thank you, selecting 65001 : Unicode (UTF-8) for file origin really helps to make a table without errors