|
|
|
December 28th, 2009 12:54 PM
by Aldo
|
0 |
104 |
|
|
|
December 28th, 2009 12:45 PM
by Aldo
|
0 |
123 |
|
|
Suggestion by
Maarkr
=(SUM(I5:U5))+F5-(COUNTA(I5:U5)*15)
this gives me a plus/minus balance for a team roster in Col A, dates are in
the range, which is added if they paid money...
|
December 28th, 2009 12:38 PM
by Maarkr
|
2 |
144 |
|
|
Sorting or filtering the rows by
Amey
Do we have sorting for the rows same as for columns. If suppose I want to
hide the columns containing blank cells in a perticular row.can I do it or
can I...
|
|
1 |
148 |
|
|
|
|
2 |
123 |
|
|
Count unique values by
Natalie Lau
Hi
In my Excel worksheet there are two columns A & B. A contains the product
codes and B contains the customer codes. How can I count the number of UNIQUE...
|
|
5 |
125 |
|
|
Pivot table and value range by
Nicawette
Hi,
I have built a simple pivot table with 2 columns : Amounts and count
of amounts
eg:
amount/Nb of amount
100 /1
150 /5
|
|
2 |
122 |
|
|
Need formula to I have too many nested level by
Mike
=IF(O6=P6,P6*K6/J6,IF(O6P6,O6*K6/J6,IF(O6P6,P6*K6/J6+AQ6*K6/J6*1.5,IF(U6=V6,V6*K6/J6,IF(U6V6,U6*K6/J6,IF(U6V6,U6*K6/J6+AU6*K6/J6*1.5,IF(aa6=ab6,ab6*K6/J6,IF...
|
|
3 |
209 |
|
|
excel by
Mark vw
can excel 2007 be used to make a invoicing system that will increment and
save each invoice.
|
December 28th, 2009 06:53 AM
by FloMM2
|
2 |
175 |
|
|
|
December 28th, 2009 05:15 AM
by rontiara
|
3 |
124 |
|
|
to use data validation or not by
tabylee via OfficeKB.com
hi,
I am making a church donation file in Excel.
We have now about a hundred plus donors. The number of new donors are still
increasing. At present, I am...
|
|
2 |
122 |
|
|
|
|
2 |
177 |
|
|
VBA custom toolbar by
donwb
In my system, I have an Excel 2003 custom toolbar saved in a file called
Excel11.xlb.
I have also created a custom toolbar in VBA.
Can anyone tell me where it...
|
December 28th, 2009 01:15 AM
by donwb
|
0 |
139 |
|
|
Insert rows and fill formulas by
Chris
I have just added this on a work sheet. It works OK when sheet is unprotected
but when I protect the sheet it comes up error 400. If I select Insert row on...
|
December 27th, 2009 11:03 PM
by Chris
|
3 |
141 |
|
|
|
|
2 |
120 |
|
|
Convert 3 columns into 1, as text. by
Dale G[_2_]
Hi,
I need to convert 3 columns into 1, as text.
Column C has a direction, North or South, Column D has a route number, 535,
510, 511, and Column E has and...
|
|
3 |
142 |
|
|
|
|
7 |
160 |
|
|
|
|
2 |
120 |
|
|
counting entries by
mexmex
I have a list of names in a column and want to show the total number of
entries in the column at the bottom.
--
Max
|
|
2 |
111 |
|
|
Highest value cell and ajacent cells by
Gilbo
Hi,
What I want to do is find the top 3 highest scores with
(Large(P3:p95,row(A1)) and then get the ajacent values from row (O) and row
(R)
|
December 27th, 2009 01:49 PM
by Bernd P
|
3 |
176 |