|
|
Copy updating column to another workbook by
Marysam67
Hi,
I would like to copy a column that updates to another workbook. If the
field is blank I will like it to copy over as blank.
data is on trust...
|
|
1 |
104 |
|
|
|
June 10th, 2009 12:21 AM
by John
|
1 |
170 |
|
|
Finding Repeated Words by
Té
Is there a way to find repeated words in a spreadsheet, as well as how many
times the word is repeated besides using the COUNTA function? I was thinking
of...
|
June 9th, 2009 10:54 PM
by Té
|
4 |
147 |
|
|
|
|
5 |
130 |
|
|
Cell formular by
Ron H[_2_]
I am trying to write a formular in a cell whereby if the value of an ajoining
cell is between 2 and 5, then enter 50. If the value is not between 2 and 5...
|
|
2 |
134 |
|
|
Median in pivot tables by
SB Lee[_2_]
By using pivot tables, I am showing statistical data for base pay for several
hundred different jobs and need to add statistics for the median. How can i...
|
|
5 |
182 |
|
|
|
June 9th, 2009 06:01 PM
by Steve
|
0 |
113 |
|
|
protecing hidden columns by
How do I protect only hidden columns?
I need to hide certain columns from users that open my worksheet. I can
protect the worksheet as a read-only with password to modify but that does
not...
|
|
2 |
93 |
|
|
|
|
4 |
183 |
|
|
Extract numbers from a code by
Mark
Is it possible to extract by formula numbers from a code, for example
Code Number
AS12345WQ 12345
F87654321LD 87654321
HN123 123
I want to be able to...
|
|
3 |
130 |
|
|
If formula by
Cassius
I have cells where I am trying to eliminate text after the dash, but it gives
me errors if the cells does not contain a dash. How can I have it just give
me...
|
|
5 |
60 |
|
|
Determine last cell in a row by
sutha
I am a new user. Please help with the following
How can I reference the last cell updated with numbers in a raw?
example colum a b c d e f are days on raw...
|
|
1 |
110 |
|
|
Format text color by
John
I have a formula in a cell...if(A14A15,"Missed","Made) & "FSP"
How do I get the text color of Missed to be red, Made to be blue and keep
the text FSP...
|
|
4 |
128 |
|
|
|
June 9th, 2009 03:11 PM
by Max
|
5 |
99 |
|
|
Removing text from cells by
don wonnell
Have Excel 2002, want to remove text from cells and leave the numerical data
in those cells intact. Don't see a method for this in worksheet functions...
|
|
4 |
89 |
|
|
GETPIVOTDATA Question by
king60611
I'm trying to reference pivot table cells in another worksheet; a direct cell
reference doesn't work because the data is ever-changing. I figured out the...
|
|
3 |
104 |
|
|
|
|
4 |
128 |
|
|
|
June 9th, 2009 01:57 PM
by Max
|
4 |
112 |
|
|
|
|
2 |
106 |
|
|
|
|
17 |
275 |