|
|
For Mr. RagDyer please by
ytayta555
Mr . RagDyer ,
please very much to allow me to send you
an mail , I need strong to speak with you , if I'm not impolite ...
My g-mail is ...
|
July 31st, 2008 05:11 PM
by RagDyeR
|
1 |
60 |
|
|
Add days to a date, but exclude holidays by
Chickadee
I have a set date to which I need to add a number of days, but holidays
should not be counted. The cells of one of the columns in my spreadsheet
holds the...
( 1 2)
|
|
13 |
154 |
|
|
|
July 31st, 2008 04:14 PM
by Cheryl
|
4 |
71 |
|
|
Pivot Table Calculations by
Neanderthal
I need to calculate the Percentile of the data fields of a PivotTable in
Excel. My PivotTable is constructed from columns called Region, Category,
Month and...
|
|
0 |
81 |
|
|
Cell offset issue by
MGarrison
HI,
I am trying to have a row that references cells that are moving 1 down and 1
over. I want to caputure the last number in each column.
Example
A1 ...
|
|
3 |
75 |
|
|
Rounding Time. by
GEM
How can I round time UP to the nearest 5 min. I need to have the report in
numbers divisible by 5 and the time should always go up. 1:30, 1:35, 1:40,...
|
|
7 |
109 |
|
|
Excel PERCENTRANK help by
Erica.DC
Hi!
I need help with the PERCENTRANK excel function for my data set....
I have a data set of several physical abilities tasks, such as pushups,
situps,...
|
|
3 |
69 |
|
|
Pick from a list by
Geoffric
--
Geoff
"Alicia" wrote:
I have created a list on a worksheet of 5 products. I want to create a drop
down list in several fields that references this...
|
|
0 |
79 |
|
|
Sum Time. by
GEM
If I enter in A1 "1:10" and on A2 "1:20" and try to sum those two together,
it won't give me an answer. How can I format the cells so that A3 can give me
the...
( 1 2)
|
July 31st, 2008 03:11 PM
by GEM
|
10 |
130 |
|
|
Complex cost allocation formula by
vsoler
Hello everyone,
I am faced to an accounting problem that has emerged at the time of
the 2009 budgeting process.
I prepare the yearly budget in an Excel table...
|
|
1 |
79 |
|
|
Conditionnal Formatting by
Excel Dubai[_2_]
Hi,
I have a sheet with 3 columns.
A is the list of 2500 references
B is the list of 6500 lot numbers
C is the quantity per lot per reference
I would like to...
|
|
3 |
66 |
|
|
|
|
5 |
59 |
|
|
vlookup by
sabrina
Can I fix the range of table array, so when I copy and paste vlookup formula,
the table array can be kept in an original range.
|
July 31st, 2008 02:19 PM
by Pete_UK
|
1 |
56 |
|
|
VBA code to hide blank rows by
ub
Hi
The data in my sheet is in the below mentioned format.
Column B
1 Blank
2 Blank
3 Blank
4 Blank
5 Total
6 2
|
July 31st, 2008 01:44 PM
by Stingz
|
4 |
80 |
|
|
Rolling Monthly Average by
Colin Hayes
HI
I have a puzzle - I wonder if anyone can assist.
In cells D4,D6,D8,D12,D14 and D16 in have formula-based totals for the
first 6 months of the year. In...
|
|
5 |
130 |
|
|
Sumproduct calculation for January 09 by
Tina
=SUMPRODUCT(--(MONTH('2008'!B3:B2000)=1),--(YEAR(B3:B2000)=2009))
Hi all, I am using the above, but am getting #VALUE!
The format the date is typed in, in...
|
|
5 |
70 |
|
|
Summing Problem In A Pivot Table by
Mike
I have a very simple pivot table. However I am having a problem with one
particular cell within the pivot table. The content of this one cell should
be zero....
|
|
1 |
83 |
|
|
|
July 31st, 2008 11:40 AM
by Pete_UK
|
1 |
118 |
|
|
Filtered Data-Linking by
mzle22
I am working with a form that was created in Excel. Currently the data is
manually entered into the form from a master Excel file. I only enter data
into the...
|
July 31st, 2008 09:31 AM
by Pete_UK
|
3 |
53 |
|
|
|
|
1 |
66 |