|
|
IF across multiple worksheets by
xvfcc1
I have a workbook that contains 3 worksheets, one for each vendor site. I am
trying to average delivery time (column R) across all 3 sites based on which...
( 1 2)
|
December 20th, 2006 02:20 AM
by T. Valko
|
11 |
143 |
|
|
Formula won't adjust after sorting data by
mmcap
I use 2003 Excel. If I write a formula which works properly with the data
sorted by column A and then sort by a different column it no longer works.
There...
( 1 2)
|
January 22nd, 2007 06:53 PM
by vezerid
|
11 |
104 |
|
|
Spellcheck function in Protected Sheet by
gwinder
I have created an employee review form that contains code which enables text
wrap in merged cells. I have protected the sheet but this disables the...
( 1 2)
|
|
11 |
150 |
|
|
Advanced cell function. is it possible by
Tosco
Hi all,
I`m having a problem on excel and I would like to know if it`s possible
to be done without programming in VB:
Let's say i have the following:
A...
( 1 2)
|
January 29th, 2007 01:19 PM
by Gustavo
|
11 |
182 |
|
|
Last non blank cell in selected cells by
Ron Weaver
Is it possible to specify a group of cells like A1,A5,A10,A15,A20, and have
Excel find the last non blank cell in the group? These are numeric values
that...
( 1 2)
|
|
11 |
123 |
|
|
Assigning numerical value to text by
Dave
This may be simple but I'm new...forgive me...
I've created drop-down lists in a column with several variables all in text
from a list. I am trying to make...
( 1 2)
|
February 1st, 2007 02:21 AM
by Dave
|
11 |
140 |
|
|
Excel 2002 VLOOKUP Weird by
TRJ
The attached Excel 2002 workbook contains 2 sheets:
(I'm new here and could not see how to attach the xls file. How do I attach
or can I email to a...
( 1 2)
|
February 7th, 2007 02:40 PM
by TJ
|
11 |
155 |
|
|
i'm missing something by
[email protected]
im trying to simplify my personal bookkeeping. i import my data from
the bank as a .csv and want to transfer it to a second sheet without
all the jibberish....
( 1 2)
|
February 17th, 2007 06:23 AM
by T. Valko
|
11 |
121 |
|
|
OR or ARRAY help by
Bigfoot17
I am struggling!
This statement will count the number of "W/M"s that are "XYZ":
{=SUM(IF(($F$8:$F$57="W/M")*($D$8:$D$57="XYZ"),1,0))}
But what I would really...
( 1 2)
|
February 19th, 2007 11:37 PM
by Domenic
|
11 |
126 |
|
|
Find Max Value in WorkSheet by
Corey
I need to find the Max Value in a Worksheet,
But the Value will always be in a "st 1234" format.
That is:
"st"+ Space then 4 digits.
I want to find the MAX...
( 1 2)
|
January 14th, 2007 11:00 PM
by Corey
|
11 |
135 |
|
|
COUNT or COUNTIF using wildcard text? by
WiFiMike2006
Hello,
I am trying to create a formula that will count the number of cells with
certain text (EP) in one range that also have an instance of certain wildcard...
( 1 2)
|
|
11 |
143 |
|
|
|
|
11 |
106 |
|
|
summing last values in column by
gotta know
1. I would like to sum the last 25 days values in a column
automatically once the data are input
example:
a. I want to add the sum of the last 25 values...
( 1 2)
|
December 27th, 2006 01:51 PM
by RagDyeR
|
11 |
145 |
|
|
|
|
11 |
130 |
|
|
VLookup problems... by
Tossaire
have been using Vlookup to reference a 2nd sheet to verify cashed checks
based on the check number on the first sheet. using
=VLOOKUP(B59856,CLEAR,2,FALSE)...
( 1 2)
|
December 28th, 2006 06:51 PM
by Tossaire
|
11 |
119 |
|
|
Find One Of Several Values Within A Cell by
Jim J.
Is there a method to perform the following function?:
I) Using a list of values (In my case, these are text. For the discussion,
let’s assume they are...
( 1 2)
|
|
11 |
103 |
|
|
Sumproduct help by
Walter Mayes
Am converting my workbooks over from 2006 to 2007. Hope I can
explain this clearly.
Saved my 2006 workbook as 2007 so it should be a simple matter to...
( 1 2)
|
|
11 |
140 |
|
|
Advance to predetermined cell by
Publius
In Excel 2002 I want to insert a command in certain (not all) cells that once
data is entered therein and "enter" or a hot key is pressed advances the cell...
( 1 2)
|
January 10th, 2007 05:07 AM
by Publius
|
11 |
132 |
|
|
add up negative numbers by
bill gras
Hi
I have a column "G" with negative numbers, positive numbers and zero's.
Column "H" is the column that adds up all the negative numbers from
column "G" ....
( 1 2)
|
|
11 |
133 |
|
|
|
February 27th, 2007 11:28 PM
by Epinn
|
11 |
129 |