Search results

Without knowing what you want to achieve, it's impossible to say.

Have you checked calculation is not set to manual? Tools > options > calculation - make sure auto is set.

You could use hyperlinks

Don't know if you ever got this one sorted but I think you need =IF(G85="na",0,IF(G85<1,COUNT(G$78:G$91)-(RANK(G85,G$78:G$91)+COUNTIF(G$78:G85,G85))+2,""))

Nice one Bob That's got to be one of the clearest answers I've ever seen on the boards!

Use data validation to create a list http://www.contextures.com/xlDataVal01.html is a fantastic place to start

It has probably been conditionally formatted - that takes precedence over the the formatting you are trying to add.

Possibly this is caused by the figures displaying at say 2 dp but the real values remain as calculated - this can make total 'different' from the sum of the displayed components.

Thanks for the feedback - feel free to post again if you have any problems.

As Brian says, put your totals at the top. You can't freeze panes other than at the top.

Works fine for me without the parenthesis Have you tried using the formula auditing tool?

probably means that your values are text not numbers

On your spreadsheet Tools > Macros > record Macro You then carry out the steps required and the recorder stores these. Play with it!

I don't think so. As far as excel is concerned they are all just numbers formatted differently.

Don't think so

See attached - you will need to adjust cells to reflect your sheet

Try MOD(C1,A1)

=if(isna(VLOOKUP(A2,STRUCTURESP5.xlsx!$1:$1048576,3,FALSE)),"",VLOOKUP(A2,STRUCTURESP5.xlsx!$1:$1048576,3,FALSE)) Will trap errors if match not found but you don't seem to have a column reference in the formula e.g. $1:$1048576

You have to have EXCEL 2007 for SUMIFS - it allows multiple criteria and so does away with the need to use SUMPRODUCT - the XLDYNAMIC link is only for sumproduct I don''t have 2007 so can't advise further

Couldn't agree more, Brian - SUMPRODUCT is one of the most useful and versatile functions I've come across. I suppose that as 2007 has SUMIFS, that is the way ahead - personally, I will be staying with 2003