Search results

Hi vletm, why not like to exchange brains? :) could you do it in my excel and upload? Not sure I catch your idea correctly, but really impressed with drop down suggestion! Appreciate your help a lot! Siga

Hi Bosco, What if I have more than 2 divisions? Let's say 3 or 4, that means column N = Division Z and Column O = Division W in sheet Maps. Trying to think one step further..I tested Chihiro formula and it works with 3 Divisions as well. Siga

Just perfect!! THANK YOU Chihiro.

Hello ninjas, I need your advice again. Please find the uploaded file. Sheet "COGS", rows 67:91. I need to catch values in column I (highlighted in yellow) from sheet "Maps" based on concatenate cells Sales Channel + Geography (e.g. Trade Australia" or CCG Japan). Where vLOOKUP is just...

Mind blowing! Is there a way we could exchange the brains - you and I? :D

Hi vletm, I like your second version better as it is below the table. The thing is that I usually have to add some products (columns to the right). It might vary from 5 to 15. Do I understand correctly if I add columns, I need to change only this condition "For x = 5 To 10" in your Macros. In...

Bosco, THANK YOU! Works perfectly. You made my Monday sunny :)

Bosco, also uploading file for your review and confirmation why this happened. Thank you!

Hi Bosco, I went through your formula and tried in my file. I extended number of countries as well as added 2 products. My formula looks now like...

I will work today to try to built into my excel. No Questions for now, only BIG THANK YOU!!

bosco-vip, I really feel like jumping into ninja world. THANK YOU! need to study your masterpiece and comeback. but it blew my mind!

vletm, looks fantastic! Actually I need all the values except blanks and 0. And saying 0 I mean the ones that are <> or equal 1. In other word I do not need values like 0.005 or 0.1. Also, how you build that Macros? you already built in the solution, but how to "copu paste" it into my working...

In my example trade=3rd party. Forgot to change the description in my result tab while preparing example.

Hello excel ninjas, Need your help. Please find my excel spreed sheet attached. I have an excel table with the result after comparing to other excel tables. Now I need to extract only cells which have value >0 and my Product1/Product4/Product5/etc row from horizontal view should become a...