|
|
linking sheets to recognize words by
drea3128
I am trying to link sheets where if I change a cell under a certain name on
page 1 it will recognize the name on page 2 and change it in the correct
cell, is...
|
September 22nd, 2008 04:45 PM
by Pete_UK
|
1 |
140 |
|
|
Regional Language by
[email protected]
Hi
I can not write in my regional setting language in Visual Basic editor
in Excel, although I have Office language support, any help? I am
writing a module...
|
|
0 |
127 |
|
|
Filter every 25th record by
Tammy
Hi - does anyone know if there is a way to pull from a list of data in Excel
2007 every 25th record? In some cases it may every 10th record, or 50th...
|
|
3 |
107 |
|
|
function to add time totals over 24 hours by
mikesteven
I have a total column that gives me the difference of start time to end time.
It is formatted as 13:30 in excel. I need to now add all the totals. I used
to...
|
September 22nd, 2008 03:38 PM
by Barnabas
|
2 |
143 |
|
|
3 Flag Icon Set not computing correctly by
Melody
In an assignment for college, we used the 3 flag icon set to conditionally
format a column of revenues with $110,000 being the highest value. Any ideas
why...
|
September 22nd, 2008 03:15 PM
by Melody
|
2 |
132 |
|
|
Mark date that has passed by
Michaela
Hi!
I wonder if someone can help me finding the right function.
I have a worksheet over dates. The left columns contains dates (my input)
and the right...
|
September 22nd, 2008 02:31 PM
by Michaela
|
5 |
175 |
|
|
Need a Function by
akemeny
I currently have the following function calculating:
=IF(OR(AA7="",AD7""),"",TODAY()-(AA7+65))
AA7 and AD7 are date columns. The column they calculate in...
|
|
7 |
183 |
|
|
|
September 22nd, 2008 01:33 PM
by Mike H
|
8 |
173 |
|
|
Manipulating Text to create HLOOKUP by
CW
Hi, I get an HR report that lists in one column the dept # and in the next
the employee name... so there are multiple rows with the same dept#. I want
to...
|
|
8 |
413 |
|
|
|
|
2 |
178 |
|
|
Number in words. by
RAHUL
When I enter the formula i.e. =Bahttext it comes in different language i.e.
not come in English after changing the setting in control pannel.
e.g. if amount...
|
|
1 |
124 |
|
|
Conditional Formatting by
Eán[_2_]
Hi
Help please
I have entered the following formula into my conditional formatting boxes,
formula is:
C17,1
C17,2
C1=0,3
So that the cell would then be...
|
|
2 |
122 |
|
|
|
September 22nd, 2008 12:00 PM
by JP[_5_]
|
9 |
187 |
|
|
|
September 22nd, 2008 11:22 AM
by Dave
|
6 |
177 |
|
|
Random Sample by
Funkyfido
I have a list of data in excel. Is there anyway that excel can pick a randam
sample of say 20 entries?
|
September 22nd, 2008 11:09 AM
by Mike H
|
2 |
113 |
|
|
|
|
2 |
191 |
|
|
User Defined Functions by
CH
I occasionally mke user-defined functions in VBA. I am trying to write a
function using the LOG10() function and the FIXED() function and I get an
error for...
|
September 22nd, 2008 10:16 AM
by James.Z
|
4 |
115 |
|
|
advanced 'if' multiply by
spezticle
variables:
A = base pay rate
B = overtime pay rate
x1 = hours worked in pay period 1
x2 = hours worked in pay period 2
y = money earned
z1 = hours week 1 ...
|
|
3 |
100 |
|
|
Count Duplicate Numbers by
farid2001
Hello
I would really appreciate some help here.
I want to count duplicate numbers based on a time spam.
I've already got the duplicate dialed number Count...
|
September 22nd, 2008 08:04 AM
by Stefi
|
4 |
119 |
|
|
comparing 3 columns by
Ukiuki
How do I compare 3 columns? Need to know the data in all 3 columns are the
same.
|
September 22nd, 2008 08:01 AM
by Stefi
|
6 |
196 |