|
|
Macro/Formula help by
fgwiii
Hello,
I am trying to run the following code as part of a macro and for some reason
after I added additional entries to the ActiveCell.FormulaR1C1 = "=OR ...
|
June 19th, 2009 05:54 PM
by Luke M
|
5 |
140 |
|
|
Looking up values in multiple rows by
MeMe
Hi there,
I need to have a vlookup or something that works across rows.
For example, I have column A representing time, with A1 through to Axxxx
with each...
( 1 2)
|
June 19th, 2009 05:33 PM
by Neecy
|
11 |
270 |
|
|
Count, Sum, and Filter by Color by
Khalil
Dear Experts;
My data is consist around 100 row, most them highlited with different colors;
I need to do the following; Please help me
1.. Count by...
|
|
3 |
171 |
|
|
Insert cells function by
Tom Haskell
When I attempt to insert a cell or group of cells the radio buttons to shift
cell(s) right or down are grayed out. What is causing this?
--
Thanks!
|
|
3 |
144 |
|
|
|
|
2 |
187 |
|
|
Filters by
Muskrat24
I am using a filter to display rows with a "X" in column J. Some of the rows
I always want to show,such as category titles, kinda like a default template....
|
|
3 |
109 |
|
|
Conditional Formatting by
Philip Drury
I want to change the colour of cells A1:G1 if the value of G1 is K (make the
row green), U (make the row amber) or S (make the row red). Really want this
to...
|
|
3 |
156 |
|
|
|
|
2 |
308 |
|
|
COUNTIF calculates slow (10000+ records) by
VidarHe
Hi,
We have a printer repair log where we count the number of times the printer
has been in based on the serial number. But we have 1000+ log entries and...
|
June 19th, 2009 01:16 PM
by VidarHe
|
4 |
233 |
|
|
|
|
2 |
125 |
|
|
|
|
4 |
162 |
|
|
Data Validation Q by
Seanie
I have the Data Validation detailed below, it does a couple of things
for me, but how can I add an additional validation that will disallow
the input of the...
|
|
9 |
121 |
|
|
|
|
1 |
104 |
|
|
Excel 2003 worksheet by
Denver
Hi,
I have an excel 2003 worksheet I have around 20 column headings
I want to put a label so that I can identify what this column are store
and instruction in...
|
|
1 |
119 |
|
|
Equals Sub Total Line by
Jennifer
What function could I use if I want the info in the column to the right of
the subtotaled column to always equal the subtotal below it?
--
Jennifer
|
|
1 |
126 |
|
|
COUNTIF formula by
Maxx
I have a spreadsheet with over 30,000 rows. I am am trying to use the COUNTIF
formula to count the number of cells with specific text, but it doesn't seem
to...
|
|
2 |
123 |
|
|
Auto Filter Comma Dilemiation by
weswhite7
I have a spreadsheet and I would like to be able to limit the number of
columns by using comma separations. If I have Column B and it has a list of
10 rows...
|
|
2 |
114 |
|
|
How to find min value in Excel text cells? by
Jeff Kantner
Suppose I've got 5 cells, containing values 'b', 'd', 'a', 'e', 'c' ... if
asked to pick the minimum value, you'd say 'a' (setting aside collating
sequence...
|
|
3 |
150 |
|
|
Countif - Key words by
PAL
I have multi-column, multi row spreadsheet. One of the columns is for a
title. Is there a way to do a count of "key words". I was thinking like
countif. ...
|
|
4 |
152 |
|
|
|
|
1 |
180 |