Functions
in [Excel]
|
Copying daily data from one tab to a weekly summary table I have been working on this for a little while now and can't seem to grasp the right formula to use. I have columns of data sorted by name to be tracked daily. I need to then give my boss the information so she can not only see it daily and monthy which I have figured out - but wants to see weekly as well and... 3 Jun 2010 02:25
entering more than seven levels of functions with in a function I WANT TO PUT MORE THAN SEVEN LEVELS OF FUNCTIONS WITH A FUNCTION. FOR EXAMPLE =IF(B14=10000,14500,IF(B14=10470,15100,IF(B14=10940,15700,IF(B14=11410,16300,IF(B14=11880,16900,IF(B14=12350,17500,IF(B14=12820,18100,IF(B14=13320,18700,IF(B14=13820,19400,IF(B14=14320,20100,IF(B14=14880,20900,IF(B14=15440,21700,IF(B14=1... 3 Jun 2010 07:51
countif I am trying to count the number of cells in column B="large" when the condition in column A="week1". I tried the formula below and it counted all the "week1"s along with the "large". Any Ideas? =COUNTIF(A3:A12,"week1")+COUNTIF(B3:B12,"large") ... 3 Jun 2010 02:25
Multiple Subtotals in Excel Macro I have applied the registry patch described in http://support.microsoft.com/kb/831824/ but it does not seem to notice this if the subtotaling is done inside a macro. When I execute the subtotals (3 or 4 levels) directly from Excel, everything works fine. But when I record a new macro and use the same subtots... 2 Jun 2010 18:43
Insert Menu Greyed Out I received a shared worksheet where certain features were unavailable (inserting being one of those). After saving and closing that spreadsheet and opening a new spreadsheet, the Insert Menu is still greyed out. I've looked under Tools and Protection but it doesn't give me an option to "Unprotect" so I'm not ... 2 Jun 2010 17:37
Source and Destination Hi, all, I would like a formula to do the following; SOURCE DESTINATION 101 102 102 C 105 102 108 104 105 S 106 107 108 S The source column A numbers run consecutively from 101-216. I just want any column B source cell that has a “C” or “S” to have it's 3 digit nu... 2 Jun 2010 16:30
Can I transpose data from rows to cols with a formula not pivot ta Hi All I have data listed in rows that I want to display in columns which will then be used in another program and I can't use a pivot table. Example: RefNo Area Item Units Price Value 1871459 Dealer2 CarA 40.560762 401.62989 16290.41438 1871459 Dealer1 CarB 0 2.934 0 1871459 Dealer4 CarY 0 1 0 187... 3 Jun 2010 17:55
CHOOSE function - more than 29 items Hi, Is there a way of using the CHOOSE function if you have more than 29 values? AND Is there a way of avoiding typing in all of the 29 (or more) values into the formula box? Thank you ... 2 Jun 2010 15:24
Simple hack to get $500 to your home. Simple hack to get $500 to your home at http://dailyupdatesonly.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. ... 2 Jun 2010 14:17 |