|
|
Formatting by
Alan
Hi,
Not sure if this is on the cards, but does anyone know of a Custom cell
format which will display blank if the value of the cell is zero and/or a
minus...
|
October 5th, 2004 03:42 AM
by RagDyer
|
2 |
156 |
|
|
|
March 5th, 2008 03:18 AM
by Alan
|
0 |
82 |
|
|
Sumif multiple criteria? by
Alan
ok, I am using sumif to add columns with particular names next to them, but I
am selecting the names from a dropdown list
A1 B1 C1 ...
|
|
3 |
101 |
|
|
Multiple Conditonal Comparison by
Alan
Hi,
I am wondering what the best way to do a multiple conditional comparison is?
For example I have 3 columns of data where I need the first column...
|
|
1 |
125 |
|
|
|
|
1 |
88 |
|
|
|
May 29th, 2009 02:46 AM
by Alan
|
2 |
129 |
|
|
|
September 24th, 2009 04:25 PM
by T. Valko
|
5 |
163 |
|
|
Column by
Alan
Apologies if there is a really obvious answer to this but it is driving me
mad! When you use the column() function you get the number of the column
(i.e....
|
|
4 |
196 |
|
|
|
|
4 |
121 |
|
|
"countifs" convert to formula in XL2002 by
Alan
Hi,
xl2007 formula "COUNTIFS" as following:-
=COUNTIFS('MTD Reach'!K:K,"0",'MTD Reach'!A:A,B12:B277)
*Criteria range 1 = 'MTD Reach' (Sales data)
*Criteria...
|
February 11th, 2008 10:01 AM
by Alan
|
2 |
100 |
|
|
Moveing Data to another Worksheet by
Alan
I hope I put this in the correct place.
Let's say I have a workbook that contains 2 Worksheets named "Worksheet 1"
and "Worksheet 2"
In "Worksheet 1" I have...
|
September 8th, 2005 11:46 PM
by Alan
|
2 |
89 |
|
|
|
|
1 |
195 |
|
|
COUNTIF ON 2 VARIABLES ?? by
Alan
Thanks for all the previous assistance... however I have now encountered
another couple of problems
Again back to my large spreadsheet issues ... I have...
|
|
4 |
114 |
|
|
AUTO HIDE ROWS by
Alan
Is there a method/function to auto hide rows dependent on the value of a cell
in that row ...
Ie cell B3 = 0 ...... hide row ??!
Many thanks again
Alan
|
|
1 |
199 |
|
|
Table References by
Alan
I have 3 Tables, i.e. T1, T2 and T3 defined as cell ranges with the same
number of rows/columns, different cell values. I want the user to select a
table,...
|
|
3 |
105 |
|
|
Formula or not? by
Alan
Hi,
Is there a formula to establish whether a cell contains a value or a
formula? What I mean is say A1 contained =10+20 so it shows 30 and it
contains a...
|
February 20th, 2005 03:26 PM
by Alan
|
2 |
107 |
|
|
Evaluating similarity of text strings by
Alan
Hi All,
I have a data list - roughly 2000 items in all, which are names
(people, companies, organisations etc) and an amount they have paid.
The data is...
|
March 30th, 2005 01:35 AM
by Alan
|
6 |
98 |
|
|
VLOOKUP Help by
Alan
I have a Workbook with multiple sheets.... On one sheet I have a unique
identifier which provides me with certain information and have acquired
another which...
( 1 2)
|
April 25th, 2005 02:57 PM
by bj
|
10 |
150 |
|
|
|
|
3 |
84 |
|
|
Product Formula by
Alan
Hi,
I have a column of quarterly returns which I wish to calculate longer term
returns from. My problem is that the list will continue to expand over time...
|
|
1 |
130 |