Search results for query: *

I suspect this is not possible but I figure I might as well ask. Is it possible in Excel to hide part of a row (without hiding the full intersecting columns). Obviously there'd be a problem with the cell/axis labelling but I thought that maybe it could be done in a specific situation: namely...

I've got the following situation: a list of 3 columns x1 y1 z1 x2 y2 z2 x3 y3 z3 ... ... ... x10 y10 z10 The x1-x10, y1-y10, z1-z10 are pulled from a larger set of lists via formulae like: =MIN(INDIRECT("B4:B"&$B$1-4))...

Hi, I'm wanting to write a formula of the following type: =sum(if(Sheet1!C1:C200&Sheet1!D1:D200=A1&B1,Sheet1!B1:B200*index(Sheet2!B1:B100,MATCH(Sheet1!A1:A200,Sheet2!A1:A100,0)),0)) or alternatively...

Hi, I've got what I presume to be a fairly straightforward problem but none of my solutions has worked so far: here are a couple of attempts by way of example. Private Sub Workbook_Open() With Application ' sometimes Windows crashes and the workbook gets set to calculate manually, so this...

Hi, I'm curious as to a way to do this in Excel: suppose A1 and A2 hold the same value but are calculated in different ways, namely A1 just has 5 entered A2 has something like =max(B2,C2)-D2 where B2=7, C2=1 and D2=2 I want to be able to detect that A1 is not calculated using references to...

Hi, I'm curious as to a way to do this in Excel: suppose A1 and A2 hold the same value but are calculated in different ways, namely A1 just has 5 entered A2 has something like =max(B2,C2)-D2 where B2=7, C2=1 and D2=2 I want to be able to detect that A1 is not calculated using references to...

I'm trying to do something of the form =RANK(B263/C263,IF(ISERROR(B3:B263/C3:C263),"",B3:B263/C3:C263),1) with an array formula but I get the #VALUE! error. I assume that the problem is with the second part as I can put =B263/C263 in another cell and substitute that with no...

Hi, I'm trying to combine the above to functions to allow the insertion of extra data to be multiplied and summed. Thus the formula I want to use would look a bit like this (if it worked)...

Hi, I have a sheet in Excel in which some of the cells in row 1 depend upon values from earlier columns but Excel always seems to calculate rows first so that it reports errors in these cells which leads to problems in other places. Is it possible to force columns first (the columns are long...

Hi, I will soon have a lot of data over several Excel workbooks and want to be able to do something like this: select data from a row of column C, say, if the same rows in columns A and B contain certain data e.g. if one were at a zoo feeding animals the quantities they got at certain times...