|
|
|
June 8th, 2009 04:22 PM
by Neall
|
9 |
195 |
|
|
Merging cells in a Protected Sheet by
Protect Sheet but be able to merge cells[_2_]
Does anyone know how to Merge cells once you have protected a sheet? There is
the option to 'allow users to format cells', but for some reason it will not...
|
|
3 |
261 |
|
|
SUM Condition by
Adam Bradley
I have collumn A as referece numbers such as 0535 which relate to several
values in collumn D eg.
0535 £235
0535 £82
0535 ...
|
|
4 |
113 |
|
|
Date calculation by
tonyalt3
I would like to calculate how many months it has been from one cell to
another. Example: cell a1 has 1/5/2009 and cell b1 has 5/17/2009. Is
there a function...
|
|
5 |
139 |
|
|
ComboBox by
Chris
I am using a ComboBox for a drop list. How can I increase rows in the box
because i can only get it to show 121 rows?
--
Chris
|
June 8th, 2009 03:22 PM
by Chris
|
3 |
123 |
|
|
|
|
5 |
194 |
|
|
update data from internet by
willemeulen[_30_]
Is it possible to retrieve values from a internet site. In particular I
am
looking at a price list which is changing regularly.:Bgr
Thanks,
W
--
|
|
2 |
143 |
|
|
INSERTAR FUNCION MES by
teto
Hola q tal, como puedo hacer para que en una casilla desplegable eligiendo un
mes me situe ordenadamente los dias y numeros del mes??
|
|
1 |
154 |
|
|
If Function by
Bushy
I keep getting the wrong result when I use =IF(G20=+-H20,"OK","PROBLEM"). I
know the result should be "Problem" due to G20 being less than H20
--
Bushy
|
|
3 |
106 |
|
|
Pointing Finger Mouse by
Gaffnr
Hi,
Very odd but on a spreadhseet that I have been using fora year, when I go to
row 1 (my header row) the mouse pointer turns into a pointing finger. I cant...
|
|
1 |
104 |
|
|
Autofilter Hides All... by
TomCat
I have a column that contains number/letter format 100ABC, 101DEF, etc. When
I do a custom filter to show all the cells that contain 100, etc., the entire...
|
|
1 |
95 |
|
|
Countif left and alphanumberical data by
Onyx
I'm wanted to build a formula that will do the following,
CountIF(Column begins with array) I can't see to get the function to work.
Reallife example
Count...
|
|
4 |
106 |
|
|
Calculating a date by
Jafferi[_2_]
Cell A1 ~ Jan 1, 2009
Cell B1 ~
Basically, I want the cell to acknowledged that a day is equal to 8 hours.
Can you help to figure out how can I do...
|
|
2 |
79 |
|
|
AutoFilter: custom filter hides all by
TomCat
I have a column that contains number/letter format 100ABC, 101DEF, etc. When
I do a custom filter to show all the cells that contain 100, etc., the entire...
|
|
4 |
75 |
|
|
count if by
newbie_010108
hi im using excel 2003. How would i count the number of "Lates" for each
individual. here is my data:
sheet1:
name Attendance
karen late
bryan ...
|
|
5 |
98 |
|
|
Time Span calculations by
Jafferi[_2_]
Cell A1 ~ 09:00 (Plan arrival time)
Cell A2 ~ 09:15 (Actual Arrival Time)
Cell A3 ~ 0:15 (Late by 15Min)
The above tells the timing for arriving to work and...
|
|
4 |
104 |
|
|
|
|
3 |
84 |
|
|
Excel 2007 - Multiple If Then or Lookup by
SpecialK
I'm trying to check cells K5 or K6 or K7 or K8 or K9 for the presence of the
letter "x" and if "True" to multiply cell H5 by the appropriate percentage
and...
|
|
7 |
102 |
|
|
|
|
2 |
94 |
|
|
How to retrieve Named Range name? by
Guntars
Hello,
Is there a way to retrieve range name if value is in the range?
For example I got this column wit names:
name 1
name 2
name 3
name 4
name 5
name 6
name 7
|
|
3 |
106 |