|
|
|
|
1 |
90 |
|
|
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 |
|
|
|
January 26th, 2005 03:15 PM
by Max
|
1 |
147 |
|
|
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 03:19 PM
by br0ke
|
2 |
108 |
|
|
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 03:21 PM
by Max
|
1 |
121 |
|
|
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 03:27 PM
by Marty
|
0 |
181 |
|
|
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 03:36 PM
by IC
|
1 |
105 |
|
|
Help with Complex SUMPRODUCT formula by
Murph
I need some help with a complex SUMPRODUCT Formula I have. I'm using 5
different columns in the formula to come up with the data I need. the first
column is...
|
January 26th, 2005 03:40 PM
by Domenic
|
5 |
190 |
|
|
|
January 26th, 2005 03:59 PM
by BJ
|
4 |
192 |
|
|
|
January 26th, 2005 04:03 PM
by Vicki
|
0 |
89 |
|
|
|
January 26th, 2005 04:07 PM
by fofanna
|
0 |
215 |
|
|
IF(ISNA formula problem by
Brad
I'm using the above formula to return a blank cell or a 0 if my vlookup
returns an N/A. Where this is a problem is that I have a...
|
January 26th, 2005 04:14 PM
by JulieD
|
7 |
136 |
|
|
Currency in cell ref by
gb_S49
I am using the following to consolodate the cell contents into one cell for a
chart label. My problem is
H2 data is numeric (no prob)
K2 is currency (£) and...
|
January 26th, 2005 04:17 PM
by Josh
|
3 |
105 |
|
|
index,match + 1 cell below? by
StevenL
if you are using the index/match combination function is it possible to index
the row below the result. In other words is it possible to take result...
|
January 26th, 2005 04:55 PM
by SteveT
|
4 |
100 |
|
|
Is VLOOKUP the right function? by
bay
Hello,
I am working on a worksheet with 3 columns. A with dates, B with invoice
numbers, C with names.
I'd like to put a function in cell D1 that looks up a...
|
|
3 |
107 |
|
|
|
January 26th, 2005 05:41 PM
by jlmam
|
2 |
225 |
|
|
'IF' FUNCTION for 2 columns by
Lisa
I have a list of reference numbers in column A, and a list of prices in
column B (Sheet 1).
In a separate sheet (Sheet 2) I have ref numbers and their price...
|
|
5 |
174 |
|
|
|
|
4 |
148 |
|
|
splitting and rejoining text in cells by
sh0t2bts
I have some data that I have pulled back from an SQL server that I need to
match but they clearly do not match in computer terms as A = B.
I have two columns...
|
|
3 |
91 |
|
|
Formatting Fields by
Naguib
Hi
I have a spreadsheet which has a number of formatted fields. Basically, it's
a list of numbers where each number is coloured a specific colour...
|
|
1 |
157 |