|
|
Excell word formula by
Bobby
I want the information that is on the first 4 lines to be automatically
inputted on pages 2-6. Like a header\footer but not.
|
|
1 |
42 |
|
|
Concatenate Text... with spaces by
Leslie W.
I'm having a problem, and I don't know if there's a solution in the form of
an Excel function. I believe I could write a VB Macro to accomplish what I
need...
|
|
2 |
58 |
|
|
|
|
8 |
196 |
|
|
Vlookup limitation by
Indhu
I have 2290 characters in a cell and need to compare using Vlookup. It throws
#value error. Is there any limitation on the number of characters it can...
|
|
1 |
61 |
|
|
Function Values Not Refreshing by
Carlee
Hi there,
I have a complex function that sums or averages a series a values, based on
month. Occasionally, when i open the workbook and specifically, the...
|
|
3 |
138 |
|
|
timed events by
H1
Hi
I have a series of timed events (races to one hundreth of a second) that
need to be tracked by event (worksheet) then all total times for teams
averaged. ...
|
September 11th, 2008 01:54 PM
by H1
|
2 |
67 |
|
|
Text Formula Error by
Christopher Naveen[_2_]
Hi,
I use text formula and after saving the file using pastespecial to values I
can see a single quote (') in the blank cells. This is giving a problem to...
|
September 11th, 2008 01:54 PM
by Max
|
1 |
127 |
|
|
|
|
2 |
63 |
|
|
calculate difference between 2 dates by
nikko
Hi
I have a tracking spreadsheet that contains all the deals with the close
date change..
there's a close date old value in column A and a close date new...
( 1 2)
|
|
16 |
110 |
|
|
Colouring text in VLOOKUP formula by
Trevor Williams
Hi all, simple question (I think)...
I have a text cell made up of a vlookup and some other text. What I want to
do is colour the 'non-looked up' text a...
|
|
2 |
73 |
|
|
SUMIF nesting an AND function by
kraymond
Hi, I'm not exactly sure how to do this. I want to sum data in column c if it
meets two conditions, both in column a. For example, I have budget data in...
|
September 11th, 2008 07:16 AM
by Peggy
|
6 |
64 |
|
|
|
|
6 |
84 |
|
|
|
|
1 |
75 |
|
|
How to work with Many Worksheets by
chrisk
I have 31 worksheets in a workbook.
Each worksheet has col A the site and col B the person who went.
On worksheet 32 I would like to
count how many times...
|
September 11th, 2008 06:14 AM
by Peggy
|
3 |
71 |
|
|
|
|
1 |
73 |
|
|
Header or Footer - Reference a Cell by
enna49
Is it possible to reference a Cell in the Header or Footer. Maybe Code etc.
What I am trying to do is use the same worksheet every month. The date is...
|
|
5 |
68 |
|
|
Comparing lists of data by
Confused
Hi there,
I have a list of data in sheet 1. I have a second list of data in sheet 2,
which contains all of sheet 1 plus some new entries. I want to compare...
|
September 11th, 2008 03:58 AM
by Max
|
7 |
88 |
|
|
Vlookup help by
[email protected]
I need help in creating a vlookup formula that will search a single
column that automatically defines the range within the column to
lookup.
On one tab I have...
|
September 11th, 2008 03:57 AM
by T. Valko
|
2 |
69 |
|
|
Converting time into military time by
Michelle Bocchietti
Example
6:15 am
8:26 am
The answer that I am looking for is 2:18 worked. Can you give me a formula
for this problem
|
|
3 |
87 |
|
|
MIN Function with arguments by
Freshman
Dear experts,
In a worksheet, column A is for player's name and column B is for player's
scores. I list some examples below:
John 25
Peter 65
May ...
|
September 11th, 2008 02:50 AM
by Max
|
9 |
109 |