|
|
|
|
2 |
131 |
|
|
vba to delete rows by
ericahughes
Can anyone help me to write a vba to delete rows that have the word lab in
Column G? I would like to include nonptlab or labuseonly as well. Basically...
|
|
1 |
177 |
|
|
Convert number to text by
Brookyboy
I have a cell with a number in it 1-10
I want to convert that to text like person1 - person10.
I have tried all sorts of formula but not quite got there...
|
|
3 |
113 |
|
|
maximum nested IFs by
Opal[_3_]
Help.... I understand that Excel only allows for 7
nested IF statements.... I have 7, but the following
responds with #VALUE! for the last 2 items in
my...
|
|
6 |
179 |
|
|
|
February 9th, 2010 09:46 PM
by Steve
|
2 |
114 |
|
|
Help with an array and SUMPRODUCT by
xlcharlie
I am not positive that SUMPRODUCT is the right function to accomplish what I
am trying to do so I’ll start by describing my objective. I suspect the...
|
|
3 |
151 |
|
|
VBA to count colored cells by
ericahughes
I have never used a VBA, but I am a really quick learner and a self taught
excel user. What I have is a conditional format that highlights the row in
blue...
|
February 9th, 2010 08:55 PM
by FSt1
|
1 |
161 |
|
|
Getting a formula to do the following: by
Pierre
Hi there, I need a bit of a hand writing a formula.
I have a column of numbers that has duplicates and triplicates in it; I'm
trying to concatenate the data...
|
February 9th, 2010 07:48 PM
by Pierre
|
2 |
114 |
|
|
How can I? by
DaveMoore
I have a list of 32 numbers ranging from 166.80 to 4,231.22 in cells
R1:R32; there may be duplicates but there are no negatives and all are
to 2 decimal...
|
|
4 |
175 |
|
|
Looking up any match, returning data by
Stacie2410
I've got a spreadsheet that has over 1700 rows of data. The data has columns
for:
Property # (col A)
Production Period (col C)
Status (col F)
There are...
|
|
5 |
116 |
|
|
Adding totals in columns by
Tanya
I have a worksheet that we have hidden rows in. I want to find the sum of a
column without picking up the hidden row values? I can I get a sum without...
|
February 9th, 2010 06:56 PM
by Eduardo
|
2 |
128 |
|
|
Retaining conditonal formats by
MM
Hi, I need some help please!
I've designed a sheet to collect data from users which has been set up with
lots of set formats (e.g round £ to two decimal...
|
|
4 |
170 |
|
|
Inconsistance Formula? by
Tmt
I used this formula to calculate the number of items being serviced in any
particular department from another worksheet. It counts most of my data but
leave...
|
|
2 |
119 |
|
|
if statement by
Debra Reid
In using the "if" statement I would like the logic portion to state that if
cell# = v or m or d or a but the if statement seems to only work if the logic
is...
|
|
5 |
89 |
|
|
If Function?? by
Dave Tee
Hello Forum,
Excuse me for asking the same question. I submitted on the Excel 2010 forum
in error.
I have several columns of data. I need to ensure that a...
|
|
1 |
90 |
|
|
Running Total by
DisMusBeDaPlaz
Hello Group Excel,
I am using Excel 2003.
My computation Columns are "E" to "J", and starts on Row 15.
Column "I" is the Total.
Column "J" is the Running...
|
February 9th, 2010 04:48 PM
by Luke M
|
3 |
114 |
|
|
|
February 9th, 2010 04:42 PM
by Luke M
|
1 |
119 |
|
|
|
February 9th, 2010 04:02 PM
by Mike H
|
1 |
90 |
|
|
copying data by
Copying data errors
Getting errors when copying data from workbook to workbook. Shutdown and
restart allows without errors.
|
|
0 |
91 |
|
|
|
|
7 |
193 |