|
|
|
|
6 |
1,152 |
|
|
countif by
Jim W
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...
|
|
3 |
968 |
|
|
Multiple Subtotals in Excel Macro by
Ronnie
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...
|
June 2nd, 2010 11:13 PM
by Ronnie
|
0 |
1,101 |
|
|
|
|
1 |
881 |
|
|
Insert Menu Greyed Out by
SC-LS
I received a shared worksheet where certain features were unavailable
(inserting being one of those). After saving and closing that spreadsheet
and opening...
|
June 2nd, 2010 10:17 PM
by SC-LS
|
0 |
1,002 |
|
|
Matching like items by
Donna[_5_]
In columns “A-E” I have information about invoices
Column “D” is the invoice number ( invoice number would only be referenced
once and will not be...
|
|
2 |
904 |
|
|
Source and Destination by
Malcolm
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
|
June 2nd, 2010 09:20 PM
by Max
|
1 |
818 |
|
|
The last day by
Ron de Bruin
Hi all
Today is a sad day because tomorrow MS will close the Excel newsgroups.
I want to say that I hade a great time in the Excel groups the last...
( 1 2 3)
|
June 2nd, 2010 09:01 PM
by Billns
|
20 |
2,025 |
|
|
|
|
2 |
855 |
|
|
Timesheet in and out rounding by
Paula
Hi -- I have a basic timesheet in Excel 2003 - that has In and out with
in/out for meals - I want to know if there is away that I can round the times
only...
|
|
3 |
886 |
|
|
CHOOSE function - more than 29 items by
amanda
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...
|
|
1 |
807 |
|
|
Simple hack to get $500 to your home. by
KAJOL
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...
|
June 2nd, 2010 06:14 PM
by KAJOL
|
0 |
815 |
|
|
absolute reference fill by
jchick0909
i have 235 lines each linking to a cell in another tab. I need to make each
cell an absolute reference so i can copy them down again below and the same
cell...
|
|
1 |
676 |
|
|
concatenate will not paste special by
CBB
Hi
I am trying to concatenate first name and last name columns, all is good
till I copy and paste special.....It say copy and paste area is not the same...
|
|
3 |
753 |
|
|
Formula Help by
HeatherJ
I need a formula (will be in L2) to do the following--
IF G2 contains the text "bail" then L2 should be the contents of cells B2 G2
H2 separated by...
|
|
3 |
817 |
|
|
|
|
5 |
914 |
|
|
|
|
1 |
841 |
|
|
Summing a non continuous range by
fabio
Hi
From a previous post I was provided with a formula to provide a year to date
total from a table based on the month I entered in...
|
June 2nd, 2010 04:23 PM
by fabio
|
7 |
1,322 |
|
|
Summarizing Data by
cb
Hello,
I am working on summarizing data that was given to me in a format like:
Ref Num Group Score Category (below are in one cell)
205 AA 3 Asset,...
|
|
1 |
787 |
|
|
|
|
2 |
939 |