needed

I get an export out of our scheduling system and need to aggregate the raw materials needed. I need a formula that, when "1" or blank is shown, it will give the next value above that is not a "1" or blank See below for my data set and what is needed How my data exports Column I need to create...

Hi, I have been struggling with this VBA code for quite some time now and would appreciate any help with it. I have attached a sample spreadsheet I am working with. First sheet shows the raw data that comes from the SharePoint and second sheet shows the report I am trying to build form the raw...

Hi Guys, I am having an issue which a spreadsheet where I have a list of stock <tbody> item SKU TYPE SIZE Starting QTY Running Qty Shirt SS-5XS SS 5XS 8 Shirt SS-3XS SS 3XS 23 Shirt LS-3XS LS 3XS 2 Shirt LS-2XS LS 2XS 25 </tbody> I then have a table which lists all items the...

I am trying to remove preceding characters in front of specific text. I have a formula but I am not getting the needed results. Can someone assist me? The text in cell C2 is \\stlwrchprnprd01\a1_café2r2852 The formula in D2 is =RIGHT(C2,LEN(C2)-FIND("01",C2)) The result is "1\a1_café2r2852"...

I am new to Mr. Excel I look at it often for answers to questions about formulas that I have. Most of the time I can research it out enough to figure out and find a formula that works. I don't like to bother people if I can do it myself. But I just can't figure this out. please help. If I have...

I have a column of values: 460,683 441,249 107,800 89,406 I need a formula in another column that will tell me what value of 100 is needed to divide by in order to have the calculated result be <= 55% For example, the 460,683 can be divided by 900 and multiplied by .1 to equal 51%. I need a...

Hi people, I am using a user defined function formula in my excel sheet. The formula is PlaceBO = (Exch, TrdSym, Trans, Qty, LmtPrice, SqOffValue, StoplossValue, TrailPoints, OrdType, TrgPrice, cTag) I am using this for trading. The problem is I am manually editing the...

Hello, Is it possible to extract the address and phone number from google using macro? I have excel where, column A has company name, column B has company location and we need company address in column C and company phone number in column D. How to do? Please help PFB table for reference...

Could somebody help me create a custom function that returns the following: A*SUM(A1:AN)+B*SUM(B1:BN)+C*SUM(C1:CN)+....+M*SUM(M1:MN) The variables would be A, A1, and MN. Many thanks! A A1 A2 A3 ......AN B B1 B2 B3 ......BN C C1 C2 C3 ......CN ...

Morning all. Some lookup (I think that’s the function this will be anyway) help needed as follows. I need a formula in cell I2 that looks at a date in Cell F2, compares that to a range of dates in cells A12 to A350, finds the closest date in that range to within + or – 2 days (it might even...

A Screenshot of the worksheet is attached below. Help needed please as I'm new to using codes in VBA. https://1drv.ms/u/s!AuJosJM5re-thDoADN_0odaoTIQH

Hi, I'm in the process of replacing SUMIFS with SUMPRODUCTS for closed workbooks and have hit an error I cannot solve. The offending formula is: =SUMPRODUCT(--([MFT.XLSX]Perth!$5:$5=TEXT($U$1,"mmmm")),--([MFT.XLSX]Perth!$6:$6=$W$1),[MFT.XLSX]Perth!$21:$21) It is returning DIV/0 I know...

SO I got this table https://www7.zippyshare.com/v/oYnSugEe/file.html The data on the input page is usually 100 000 rows and more, but I discovered, that it does not really matter, since the problem lies in the formula of the "check page". Its based on sumifs and I dont know how to make it...

Hi i have the following formula =INDEX($F$28:$F$1000,MATCH(H9,$H$28:$H$1000,0)) which finds match in H28:H1000 and outputs corrosponding value in F Column However if there are multiple matches of H9, it always outputs first value Is there a way to output them all ? Array needed i think Any...

Hi Hoping someone can help, I need to gather data from multiple worksheets on multiple workbooks The below gives me #REF error =SUMPRODUCT(INDIRECT("'"&$C$5&"'[JAMIE SHEET METRO.xlsx]!'""'c$12:c$25"),$C$9:$C$22,INDIRECT("'"&$C$5&"'[JAMIE SHEET METRO.xlsx]!J$12:J$25")) Cell C5 refers to tab...

Hi I am reading the article below and although he gave an example why converting number to text is needed, I did not understand the example. Can you please give me examples/reasons why that is needed? Thank you https://exceljet.net/formula/convert-numbers-to-text

I have the following XML Code to present the user with UNDO & REDO QAT Options in my workbook The commands and buttons do work - However I am only able to UNDO (or REDO) 1 level back - I was hoping to get several UNDOs if needed Not sure how many are provided in standard Excel Ribbon but I...

I have a sheet (made by some SQL/VBA/Excel expert long time ago). In this sheet I can enter a production run number ("Productieorder / PO") and it will show me all necessary components with current stock, clearance status, total needed stock etc. pulled form an insanely large database. I would...

Good day, I am driving myself crazy with trying to figure this out. Please save me! I need a formula that will tell me how many miles are needed to be driven annually, based off of a Cents Per Mile and Driver Salary. Need help figuring out the "###" parts. Web example can be found here...

I am at my wits end. I have a spreadsheet that was created by someone else, that has a lot of embedded formulas in it. We need these formulas to simplify a large audit we before, but when specific fields are empty, others display the #VALUE ! error. I have tried different conditional...