Excel

Simon Hurst’s search for a silver bullet to cure Excel hell drew him to a meeting of like-minded enthusiasts at the Slaughtered Lamb in London on 25 January.

9

I am trying to sum cells F2 to N2 but if any cell value exceeds 35,I want to limit it to 35.  =sum(min(35,f2):min(35,n2)) doesn't work and it won't accept curly brackets.

16

I am working on a time sheet where I record my activities in Excel, the cells are formatted as time cells and record 01:00 or 02:30 etc. The daily activity is totalled in the same format.

3

A VBA code for automatic Refresh in PV and formatting.

 

4

Hi, this is more of a mathematical question initially, but I also want to get the info on to a spreadsheet as well.

3

As regular readers will know I have just started to use Sage 200.  I am in the process of automating our accouts pack and have investigated the =SgAccNominalLedgerActual($A13,$C$1,C$2)  Where A13 c

1

Hi

I am trying to do a cashflow projection which includes a substantial business loan.

 

3

Reglar readers of Excel Zone will remember “Mr Excel”, Bill Jelen from our 2008 Golden Cells

Simon Hurst completes his management dashboard tutorial series with a look at effective visual presentation techniques.

9

Pages