# calc

1. ### quarterly calcs from month numbers

I've been asked to calculate quarterly dollar spread based on start and end months. I need it in this format. removed bad image Q1 calc is easy, but gets complicated (for me) on the rest. Any help would be greatful. Thank you. <tbody> start month end month total cost q1 q2 q3 q4 3 7...
2. ### Golf foursomes problem

Try this:Here's what I need. 16 golfers put into 4 foursomes every day for five days. Need every golfer to play with each other golfer only once example: Day 1 (Joe -Skip-John-Pete) Day 2 (Joe -Scott - Jason- Harry) Day 3 ( Joe - Craig - Dave -Ken) Day 4 ( Joe - Zilly - Chris - Ed)...
3. ### Oh4fore

4 Rows and 4 columns using numbers 1 through 16 insert in the 16 numbers in all cells using every combinations should be 5 possible groups example A1=1 B1=2 C1=3 D1=4 A2=5 B2=6 c2+7 D2=8 A3=9 B3=10 C3=11 D3=12...
4. ### Private Equity IRR Calc

Hey All, Quick question, I'm trying to calculate an ongoing IRR calc for a Private Equity Investment. For every period, I want to have an IRR calc up to that point. I need to somehow bring in the Fair Value of the fund on that date into the last cash flow of the IRR calc, otherwise the Cash...
5. ### Solver macro

Dear Excel community Goal I'd like to write a VBA macro using Solver. I've no previous experience with macros. I am looking for a dummy guide please. Solver input Set Objective: 'Calc optimised'!\$J\$14 To: Min By changing variable cells: 'Calc optimised'!\$E\$3 Subject to the constraints...
6. ### Using VBA Replace Function to Edit Formulas

I'm trying to create a loop to Find and Replace parts of formulas on my sheet labeled Output. With my current code, the replace function isn't working and I suspect it's trying to replace string functions only. I need this to alter the formulas. For example here is my array on Sheet1 with column...
7. ### Basic error in my code that I'm unable to identify

Hi There's something in my below code that causes the workbook to hang either during or immediately after the named procedures run and I strongly suspect the cause is either in the first or last 4 rows. Private Sub Worksheet_Change(ByVal Target As Range) CALC = Application.Calculation...
8. ### IF and ProductIF Functions

Hi, I need help with this simple calculation in Excel that I am having difficulty with. I have tried couple of formulas so far and nothing is giving me the correct answer. The formulas are displayed in "MyProduct#1" and "MyProduct#2" columns. So the "Original table" is what I am working with...
9. ### Copy / paste / insert anything in file taking to long, even with calc off

I have been using Excel since it came out. Never really had this issue come up. On large files with a lot of calculations, I keep the Calc off which allows me to insert rows, columns, cut and paste without delay. Files over 100 MB, multiple pages - not a problem. But now I have a spreadsheet...
10. ### Excel Sheet Calc vs Workbook Calc

Hi, May be obvious but I have noticed in a file I'm working in, if you do a sheet calc (Shift+F9) the check that is built in is zero. However if you do an F9 calc, i.e. the whole file, a difference appears even though nothing has changed. My guess is something to do with iterative calculation...
11. ### VBA / Rounding

Hi there! So I am doing comparison reviews between a system calc and also using VBA to calc % based on criteria. Column T contains tenure. Our system rounds 4.9986 to 5.0, but 4.9900 would round down to 4.0. Is there any way to properly round up / down to nearest whole # based on the above? Ty!!
12. ### Change event triggered after macro is finished

Long time browser, first time poster. I've got a problem with a worksheet change event being triggered after I manually run a macro. The issue is that the change event actually happens before the manually run macro is even started. I've duplicated the issue in a much simpler example. Code...
13. ### Using end of month function to calculate monthly cost

Hello All, I have the following formula below. If I am using 6 30 2018 as the end date, the range the following provides is YTD (Jan1 18' to June 30 18'). Now need calendar year however so should I be using EOMONTH ? Or something else. Data!\$A:\$A is a column of monthly dates. B2 = 6 30 2018...

15. ### Data Table Replication

Hello, I am trying to use a data table for inputs and another data table for calculations based on the Inputs from the Input Data Table. So therefore I wish to replicate the data exactly in the Calc table as it is in the Input table and then add columns for my calculations to the calc table. I...
16. ### How can i do a LIFO calc in excel?

Hi, Is there a way to do a LIFO calc that reduces the older invoice and adds in the newest invoice? Making the average number of days outstanding change?
17. ### trying to shorten an if statement - must be some other function

I'm using =if(d3*e3/f3+g3<>0,d3*e3/f3+g3,0) Isn't there something similar to iferror(x,0) - that simply returns x as long as x is not an error. A number of times - I need to test if something meets some condition and if it does I just want that value returned and if not I want a zero - but...

Good morning, The below calc works as it should. I now need to add to this calc using the below as a criteria and counting total unique values from column \$B:\$B if they meet the below criteria. =COUNTIFS(SURVEYS!\$N:\$N,"=Jacksonville",SURVEYS!\$A:\$A,"=ANSWERED") Please help
19. ### Peak/ Off-Peak/ Shoulder calc

HI, I have a mechanical schedule spreadsheet where i calculate all buildings energy consumption. I have to calculate Peak / Off Peak and Shoulder consumption. I am hoping someone can assist with the required easy calculation. I have bee given the sheet from a previous employee with calcs...
20. ### Vba Formula Array Calc

Trying to calculate the percentage of projects meeting the target for each year. Here's what I came up with. Maybe there is a better way to do this, but I need it to work dynamically with changing data. What I have so far doesn't seem to return anything, just a null value... 'P-Std Calc...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...