basis

Since i'm new to excel I'm not that sure if there is any type of formula(s) that would be able to easily calculate costs basis the below parameters. Calculating the "units" isnt the hard part for me, i've got that done already. It's finding a formula to calculate the costs once I have the...

Hello, newbie here. can someone please help on how to work on the formula using dates (year... if possible movable dates) as basis for computing the interest. i made a formula and i cant seem find anyway to have the year be moving, depending on the present year, or if possible to include the...

Hi all, i'm new to vba work and i'm looking for an help! Question: In x path, on daily basis my team member saves the folders with loan number and today's date ex (7894561023 6-1-2019). they can be more than 25 or some times none on single day. so i want to copy the based on latest date...

I copied a range of cells and pasted them into anew WB as links. This works fine on my pc but on my co-workers it does not. Seems the drive is mapped as "X" rather than "Z". I can overcome this on a user by user basis but would prefer a bettter solution. Suggestions? Range("B2").Select...

this may be more of a math question but in column A i have a rolling 12 month balance column B is a basis points assigned to a product Column C is the "new value" example below...my question is if a user only got the new value (column c) how could they back into column A (assuming they knew the...

Hello, I have a list where I need to get totals on cur. basis on top of the data as per the filtered account ( A1 ) basis. I need to type a formula in between E1 and E4 in curr. basis but , I do not know how I can run subtotal with if condition. Right side of the spreadsheet ( between column...

Hello! Can you please help with with this code where I am trying to delete certain amount of rows after I have applied a filter selection criteria. The range of rows (in the example, rows 50:54) will change on a daily basis. : Rows("50:54").Select Selection.Delete Shift:=xlUp...

This works in excel 97 -2003 but does not work in 2013 or 2016. I get a the #Name ? value. Will you review and see what needs to change to work in 2013 or newer? Function BOND(Subtotal, TaxRate) As Single 'Author Jim Hesh 'Set limits and...

Hello, I want to learn the formula to find the cost under FIFO Basis Example: Source Table <colgroup><col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> </colgroup><tbody> QTY...

My workers work an event that begins on different days in my work week. My work week begins on Sun and ends the following Sat. The event may end in a different work week. Is there a way that I can determine the work weeks from a range of dates and calculate their work hours and pay on a work...

I have been tasked with extracting data from SAP into an excel worksheet. I need to sort it by a material grouping(2 or more materials, as many as 5, summed together) and place it by week into another worksheet for the entire year. This will be done on a weekly basis and will constantly be...

So I've created this cool rating UDF for my office which I thought was going to calculate per row but for some reason it repeats the calculation of whatever row I press ENTER on. I've applied it to a column and dragged down =basiscalc() The code should be getting the active row of each place...

Greetings, I am interested in building a subroutine that imports external data from using a web query on a cyclical basis, one day, one week, one month, or one quarter. I would like to know if anyone has experience in doing this and if so how might be best to structure the block of code that...

Hi there, I'm in between basic and intermediate level I think. I do know the popular formulas (IF, VLOOKUP etc in isolation) but want to really take it to the next level understanding nested formulas and multiple functions in a formula, index and using arrays etc. and jazz up my chart skills...

Hello, I would like to have a macro that will insert one blank column (C) Into a (SHEET 1) workseet. Also if this is do able have the following lookup run at the same time. =VLOOKUP(B:B,Sheet2!H:I,2,False) I work on These type of sheets on daily basis and i cant type to figure how to make...

Can someone take a look at the VBA I wrote? What I want this VBA to do is, remove all rows where there is a duplicate in a column with a certain header. So I want it to work JUST like the remove duplicates, except I want it to run on the basis of a certain header...

I have the following formula: =IF(AP32*AQ32*AR32*AS32>0,"Y","N") I am creating a spreadsheet that gives results on a monthly basis and on a Quarterly basis. Under the quarterly basis I am getting the valued used error only on the columns that are blank. Not sure why this is happening only...

Hi, I have text file which must be like as under 0040025001200205000000018907082017 0040015001600405000000018907082017 0040015001600505000000018907082017 0040015001600205000000018907082017 I need to create multiple text files on the basis of 3 characters from 12 no. of character i.e. in bold...

Hi, I have a column of 10 to 15 share symbol in which I need to get price updated on daily basis from NASDAQ. Is there anyway that the same can be automated?

My data set looks like this: Column A Column B Date Total 03/15 62 03/16 80 06/15 100 06/17 94 09/15 81 12/15 23 12/16 68 12/17 96 If I...