beginning

Hello All, I'm a fairly light excel user and am looking to do the following with the set of data below: Beginning Balance BofA: $1,000 Beginning Balance WF: $1,500 <tbody> Amount Type -2 BofA 10 Wells Fargo 12 BofA -5 Wells Fargo </tbody> I'm looking to have a running balance for 2...

Hi, I have this formula that work very well but I need some help when the formula return a 0 that the 0 will be at the end ( on the right ) and not at the beginning, thank you...

Hi I have these numbers, please see below and I am copying them lets say from notepad and want to paste them in excel but I do not want excel to remove 0 from the beginning of these number? How can I do that? Thank you so much. 008471164653 008739164653 012914470253 015487370253 016333570253...

I have a spreadsheet with rows of data divided into groups by financial year. I have a macro that carries out calculations but need to add some code that will find the row with the latest 1 April date(the beginning of the financial year). The date format in use is d/mmm/yyyy. Any ideas please...

Hey Everyone! I created a macro a few months ago that help us to make some reports easier to input. There are multiple lines in these responses that we don't need and the only way to find the ones we do need I used the following method. All of the cells that we needed started with a number, had...

I have a beginning number of 110, the Ending is 150 and the Median 130. How can I distribute the beginning, Median and ending in 11 column? what is the formula to get the gaps in between 110 to 150 with a median of 130 in 11 columns?

Hi All, I'm becoming beyond frustrated. I have a small input section on 1 page where the user is able to select two criteria (the second list being limited to the first). Once those selections are made, there are two other cells that should automatically return a value from a table in a...

I am trying to have a cell return a blank if no date is in the selected cell for both Beginning of Month and End of the Month. I DO NOT have the End of the Month correct. This just returns 1/31/1900 IF(ISERROR(EOMONTH(AE40,0),"",EOMONTH(AE40,0)) I think I have beginning of the month correct...

I am trying to create a function that will recognize data beginning with "006" If it finds data beginning with "006" then remove all but the last 8 characters I don't know why I am having such a hard time with this one. Something like: =IF(LEFT(A1,3)="006"(RIGHT,A1,LEN(A1)-8) Thank you in...

I have two INDEX-MATCH formulas that I'm trying to chain together with an IF statement that I was looking for help. INDEX-MATCH 1: {=-IFERROR(INDEX(filtered!A:Y,MATCH(1,(filtered!W:W=W2)*(filtered!J:J=-J2)*(filtered!E:E=E2),0),10),0)} INDEX-MATCH 2...

I'd like to perform a conditional sum across multiple worksheets. Variations on the following doesn't work: =SUMIF(First:Last!D7:D126,1, First:Last!D7:D126) where first and last are the beginning and ending worksheets. Is there a way to make this or something similar work? (Excel 2010)

I have this line of code ... .Range("D1").Formula = "=if(C1="""",0,if(C1=""OFF*"",0, if(c1=""STAT"",7.5,(C1-B1)*24-0.5)))" If worked fine when I was simply comparing for the term "OFF", but I have since needed to adapt it for anything beginning with "OFF". I assume a wildcard '*' will not...

Hi, I'm trying to manual calculate an adjusted cost base from a large list of stock transactions for different securities =IF(A3=A2,IF((E3="BUY",J2+I3,IF(IF(E3="SELL",J2-(F3*L2),I3) I'm trying to use the above formula but it keeps returning "false" instead of I3 when a3 does not equal a2 I...

Hi, So with some help from users on this board I have put together some code which will define a bunch of ranges for me. I need to reference the first, second, third, etc cells in the ranges I've defined now. How can I do that? As an example: The code might run through the data and say...