|
|
Eliminate empty cells in data range by
Stephen
Hi Everyone! I'm using a MIN function to find the lowest value in a set of 10
values that I am downloading from the internet. The problem is, the data...
|
April 2nd, 2005 04:00 AM
by Biff
|
1 |
225 |
|
|
|
April 2nd, 2005 03:40 AM
by Biff
|
1 |
127 |
|
|
sort by colour by
Gers
Hi,
Can anyone suggest a way to achieve this:
I have received a spreadsheet with almost 5000 rows containing information
on items, one item per row. The rows...
|
|
1 |
113 |
|
|
conditional format by
Kevin
I would like a cell to turn red if I enter L or PB.
Normally I would use a 2 conditional formats 1 for L and 1 for PB, but I
need more than 3 conditional...
|
April 2nd, 2005 01:31 AM
by Kevin
|
2 |
84 |
|
|
Count Instances by
Ken
How can I count the number of times each of numerous
items appears in a column? That is, I have a column
a
a
b
b
b
c
c
|
|
2 |
97 |
|
|
|
April 2nd, 2005 12:33 AM
by Jimbola
|
1 |
98 |
|
|
Comments by
LilLiz
How do you copy comments from 1 Excel workbook to another? I am having a
problem doing this. I would like to take information that includes comments
from 1...
|
|
2 |
139 |
|
|
|
|
1 |
80 |
|
|
|
|
1 |
536 |
|
|
Unusual filter request by
JVANSTEL
In a list of numbers, I want to know which numbers appear more than once.
Any idea how to do this? I tried using DataFilterAdvanced Filter, and...
|
April 1st, 2005 11:58 PM
by AlfD
|
2 |
172 |
|
|
|
|
1 |
72 |
|
|
|
|
2 |
91 |
|
|
Excel List range, filter arrows disappeared by
andrew
I have a range A1:L732 that I converted to an Excel List. When I click
within the list, the blue list border appears yet the expected filter arrows
associated...
|
|
3 |
165 |
|
|
|
|
1 |
62 |
|
|
|
|
3 |
85 |
|
|
Change case in Excel by
Hiking
Good morning all,
I have received a private e-mail from someone trying to help me, I
think, but am not certain whether this is legit, or an attempt to get...
|
April 1st, 2005 10:59 PM
by Hiking
|
3 |
98 |
|
|
|
|
3 |
138 |
|
|
|
|
3 |
130 |
|
|
cut and paste macro? by
VBA12thRoundDraftPick
I want to cut a selected area and paste it to another location using a macro,
but when I try to record it using the macro recorder get a compile...
|
|
1 |
77 |
|
|
|
|
1 |
157 |