|
|
SUMIF, use List as a Range by
Emece
I have a list defined in a cell, using Data Validation.
In another cell I want to use the SUMIF function, and as a range use the
list selected in the cell...
|
April 21st, 2010 12:56 AM
by Emece
|
2 |
726 |
|
|
repeating number in a data by
james
hiii sir i am working in a excel with 10,000 number of data...... these are
the customers numbers and such time it will be repeated like that
First...
|
|
2 |
741 |
|
|
|
April 21st, 2010 02:41 AM
by JLatham
|
1 |
671 |
|
|
|
|
1 |
577 |
|
|
|
|
1 |
237 |
|
|
|
|
1 |
229 |
|
|
|
|
1 |
241 |
|
|
Calculating Sum Series by
deluth
Greetings,
I can't seem to find a formula to do series of sums. I would like to
calculate the following series:
For n = 0 to n=B1/B3
sum:...
|
|
1 |
229 |
|
|
Visible Shapes in a frame? by
Pas
Every time I exit design mode, the shapes in a frame disappear behind the
frame. Is there a way to stop that from happening?
|
April 21st, 2010 08:13 AM
by Pas
|
4 |
186 |
|
|
Search and Replace, or Add New Row by
GEdwards
I am using Excel 2003.
Worksheet1 contains columns
(A) Invoice
(B) Name
(C) Address
(D) P.O.# ... and others.
I need to perform a search of column A...
|
|
1 |
200 |
|
|
Unusual Date Format by
Grey Old Man[_2_]
I am writing an Excel 2002 template. I am importing two columns of dates
(date from and date to) from an external source. The date format is 'cyymmdd'
so...
|
|
0 |
190 |
|
|
Unusual Date Format by
Grey Old Man[_2_]
I am writing an Excel 2002 template. Two columns of dates (date from and date
to) are both imported from an external source. The date format is 'cyymmdd'
so...
|
|
1 |
211 |
|
|
|
|
0 |
176 |
|
|
Simple Yes/No drop down box by
Debi
Hi, I am looking to create a simple drop down box which has yes or no as the
options. For the life of me i can't remember how to do it.
Thanks
|
|
2 |
230 |
|
|
Seperate data by
JJ
I need help please. How do I go about to seperate data in one cell ex:
A1
1-------2-b0-40810
A2
2-----------1-03-0060
I typically want...
|
April 21st, 2010 10:01 AM
by JJ
|
5 |
263 |
|
|
hide columns before printing by
Jean-Paul De Winter
Hi,
Before actually printing my sheet I want to hide column A and B.
Can I do this automatically without having to hide them manually?
Thanks
--
Mvg.
|
|
6 |
316 |
|
|
using Sumproduct with named ranges by
Jenny S
Hi,
Hope someone can help.
I have named ranges in tab 1, Column E=B is for Branch, Column F=G is for
Game, & Column G=P is for points. Named ranges are...
|
|
1 |
234 |
|
|
Help with setting a "not found" statement by
Pierre
Hi.
I have a form that looks for a asset on a s/sheet list. What I need is a
statement that checks to see if the asset is on the list and if not, creates
a...
|
|
3 |
233 |
|
|
|
|
8 |
231 |
|
|
find and copy it.. by
reza
hi all...
hoping u can help me for saving my time.
i have a master data in sheet 1 with more than 1000 rows.
and now in sheet 2 i want to copy data from...
|
|
2 |
253 |