# Posts by onexc

• ## Calculate final sales price for a desired profit

Thank you. I will make a calculation.

• ## Calculate final sales price for a desired profit

A sample worksheet would help to get a solution.

Added. Thank you very much. Normally, I can do this only for one commission rate: ( Costs Total * Commission Percentage ) / ( 1 - Commission Percentage ) gives me what I want to. However, in this case, same commission calculations are connected to each other.

## Files

• mysample.xlsx

• ## Calculate final sales price for a desired profit

Hello all and happy holidays,

I am trying to calculate the final sales price for Etsy sales over a desired profit price, but couldn't handle it. The problem is that commission rates are connected to each other and one changes, others change too. I could solve the problem when only one commission rate applied, but multiple commission rates are getting hard to get out of. Is there a magic way that when I enter purchase price from the supplier and shipping fee as costs (only those two), and the profit I want to have, populate all other fields and finally get the price that I should sell? I hope it is not complicated. Thank you.

• ## How to use comma in a single worksheet to separate decimals.

I AM CRYING OF HAPIINESS :') THANK YOU!

• ## How to use comma in a single worksheet to separate decimals.

As you know the decimal separator is set at the Application level ...

so the next question is the following :

Is your objective only a display issue ... or are we talking about numbers which should continue to act as actual numbers ???

Just a display matter. I just want to display as if they are separated by commas instead of dots in another sheet while keeping actual format as dots.

• ## How to use comma in a single worksheet to separate decimals.

Nope, Not at all, Carim. They are formatted as numbers that their decimals increased to four digits.

• ## How to use comma in a single worksheet to separate decimals.

Hi,

In my workbook, I have prices with four digits after dot like "25.000"; while considering this is formulated number format, in another sheet I want to display it as "25,000" with a comma instead of dot. If I change it through Options > Advanced > Decimal Separator, everything works like a charm but everything becomes to have changed! However, I just want to change it for numbers in a worksheet only. How can I use comma for numbers without breaking other dots? Thank you.

• ## Dependent dropdown lists with multiple words in the different sheets

Hello, bosco. It is useful solution. Let me apply the same way you do in my own sheet. Thank you very much.

• ## Dependent dropdown lists with multiple words in the different sheets

Thank you Carim. I am on case.

• ## Dependent dropdown lists with multiple words in the different sheets

Delighted ...

Thanks for your Thanks ... AND for the Like

Hello Carim,

Could you check the workbook what I did myself. It returns an error.

• Book1.xlsx

• ## Dependent dropdown lists with multiple words in the different sheets

Attached is your test file ... with the Basic Principle of Dependent DropDown Lists ...

Hope this will help

Hi Carim,

Thank you very much and much again. It works like a charm. You gave me what I needed. Case is solved.

• ## Dependent dropdown lists with multiple words in the different sheets

Quite honestly the sample file you have attached is way too vague to come up with any meaningful recommendation ...

Could you share a file which is closer to your real-life situation ...

Hello Carim, here is the file you requested. I tried to adapt some examples from different websites but none of them worked for me. Sample workbook is in the attachment and very simplified as real life situation.

• Book2.xlsx

• ## Dependent dropdown lists with multiple words in the different sheets

you will have to accept to redesign its basic structure ... not only to be in a position to easily build your dependent dropdown lists

... but also to avoid sowing the seeds of all your future problems ...

Okay. Of course, little tweaks are acceptable.

• ## Dependent dropdown lists with multiple words in the different sheets

Hello again,

When it comes to issues to fix with Excel ... an auto-loading firearm is called a Machine Gun ... !!!

Hi Carim, I look forward to receiving your good news as usual.

• ## Match a Word From A List Comma Separated in a Cell

I'M CRYING OF HAPPINESS NOW

• ## Dependent dropdown lists with multiple words in the different sheets

Hello OzGrid,

I have a workbook, and trying to arrange a dependent drop down list to product name and company. Problem is that, product names (named ranges or groups? I don't know how I should call them) are placed in different sheets in the same workbook and they have multiple words. Addition to this, in the main sheet, product company and product name are placed in different cells. After a couple of hours, my work returned no success. I do need help. Thank you. Sample is in the attachment.

• Book1.xlsx

• ## Match a Word From A List Comma Separated in a Cell

Thank you sooo much Carim, Wonderful! You made my day again. I'm crying of happiness now

• ## Match a Word From A List Comma Separated in a Cell

Wow, That is incredible Carim I cannot thank you enough. All seems perfect. Just one more question... Normally, there are too many categories more than this sample workbook; is there a practical method to pull out each product? I tried this method: Text to columns then paste as transpose but it will take ages.

• ## Match a Word From A List Comma Separated in a Cell

Hello,

I would like to list my product by using of a dropdown. Then, when a product selected in a cell via dropdown, its fee rate percentage must have appeared. However, I don't know how to overcome this. Because products have been categorized and each category is in a cell as seperated by a comma. I worked on a partial match solution but it didn't work. Any help would be great. For some reasons, I do not want to break those categories, though helper can be okay if applicable. Or any VBA solution at the last analysis. Thanks. File is in the attachment.

• test1.xlsx

• ## Multiple Criteria Lookup while Working With Number

Fluff is right ....

In addition ... Excel is designed to make your life a lot easier .... see your test file attached

Ah Yes. I don't know how I missed that one. Thank you very much you, too, Carim.