for a specific value

Hi, Hoping I can get some assistance on this. So I'm pretty much a novice excel user when it comes to formulas and logics; but I am trying to somewhat automate a commission report we use with a few different formulas for requirements. There are a few conditions that need to be met and different...

HI guys, I have an issue with a very importat formula inside my file that is not working. The issue is this: I have this data in one sheet: London (Center) Sub 98 - 287 € 176.700 London (Center) Sub 59 - 204 - 266 € 240.000 London (Center) Sub 127 - 258 € 178.900 London (Center) Sub...

I have 200 columns and it's total in last column. I want to change my total so it will automatically changes the value with its ratio. Example Columns Value A 10 B 20 C 3 D 0 E 50 F 28 G 27 H 38 I 90 J 107 Total 373 I want change the total to 400 how to do...

Hi, I'm having a lot of trouble trying to get some values in some documents I have What I need to do is, get the amount of duplicate values that are in a column, for example In this table I need to do this calculation All the repeated values in the Column "L" are basically a single Item, but...

Hello everyone I need little help for solving a small problem. below worksheet is out of our Bill of Material formula, if we want to produce a Product '55500' we will need input 500,510,520,530,7600. 7600 is our WIP which also has input 10,20,30,40. i need a formula in next column which add...

hello to you all - This (may) be an easy question, but I seem not to be able to find the answer, so all help/pointers will be much appreciated, thanks! Question: Is it possible to cal via a formula the hand-executed right-click: "filter by selected cell's value"? I have one tab with a bunch...

I am having an issue with an IF/Then formula in Excel. If cell B has a value greater than 30 then I want the data from cell I2 to be placed in cell A. For example, when 2300487724 is imputed into B2 I want 01/09/2017 to appear in A2.

Hi, this is teh first time I am posting on this site. I have been here before have has found help in figuring out complex calculations. So I am here again, this time as a member, requesting help to figure out a formula that has me baffled. I have a whole spreadsheet full of data like that given...