|
|
Pivot Table - Average of counts by
Dan in NY
Reposting...
I have a table with 3 columns of text where column A maps to multiple values
in col B which maps to multiple values in col C.
e.g.
X Y Z
X ...
|
|
0 |
194 |
|
|
|
March 9th, 2006 07:38 PM
by Carroll
|
3 |
194 |
|
|
|
|
6 |
194 |
|
|
One column with various widths by
RichardGolf72
Can I have get column A - F rows 1 -30 be a certain width then have column A
- F rows 31 -60 bedifferent widths?
|
|
2 |
194 |
|
|
|
June 14th, 2006 09:29 PM
by Biff
|
11 |
194 |
|
|
|
|
4 |
194 |
|
|
|
May 27th, 2007 03:35 PM
by Paul
|
0 |
194 |
|
|
VLOOKUP does not work with array formula by
axb
I am using VLOOKUP as part of a SUM array formula like this:
{=SUM(VLOOKUP(A9:A10,COLORTABLE,2,FALSE))}
I was expecting that this would lookup the value...
|
|
1 |
194 |
|
|
Lookup and offset at the same time? by
TedT
Hi,
I am not sure how to accomplish this task.
I have multiple columns of data. I am locating a value in a column (F) on
the right using vlookup to find the...
|
March 25th, 2008 04:15 AM
by Max
|
9 |
194 |
|
|
|
|
5 |
194 |
|
|
Add protect worksheet password in macro by
Kelly
I created 43 sets of workbooks that need to be locked and protected from end
users. I have created a macro that will clear the previos days numbers and
copies...
|
January 10th, 2006 02:08 AM
by Paul B
|
1 |
194 |
|
|
How can perform a summation? by
Leebo
Is there a way to perform a summation expression in Excel?
For example, I need to sum 1 + 2 + 3 + 4 + 5. I can easily type 1
through 5 in five cells and use...
|
August 23rd, 2005 04:38 PM
by RagDyeR
|
5 |
194 |
|
|
Excel Idiot Needs Formula Help!! by
Donna123
I posted earlier as a Novice, but have since reduced myself to idiot
status. Working on our budget for 2006, which up to now is largely a
manual process. We...
|
September 5th, 2005 05:28 AM
by peto
|
1 |
194 |
|
|
|
|
5 |
194 |
|
|
|
October 5th, 2005 05:55 PM
by Frank3
|
2 |
194 |
|
|
|
October 14th, 2005 07:48 AM
by Biff
|
3 |
194 |
|
|
Editing an existing formula by
Jen
I have a small but frustrating problem with an excel formula. I have a
formula that is adding a bunch of cells (cells are not in a range). The
original...
|
October 24th, 2005 07:55 PM
by Biff
|
1 |
194 |
|
|
|
November 12th, 2005 12:19 AM
by Max
|
11 |
194 |
|
|
How do I enter formula for or numbers. by
Betty P.
I am trying to enter a formula in a worksheet. I want the formula to do the
following: IF A1=40 then enter 1, if less that 40 enter 0, OR IF A1=45 enter
2,...
|
November 27th, 2005 06:25 PM
by Betty P.
|
7 |
194 |
|
|
Lookup Formula not working completely by
Newsgal
=LOOKUP(M11,{0,0.98,1},{0,"$750.00","$1000.00"})
This formula works fine if M11=100+%. However, it's not working when M11 =
98%.
Help!
--
News Gal
|
April 23rd, 2008 12:27 AM
by Max
|
9 |
194 |