How to group small variations on data

[Liviu C]

Hi,

Please help!
I have a file with multiple sheets. The same products, but from different countries so they have 70% the same names. They all have different prices but in the same currency. I need to be able to have the first row with my name of the product (the one that I set), my price in the second row, and from there (3rd row, 4th, and so on) the price that every customer offers. Starting with the best (calculated in percentage from my price).

So basically I have my price with my name of the product, and I need to see which one of my clients has the best price on offer.

It would be great if I can just input the clients list somewhere (on a different sheet) and it will give me the updates result in the first sheet. This is because every month (sometimes twice a month) prices may change.


I know it is pretty darn complicated but I even tried paying for this and didn't manage to find the answer...

Thank you in advance for any possible solution

 

[Liviu C]

Hi again,

i managed to get some more data on the file. as per your request please find the file here: Copy of ALL IN 1 martie 2024.xlsx

In the "main" sheet is all the info i`m trying to get a better use for.
In the rest of the sheets i inserted "EU" for european clients and "RO" for the local clients (after their name). I only put in a few of them.

I inserted the ECMA codes i already have but you will see there are about 100 lines that i didn`t find codes. Today i searched again and still can`t seem to find them. I also asked a client but he has yet to get back to me.
The product names are is the one i have in my stock program and i need that one to be the base.

Thank you again!

Please keep in mind that i did a lot of work on the file and some of the lines don`t have formulas, the data is inserted by hand and it may not be the same with other lines.

 

[Liviu C]

So I guess nobody can help me?

 

[awoohaw]

Hi again,

i managed to get some more data on the file. as per your request please find the file here: Copy of ALL IN 1 martie 2024.xlsx

In the "main" sheet is all the info i`m trying to get a better use for.
In the rest of the sheets i inserted "EU" for european clients and "RO" for the local clients (after their name). I only put in a few of them.

I inserted the ECMA codes i already have but you will see there are about 100 lines that i didn`t find codes. Today i searched again and still can`t seem to find them. I also asked a client but he has yet to get back to me.
The product names are is the one i have in my stock program and i need that one to be the base.

Thank you again!

Is your dropbox setting "no download"? I can't seem to download to my computer? Also, i do notice that you have links to other workbooks in the document. Can you post one of those if it is a data file critical to the question you are asking?