Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ScorchedLemonade

    Hiding partial rows (but not full columns)

    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...
  2. ScorchedLemonade

    Conditional number formatting

    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))...
  3. ScorchedLemonade

    Combining several arrays into one formula

    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...
  4. ScorchedLemonade

    Autoclose at specific times

    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...
  5. ScorchedLemonade

    Detecting if a cell contains a function or just a value

    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...
  6. ScorchedLemonade

    Detecting if a cell contains a function or just a value

    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...
  7. ScorchedLemonade

    Rank with array formulae

    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...
  8. ScorchedLemonade

    Combining Sumproduct & Indirect

    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)...
  9. ScorchedLemonade

    Calculating columns first in Excel

    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...
  10. ScorchedLemonade

    Quartiles of very large data scattered over several sheets.

    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...

Part and Inventory Search

Back
Top