|
|
|
|
5 |
207 |
|
|
If 3 If's, then sum by
Steve
I need to add hours if 3 critera match.
In the below, if there is a 90 in the G column AND a 10 in the J Column, AND
a 100 in the D column, then add the H...
( 1 2)
|
April 19th, 2010 04:51 PM
by Steve
|
13 |
357 |
|
|
|
|
7 |
413 |
|
|
i dont know if sumif ,,,,, please help by
Jessejames
i have 2000 rows and 2000 columns
in one column, after searching for this product x. this value of all the
product x will be summed up on below , for every...
|
April 19th, 2010 02:14 PM
by Eduardo
|
2 |
236 |
|
|
COUNTIF PROBLEM by
manfred3
Hi,
I am using the countif formula in my spreadsheet to count the number
of times "DPRS" appears in say column G. for some reason it keeps
givong me the wrong...
|
|
6 |
171 |
|
|
Automatically insert rows/copy formula by
JStiehl
I need to have the formulae in row 4 on the totals page be automatically
copied and inserted in a new row underneath it if a 1 is entered in cell G21
on...
|
|
1 |
212 |
|
|
Formula assistance please . . by
J.Scargill[_2_]
Hi people,
Had a query passed to me about a formula and despite my efforts, have
reached the decision to seek help from your good selves!
Worksheet looks like...
|
April 19th, 2010 10:59 AM
by Mike H
|
3 |
189 |
|
|
Check the lasta character by
Manos
Dear All
i have a range of coding where some of them are ending in letter I.
There is any way to group all of them?
Or is it possible to create an if function...
|
April 19th, 2010 09:35 AM
by Mike H
|
2 |
203 |
|
|
Compare two columns with different codes by
Manos
Dear all
I have two columns with codes.
The first column include the main coding (ie: ab1, ab101, ab10101,...)
The second column include the same codes, but...
|
April 19th, 2010 09:14 AM
by Manos
|
2 |
220 |
|
|
excel 2007 macro recorded pivot table by
getting old
I record a macro in excel 2007 in which i create a pivot table. when i try to
run the macro i get "invalid procedure call or argument". the same process...
|
|
2 |
207 |
|
|
|
|
2 |
182 |
|
|
|
|
2 |
228 |
|
|
need help with formula by
Jay
Hi all,
I am in a tricky situation. i have a table which basically includes 6 Columns.
Date, Location,Location 2, No. of pieces, Weight,...
|
|
1 |
195 |
|
|
|
April 19th, 2010 02:21 AM
by JLatham
|
2 |
245 |
|
|
|
April 19th, 2010 02:10 AM
by JLatham
|
1 |
198 |
|
|
|
April 19th, 2010 02:00 AM
by JLatham
|
2 |
182 |
|
|
Deleting Row by
BMP
I am using two worksheets (in the same file), each containing a vertical list
of names. Worksheet B pulls a list of these names from from Worksheet A
using...
|
April 19th, 2010 12:12 AM
by Max
|
1 |
176 |
|
|
Validation of UK VAT Number by
Rob
Hi,
I want to check a number of VAT numbers using a formula, the first check is
to ensure the number is 9 digits (may need to remove spaces to ensure clean...
( 1 2 3)
|
|
22 |
925 |
|
|
|
April 18th, 2010 09:36 PM
by Billns
|
3 |
278 |
|
|
Complex functions by
JP Ronse
Hi All,
Suppose you have a very complex and long function that is also subject to a
condition, then you will/can have something like:
=if(condition(complex...
|
|
1 |
194 |