Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula printing in cell
Hi all,
I am trying to copy a complete row of data to another sheet when it meets the criteria: Source data is in sheet: Master, cols A to AU, data from row 2 down, with key col X & criteria value: Closed On new sheet: Closed Placed in A2: =IF(Master!X2="","",IF(OR(Master!X2=€¯Closed€¯), ROW(),"")) Left A1 blank for header row In B2: =IF(ROWS($1:1)COUNT($A:$A),"",INDEX(x!A:A,SMALL($ A:$A,ROWS($1:1)))) When I type these formulas in the function box they also show in the respective cell. Why? Any help appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing cell name | Excel Discussion (Misc queries) | |||
Printing with formula | Excel Worksheet Functions | |||
I want to change comment printing cell 3 to whats in cell 3 | Excel Worksheet Functions | |||
Excel formula printing | Excel Discussion (Misc queries) | |||
Printing a formula | Excel Worksheet Functions |