Data extraction

Hello everyone,
Please help me.

I have a table with a list of names, amount, ID and type (EV, BQ) .

for each type I have an ID

I want to retrieve IDs of duplicate names except that they must be of different type and amount of their amounts equal to zero

I want to have the ID of EV type

so : for each BQ an EV, search ID(EV) if names duplicate and sum amount = 0

the table is in frensh so

names: nom
amount: montant
ID: N° piece
type: type

thank you

Hi Demahom08,
Your request is not clear. The data are in French does not either. It would be easier to understand your request, if you could include on a separate sheet(With the attached book as above), a desired(Out put) sheet. We know your raw (Input) Data, but we do not know your expected output.

Hi AB33
thank you

I include an out put

thank you again

Hi Demahom08,
There are problems with your data.
nom1
and nom 1
Are not the same, even if I trim the space, there are not duplicates and treated as two separate words. I can manually change them , but there is another serious issue with column M ( Mtant en DI). There are not numbers. I have tried to convert them in to numbers, but no change.
It may be your regional settings. I use a comma to separate numbers, but in French, I think you use a dot.
Try to add - 800.000,00
and 800.000,00
You get an error, as there are not recognised by excel as numbers.

HI AB33

I understand i had the same problems i changed the names cause it was just an example and for the column M i should to covert them to numbers

Hi

is there any solution IF we have "Sarah Miler" and "Miler Sarah" can the VBA take them as duplicate ??

or we can have "Sarah Miler" and "Sarah Silvia Miler" for me it the same person but can the VBA take them as duplicate ?

No,
VBA can only treat duplicates if two words use the same keys but could be in different Upper and lower cases

Sarah Miler= SARAH Miler
Or

Sarah Miler= SARAH MILER
If you ignore the case sensitivity, they are the same words.

Hi Demahom08,
Please wrap (use) your code in code tags. You will be re-minded by the Moderators.

I did not understand your last attachment. Could you please attach this code with you sample and show me if you want to change the code. It will help me to understand your question by looking at the code and sample.

Try the attached

Try this one

thank u jindon

what about similarity i found some thing about Levenshtein algorithm and PHP text similarity do you know any thing about