|
|
Columns WON'T highlight by
deidrefw83
When I click on the column heading the column doesn't look highlighted. It's
really annoying when I'm doing a find and cant see where it is due to it not...
|
March 24th, 2010 06:41 PM
by Bob I
|
1 |
103 |
|
|
Replace ; with , in functions by
Emece
When I use functions in Excel, arguments are differentiated by ;
For example =sumif(range;criteria;sum_range)
I want to use , instead of ;
Where can I...
|
|
1 |
115 |
|
|
|
March 24th, 2010 05:19 PM
by Billns
|
2 |
107 |
|
|
|
March 24th, 2010 05:18 PM
by stumac
|
3 |
157 |
|
|
Macro using a cell reference by
Jason Falzon[_2_]
I have an aplication called DPlot that can take commands from inside excel
using macros.
I managed to interact already with it using the following: -
Sub...
|
March 24th, 2010 05:16 PM
by Reg
|
3 |
120 |
|
|
IF and VLOOKUP by
ziak
Hello:
Here's my array:
A B C
1 Band Service Target
2 6 SAP 95%
3 7 SAP 96%
4 8 ...
|
March 24th, 2010 05:11 PM
by Eduardo
|
2 |
87 |
|
|
|
March 24th, 2010 05:02 PM
by Reg
|
3 |
136 |
|
|
|
March 24th, 2010 05:00 PM
by stumac
|
3 |
125 |
|
|
UDF's by
shane
I'm trying my hand in UDFs. In practice I created the following UDF in a
module
Function Area(Length As Double, Width As Double)
Area = Length *...
|
|
4 |
102 |
|
|
macro using cell value by
Jason Falzon
Hello,
I have an application called DPlot that can take commands from excel through
a macro.
I managed to pass information like so: -
Sub...
|
|
4 |
145 |
|
|
Count a cell in month format by
Mike Wheeler
Cell data:
15-Feb REG
22-Feb REG
8-Mar REG
15-Mar REG
15-Mar REG
29-Mar APIN
29-Mar REG
29-Mar REG
29-Mar REG
|
|
5 |
100 |
|
|
Using an action button. by
MichaelZ
How do I insert a button into a spreadsheet that will "clear" all values from
cells that are intended for inputting data, but not clear other cells that
are...
|
|
4 |
117 |
|
|
If Question by
Tango
Hi,
I have a column with times in it
11:28:46 AM
11:29:21 AM
11:29:50 AM
11:44:03 AM
11:44:10 AM
11:44:25 AM
|
|
2 |
99 |
|
|
Help in macro coding by
Sasikiran
Dear,
I am working on a macro which trims the raw data into a desired one.
i would require your help in adding the macro code to delete the entire row
if it...
|
|
3 |
121 |
|
|
|
March 24th, 2010 03:16 PM
by John
|
4 |
166 |
|
|
|
|
0 |
86 |
|
|
|
|
2 |
144 |
|
|
text value by
AllyH
I need to rank a column containing concatonated names and addresses. Ranking
only handles numeric values, is there any way to give text a numeric value?
|
March 24th, 2010 01:54 PM
by Mike H
|
1 |
121 |
|
|
Having Problems Excel 2003 by
BJ&theBear
I have been trying to rectify the anomalies in the data in a
spreadsheet that has become a mishmash of different Project and Task
codes in order to provide a...
|
|
3 |
125 |
|
|
Excel 'Back' Button by
Jen
Hi All,
I've got a webpage with a drop down menu which provides links to various
Excel And Word documents. It works extremely well with Word but when you...
|
March 24th, 2010 01:16 PM
by Jen
|
1 |
96 |