|
|
|
October 13th, 2009 05:02 PM
by Bob I
|
1 |
168 |
|
|
|
|
5 |
112 |
|
|
Defined Range Names in formulas by
Darby
I am using Excel 2007 and am trying to reference defined name ranges in a
sumproduct formula. When I use the names the formula returns #N/A but when I...
|
October 13th, 2009 04:41 PM
by Luke M
|
2 |
105 |
|
|
applying date filter in MSQuery by
kas
Hi! Can someone help me apply a criteria to an MSQuery? I want to select
same dd/mm records but for any year and can't figure out which operator to
use and...
|
|
1 |
109 |
|
|
Formulas in drop boxes by
Saddler
Hi there I am new to the community, but I hope to ask questions here often! I
have one problem with Excel that has stumped me for sometime now. Every time
I...
|
October 13th, 2009 04:15 PM
by Bob I
|
4 |
84 |
|
|
|
|
1 |
150 |
|
|
COUNTIF doesn't work by
KenH
I want col. "E" to count how often col "C" =24hrs for each of the 12 months
A B C D
...
( 1 2)
|
October 13th, 2009 03:52 PM
by KenH
|
12 |
166 |
|
|
Percentage of Money by
Glenn
Hi,
I have a sell which is in currency form
A1= £200
I also have a cell showing a percentage
B2= 2.24%
I need a formula in Cell B3 that calculate 2.24% of...
|
|
2 |
135 |
|
|
Finding Data by
Mike
Not sure if this is possible or not. Excel 2003. No VBA experience. B4:IS4
has daily production output numbers. I am using a formula like...
|
October 13th, 2009 03:24 PM
by Mike
|
2 |
118 |
|
|
|
|
14 |
177 |
|
|
Convert number to date value by
saz2369
I have a number which was inputted as a date but came out as a number
(1080022) I need to convert back to a date but can't figure out how to change
it (...
|
October 13th, 2009 03:10 PM
by Luke M
|
8 |
126 |
|
|
how to change multiplier using letters by
april
i saw this post sometime ago and cut it out for future use. yesterday i was
trying to test it out and the lookup solution doesn't work if B1 is blank.
it...
|
|
3 |
113 |
|
|
|
|
1 |
148 |
|
|
Using text values in Pivot Tables by
Eric
I am creating a simple pivot table with one field of values, numbers to be
summed, and a second field, occasional two letter alpha codes which are...
|
|
5 |
98 |
|
|
|
|
7 |
116 |
|
|
Conditional Format by
Ed Davis[_2_]
Is there a way to conditional format a cell that does not have a formula.
It does not matter what the formula is as long as it does not have one.
I allow users...
|
|
9 |
148 |
|
|
mailmerg by
Arshad Munir
I want to enter the Acces date with all respects in Excel Spread sheet.
|
October 13th, 2009 02:48 PM
by Bob I
|
1 |
99 |
|
|
Drop down box by
Glenn
I want cell A1 to be a drop down list that the user can select one from the
list.
In the list I want the following
East Midlands
Midlands
Sussex
How do I do...
|
October 13th, 2009 02:39 PM
by Luke M
|
2 |
116 |
|
|
|
|
2 |
135 |
|
|
Lookup by
Glenn
Hi,
I have a table below.
A B C D
1 East Midlands 90% 20%
2 ...
|
October 13th, 2009 02:27 PM
by Stefi
|
2 |
107 |