|
|
Toolbar question by
Jennifer H
I lost the ability in the toolbars to see the full function band. I.e
somewhere where I can type in the forumula. Which toolbar or setting allows
this to...
|
|
5 |
103 |
|
|
If and Vlookup by
Confused in AZ
I am trying to get a vllook up to be conditional if a certain criteria is
met. I have tried =IF('Raw Data'!B$2=AB,(VLOOKUP($A4,'Raw...
|
|
3 |
140 |
|
|
SUMPRODUCT with two valid criteria by
Lily
Hi, Thanks in advance for your help.
I am creating a calendar to see time availability from a huge table that
list the room, the date, the day, and the time....
|
|
1 |
111 |
|
|
Using DCOUNT by
Bob
I have two cells containing the DCOUNT function. In the first cell, I have
set the criteria to "Post-Phase 3". In the second cell, I have set the
criteria...
|
|
3 |
115 |
|
|
show pages on a pivot in 2007 by
terri
How do I do a "show pages" on a pivot table in Excel 2007??? I did it in
2003, but can't figure out how to do it in 2007.
Thanks!
|
|
1 |
103 |
|
|
sorting in Excel 2007 problem by
courtenaylambert
I've copied data from a list and pasted it into a pre-existing list in an
excel worksheet. I cannot get the two lists (the pasted one if just
underneath the...
|
|
1 |
103 |
|
|
Filter formula by
LiAD
Hi,
I am looking for a formula that can act as a filter.
In sheet AA I have a table with headings products, date, diameter etc
starting from col A.
I would...
|
|
8 |
177 |
|
|
Excel formula by
Mark
I need a formula that does the following:
Calculates how old I am when a birth date is entered. The formula needs to
use the calendar days not a fixed number...
|
March 26th, 2010 11:03 PM
by FSt1
|
2 |
88 |
|
|
Help with Value in one column... by
David M
If you have an ethnicity column I want to go to the next column and for all
of a certain ethnicity I want to return either a 1 or a zero.
Column A ...
|
|
3 |
95 |
|
|
|
|
1 |
94 |
|
|
Collating copier reports by
ChrisJ[_2_]
I have 13 copiers
Each produces a csv with an account ID column, a mono page count
column and a colour page count column, 6 times per year.
The account ID...
|
|
0 |
86 |
|
|
count values in a column, but. . . by
tree
First, apologies: My question must be answered in this and countless other
forums, but I can scarcely even begin to 'formulate' my question in search...
( 1 2)
|
|
12 |
231 |
|
|
|
|
1 |
185 |
|
|
|
|
3 |
100 |
|
|
|
|
2 |
127 |
|
|
|
|
1 |
131 |
|
|
How do I get functions added within EXCEL? by
cgretired
I am trying to use =HEX2DEC(cell) but keep getting the "NAME" error. I
believe it is because this is not listed in my available functions.
How can I get...
|
|
4 |
83 |
|
|
|
|
1 |
112 |
|
|
|
|
1 |
99 |
|
|
creating macros by
AL
I need to create a macros will a pull down menue for a selection. Then
questions will come up with room for answer.
Can someone help, please
|
March 26th, 2010 06:55 PM
by AL
|
0 |
83 |