|
|
|
July 8th, 2008 10:09 AM
by Dennis
|
1 |
109 |
|
|
Random numbers from several ranges by
ChrisSafety
How can I set up one formula to randomly give me a number from multiple
ranges? For example, I have 2 ranges. One is 105 though 128 and the other is
244...
|
|
3 |
82 |
|
|
|
|
1 |
76 |
|
|
|
|
8 |
85 |
|
|
|
|
1 |
104 |
|
|
Adding multiple cell totals by
D
I would like to make a short spread sheet that would for example, start with
a number i.e. 1000 add to that X % then subtract N%. Then carry down 20 or so...
|
July 8th, 2008 03:16 AM
by D
|
2 |
119 |
|
|
Pivot tables by
Farid
Hi I have one pivot table, source data sheet is not available. it has
Page filter month
Customer ID fields + Sales amount + total sales + % sales to total
in...
|
|
3 |
87 |
|
|
comparing data in different rows by
Daniel
i'm working on a long (approx 5000 lines) data sheet and i have a different
list containing erroneous values that relate to a particular row in the 1st
data...
|
July 8th, 2008 12:54 AM
by Max
|
4 |
85 |
|
|
vlookup MAYBE??? by
lost and confused in excel-land
I don't know if this can be done or not.... I have one cell B4 that is a
dropdown list through data validation. Then another cell, A15, that looks at
B4 and...
|
July 8th, 2008 12:47 AM
by Max
|
3 |
110 |
|
|
|
July 8th, 2008 12:32 AM
by Max
|
6 |
141 |
|
|
|
|
4 |
67 |
|
|
DSUM Criteria - find exact match only by
Sandy
Hello -
I am working in Excel 2007 and am having trouble limiting the values for the
criteria to an exact match only. The function is summing all criteria...
|
|
1 |
167 |
|
|
|
|
1 |
86 |
|
|
formula ending with a letter by
Cynthia
I have a formula to enter ending with the letter C. However, Excel will not
accept this type of formula.
I need help with this because I am working on...
|
|
3 |
86 |
|
|
|
|
1 |
93 |
|
|
Countif w/semicolon separated values by
crazymfr
I have aggregated data in columns that were imported from web forms and are
separated by semicolons. The questions was select your preferred day of week...
|
|
4 |
96 |
|
|
|
|
2 |
101 |
|
|
countif from different worksheets by
BeefDr
I keep daily attendance and grades in a workbook. Each worksheet has a date
as its tab. Worksheets are formatted identically with Student names,...
|
July 7th, 2008 09:53 PM
by BeefDr
|
2 |
110 |
|
|
Summing across multiple worksheets by
HL
I have the worksheets with the following column headings:
Name Acct1 Acct2 Acct3
The rows are listed for each week:
1/6/08
1/13/08
1/20/08
1/27/08
The...
|
|
3 |
97 |
|
|
combine or if by
littlelouise1
I need to check for three (or more conditions) and need a different value
returned for each criteria.
For example:
DATA Wanted result:
1 ...
|
|
4 |
59 |