|
|
table of value ranges by
$cruncher
What function can I use to analyze the numerical data in a spreadsheet and
create a table of values? Such as x no of items within value range $0 to
$600, x...
|
February 22nd, 2008 09:48 PM
by T. Valko
|
2 |
72 |
|
|
Counting results from a lookup by
&e7
I have a spreadsheet of data which I need to analyse results from.
Two of the columns, 'severity' and 'priority' contain string values
relating to the...
|
July 29th, 2009 12:46 PM
by &e7
|
1 |
94 |
|
|
How can I get the Analysis Toolpak by
'cole
In excell I need to get the add-in called analysis toolpack, but I don't have
the CD (it's the schools) and I was wondering if there is any other way...
|
|
1 |
156 |
|
|
|
|
1 |
170 |
|
|
|
|
3 |
100 |
|
|
|
February 6th, 2009 10:45 PM
by Max
|
11 |
163 |
|
|
Formula by
** Kris **
I don't know too much about formulas, but need a formula
to look at a column of numbers and give me the number that
repeated most often, and how many times it...
|
September 17th, 2004 08:41 PM
by Patti
|
1 |
113 |
|
|
A change in date will reschedule all other dates by
*** In need of your expertise*****
Am doing a planning file wherein dates may change. How do I make a simple
insert function wherein when I change one date then the rest of the dates
will...
|
|
1 |
108 |
|
|
|
|
1 |
74 |
|
|
Auto size a pivot table to a page size by
*.*
Driven mad by having to resize pivot tables constantly, printing and
reprinting to ensure they fit to a page and are readable. There needs to be
some way of...
|
|
1 |
60 |
|
|
|
September 30th, 2004 09:27 PM
by *Amber*
|
0 |
277 |
|
|
Grabbing data from a specific cell by
*Kenneth*
Hello all, I’m trying to get Excel to grab data from a specific cell on an
external spreadsheet through a pastlink and populate that data to 2nd...
|
|
2 |
88 |
|
|
relative formulas by
*Scott
Is there a way to copy a formula so it stays relative to a
cell on the preceeding worksheet. I need to have about 75
tabs that carry over totals from the...
|
|
4 |
238 |
|
|
$ for VLOOKUP functions by
*Suzannah*
Hi :) can someone please tell me why the dollar sign ($) is necessary in the
VLOOKUP function?
|
|
3 |
63 |
|
|
Vlookup question by
*zot*
I'm using VLOOKUP to pull a value from a range if the number in C33 finds a
match within that range. Here's the...
|
|
2 |
60 |
|
|
Poor humaneyes by
*«Ë²´*
We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.
|
August 23rd, 2007 06:25 AM
by *«Ë²´*
|
0 |
46 |
|
|
Poor humaneyes by
*«Ë²´*
We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.
|
August 23rd, 2007 05:08 AM
by *«Ë²´*
|
0 |
41 |
|
|
Poor humaneyes by
*«Ë²´*
We had the same experiences with bad quality humaneyes. No after sell services, it's really sucks.
|
August 23rd, 2007 05:08 AM
by *«Ë²´*
|
0 |
40 |
|
|
Choose date from drop-down calendar by
+alcheme
I'm creating a few different expense report and time card worksheets. I'd
like to be able to choose a date from a drop-down calendar (i.e. easy access
to...
|
|
1 |
49 |
|
|
Large Function by
,
I have a spreadsheet with something similar to item below. I need to be
able to find the oldest (largest) item for each person. Any and all
help is...
|
|
1 |
84 |