Search results

Hi there I've created a loan sheet detailing payment dates and how much has been paid off. I want to celebrate when I first reach each multiple of $5,000 (i.e $5,000,$10,000, $15,000 etc) How do I write a formula without a helper column to return the next payment date where a multiple of $5,000...

Hi Everyone, I'm having a bit of trouble pulling together a time formula to calculate night rate. Night rate is payable for all hours worked between 7pm and 7am. In the file I've attached I've adjusted the time to include the dates, but am getting stuck with the multitude of variables. The...

Hi there In excel 2007, what do I write if I want to create the custom format to change this $1,200.00 to $1.2 K, but also takes $600.00 and changes to $0.6 K? If I write this $#, K the result is rounded, so both examples above show as $1 K. Cheers Sara

Hi There I have a particularly nasty PDF file to deal with every month which spans many many pages. I've created a copy and paste area in a spreadsheet which then runs a formula based Text to Columns. From this I need to pull selected data - the initial 6 digit numeric code - the type -...

Hi there I'm trying to tidy up a SUMIFS formula. Is it possible to shorten the following: =ROUND((SUMIFS(PayData[Units],PayData[Account],"800000",PayData[Paycode],"<>"&"STDHR",PayData[Paycode],"<>"&"*W*",PayData[Period End...

Hi there I've gotten stuck again...http://chandoo.org/forums/topic/automate-accounting-weeks File link: https://skydrive.live.com/redir?resid=9D4A15C8F236789E!118&authkey=!AKYmR0rtugSHAgQ Based on a Month/Year selected, I need to break into the Pay Weeks (Sun - Sat) and Accounting weeks...

Hi there I'm getting lost...help please. I am trying to set up the beginnings of a dashboard taking payroll data (Sunday to Saturday) and adjusting to accounting weeks (Monday to Friday). The accounting weeks vary from 4-5 each month, and the payroll data needs to be adjusted often for...

Hi there I have a really slow workbook that has 88 sumifs formulas plus 22 array formulas. While I was pretty pleased that I'd figured out how to write them, I'm pretty sure that there must be a way of rewriting them to make them faster. This is a weekly task for me and currently the...

Hi Wonderful Excel Experts I've created an excel table showing weekly financial data that can then be pulled into a dashboard. Each week, 3 more rows are added, 1 for each area with the same effective date. Period End Dt / Area / Calc / Year / Month 29/12/12 / Area A / XXXX / 2012 / Dec...