reach

Hello,</SPAN></SPAN> I need a formula of a VBA that can sum data of column E in the column F when sum reach at 8 restart sum to total 8 again and again. </SPAN></SPAN> Result sample...</SPAN></SPAN> Book1EFG12345DataSumProcedure655Start Sum716806906100611171218End Sum1355Restart Sum...

Hi, I've been searching for 3 days now for the below requirement but couldn't find an answer. i tried combining multiple VLOOKUP formulas but no luck. i have big data below that is used to forecast when a server will reach memory consumption of 70% B1 to IC1 list of Server names. A2 to A330...

Hi I have a spread sheet which shows employees (trainees etc) who are under 18. In cell B2 I have thier DOB. Then in C2 I want a formula that returns the date of when they would reach 18. Anyone know how to do that?

I am trying to add a group of numbers together until I reach a 0 in a cell; however, I am starting with the last number in a column and going in reverse. <tbody> 100 200 300 0 450 200 600 </tbody> i.e. I would like to start with the last number (600) and add until I reach a...

Hello guys. I have an issue. I have to sort the data, but optimised in order to be less than 100.000 but the sum nearest possible. Virtually I need a way in order to have some data, I want that data selected by the excel (preference for the parameter of the data, but the main preference has to...

hi all.. how to determine date this below : start date : 1/1/2018 end date : ...? parameter : <= 6 month any help, thanks in advance... susanto.

I didn't know how to title this but this is what I am looking for. If I have a list of numbers like below and I want to know when I reach 171, what formula would I use. I the perfect world it would let me know where the row is split. I just don't know any other way to explain it. Any help...

Hi Guys, I was wondering if I could find out how long it takes for someone in sales to reach a target of say £1000? My guess is I have to add the sales figures cumulatively and then return the date of when the target was reached? Not sure where to go after that. Any help would be great!

In most of my Excel sheets, I use Freeze Panes. And to keep my work visibly tidy, I hide rows. Now, I have VBA to reach First Cell after Frozen Pane. And also, VBA for ignoring Hidden Rows. But when I combine both to reach First Visible Cell - It takes a lot of time. I strongly believe that...

I'm kind of new to VBA and wonder if there is a easy way to loop through a folder with let say 300 files add a letter in alphabetic order at the beginning of each file name. So if the file name is "Vpp_vs_Freq_at_PC-10.0_KKC-2.0_180817-143105" change the name to...

I know I've done this a hundred times, but it must be late. Need formula to produce the required monthly payment to reach $16,000. 15 yrs x 12 payments Earning 8.2% annually Thanks!! Mike

Are we allowed to hire someone for a small project? The details are too much to post for help in smaller segments, so I'd rather explain them one-on-one and work on the project together. If this is allowed here, please reach out to me ASAP, I need this done by Tuesday. Penny

Hello, Im trying to calculate a way for me and my colleagues to know how many remaining 5s we need to reach our target %. Since the target is 88% the only input that brings it up is the input 5 since input 4 is valued at "75%". Ive tried solving this for a few hours but i just cant wrap my...

kindly help me guyz to get this formula i need to fill table 1 automatically from table 2 i need each name get the specific type once he reach the same date like for example once we reach Jan/2018 it will write down next to the name that A B C on the specific column on the specific date check...

looking for a formula that will help me calculate how many more questions correct are needed to reach 75% accuracy in this table. is there a way to use a formula to find the number of questions in the data table? https://ibb.co/nCiQFG

I want to know for example: person must reach 200 dollar target for his sales. As soon as he reach target the figure must appear in "green". While trying to achieve target the rest must be in "red". Can it be done in Excel automatically?

I've stumped myself with this one, and I'm not sure its even possible.. I want to create a formula that checks if a cell is blank, if it is not I want it to = a designated cell. If that cell is blank I want it to check a different cell if its blank. This formula will be copied down a column to...