# for a specific value

1. ### Issue With an Important Formula

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...
2. ### solver showing error

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...
3. ### Count the duplicate values in excel, but only the duplicates and the amount of duplicates values

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...
4. ### Pull data based on another column

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...
5. ### Can "filter by selected cell's value," be called by a formula?

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...
6. ### If then Formula

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.
7. ### Find the first date after, a specified date

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...

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...