|
|
Date by
Ginny
So simple, yet I can not seem to get this right. I need month/year only in
one cell.
Thanks.
|
January 26th, 2005 02:36 PM
by IC
|
1 |
105 |
|
|
Variable validation-password protect sheet by
Marty
I am using the Variable validation procedure(
DataValYesNoClear.xls) from:
http://www.contextures.com/excelfiles.html in my workbook
and it's working great....
|
January 26th, 2005 02:27 PM
by Marty
|
0 |
181 |
|
|
COUNTIF by
Gary T
Hi,
I want to count the number of entries in column A. Formula is to count all
cells that have data in them. Cells could theoretically contain a...
|
January 26th, 2005 02:21 PM
by Max
|
1 |
121 |
|
|
Is IF the best choice by
br0ke
I have the following list (which in real terms goes to 10 variables). I have
tried nested IF's but got nowhere. What is the best way of auto-completing
the...
|
January 26th, 2005 02:19 PM
by br0ke
|
2 |
108 |
|
|
|
January 26th, 2005 02:15 PM
by Max
|
1 |
152 |
|
|
Date format within a text syntex? by
Brw
I have two date fields that users enter dates into.
I have a field with the following formula where I want the dates to appear
within a preformatted...
|
|
2 |
105 |
|
|
|
|
1 |
90 |
|
|
How to : SUM - IF formula by
bruno
Can anybody help me out here ?=20
Maybe a little example to explain a bit ...
Let's say I have the following data...
|
January 26th, 2005 01:54 PM
by Bruno
|
2 |
101 |
|
|
|
|
0 |
219 |
|
|
Vlookup not returning correct value by
Mandy Brookes
We have a file which is updated monthly containing 'Vllookups' combined with
'IF, ISNA' formulae. This has worked successfully for many months but
suddenly...
|
|
1 |
189 |
|
|
vlookup data hidden within worksheet by
Hi,
Can anyone explain why it is that a vlookup table
automatically 'hides' itself within a worksheet that
utilizes the vlookup function but the vlookup table...
|
January 26th, 2005 12:09 PM
by
|
0 |
580 |
|
|
|
|
1 |
74 |
|
|
text and numbers by
sam
I have a text and number string that I use to link my excel worksheet to a
PLC for extracting values. The string is: =RSLinx|demo2!'gauge_offset_y',
where 0 is...
|
January 26th, 2005 11:05 AM
by sam
|
0 |
65 |
|
|
Multiple Work Sheets by
Daniell
I have a project that involves 6 worksheets all in the same workbook. What I
need to do is get data from all the worksheet by a part number which is
common...
|
|
4 |
248 |
|
|
Calculate time difference to the half hour by
Ken Ivins
I am creating an employee time sheet that the put in their starting time and
ending time (From a drop down list). I would like Excel to calculate the
amount of...
|
|
5 |
343 |
|
|
Does the cell have a number? by
Fletcher
I want a formula that will tell me if a given cell has a number in it, so it
evaluates the type of data. I looked in the help files and couldn't figure
this...
|
|
7 |
155 |
|
|
Lookup names to get data by
Ed Wesemann
I have two name and address lists. List A is the larger list (13,000 rows)
and has names and telephone numbers along with other data. List B is smaller
(5900...
|
|
1 |
72 |
|
|
|
|
1 |
203 |
|
|
Need a Macro by
denwah73
Would anyone have a macro (or suggestion) that can decipher which numbers in
a list will calculate to a specified total?
|
|
1 |
139 |
|
|
Custom Number Format... by
whitmore0112
I have a number/text that I want to apply a custom format to, but am not sure
if it is possible. The number/text starts as 12K52E1, and I would like to
apply...
|
|
2 |
170 |