|
|
Percentile Analysis Across 2 Columns by
BRob[_2_]
I'm wanting to calculate decile (or equivalent percentile) salaries to see
if there is any difference between 2 departments (A and B).
So dummy data looks...
|
|
5 |
78 |
|
|
|
|
1 |
93 |
|
|
duplicate dates by
db
In a worksheet with multiple columns of dates, how can I identify any
duplicate dates , if any, among columns. many thanks
--
db
|
|
2 |
60 |
|
|
Conditional averaging gives wrong result by
BRob[_2_]
I've got a problem in a spreadsheet which, if I simplify down to its most
basic is as follows.
In the table below, the average value of column B where the...
|
|
3 |
74 |
|
|
|
|
5 |
90 |
|
|
Problem with Copying a Simple formula by
cware
I cannot believe that I can't figure this out, but...
I have a SIMPLE formula in cell G5, that simply states =f5-e5 (simple
difference)
I'm copying...
|
September 4th, 2008 03:14 PM
by cware
|
3 |
90 |
|
|
Compare column in 2 documents by
Amiranda
I have two documents: one with a sendlist, one with a directory of names and
addresses. In the sendlist I have about 1200 posts, and in the directory
about...
|
September 4th, 2008 03:05 PM
by Amiranda
|
2 |
97 |
|
|
|
|
3 |
101 |
|
|
Conditional formatting by
harwookf
I have a spreadsheet with lots of formulas and conditional formatting.
Currently If the cell is less than or equal to the cell above, the
conditional format...
|
September 4th, 2008 02:30 PM
by harwookf
|
1 |
76 |
|
|
|
September 4th, 2008 02:04 PM
by JMiller
|
1 |
91 |
|
|
XIRR #NAME? error - Toolpak IS installed by
Thinqer
Hi there,
I've discovered a worrying problem in a large model I'm building at the
moment.
I've used the XIRR function in the model without issue up until...
|
September 4th, 2008 12:11 PM
by Thinqer
|
1 |
83 |
|
|
|
September 4th, 2008 12:03 PM
by Marc T
|
2 |
83 |
|
|
Random help please by
Terry
Hi
I wish to use my ipaq (Excel mobile) for creating random numbers for a bingo
game on a coach trip, instead of a cumbersome set of discs/balls etc.
Numbers...
|
September 4th, 2008 11:35 AM
by Pete_UK
|
4 |
67 |
|
|
DCOUNT Question by
Alexander
Hi
An easy question for someone who knows a bit about the dcount formula.
I really need some help with dcount or a similar function that can do this:
I...
|
|
0 |
69 |
|
|
Help with Formula by
Yitzhack
Hello all –
Please help!!! I can’t make this work. I need a formula in cell H9 where if
cell F9=WFM add 30 days to date in G9, if WFM1, WFM2, or WFM3 in...
|
September 4th, 2008 09:26 AM
by Pete_UK
|
5 |
98 |
|
|
|
|
2 |
72 |
|
|
countifs Text and Dates by
mokihi
Hi there
I want to count how many "Level 1" cells that are older than "3/9/08". My
columns and rows look like this:
A B
Level 1 ...
|
September 4th, 2008 05:30 AM
by Max
|
7 |
52 |
|
|
|
September 4th, 2008 04:59 AM
by MarkFred
|
2 |
59 |
|
|
Data Entry with forms by
rookie
I have a data entry form that has name/address and other information for a
selected producer. It is linked to several sheets with fillable forms. Each
year...
|
|
1 |
61 |
|
|
|
|
12 |
191 |