|
|
Deleting recuring data by
kjsmom98
I have a spreadsheet where there is one invoice number with muliple
lines. The shipping charges are recorded in each row even if there was
only one charge....
|
|
1 |
127 |
|
|
|
August 20th, 2009 05:57 PM
by Bernd P
|
3 |
163 |
|
|
Average With Continued by
hamricka[_7_]
=SUMPRODUCT(--ISNUMBER(H21:H51)),H21:H51)/COUNTA(H21:H51)
-----CTRL SHIFT ENTER
THis forumla works for averaging without adding numbers that are but
how...
|
|
4 |
178 |
|
|
Sumif, unique counts, by
Chin Huat
Hi Excel Gurus;
I have another problem. I have 2 worksheets - data source and a
summary worksheet.
The source data worksheet has the following data :
A ...
|
|
4 |
168 |
|
|
Excel2003 MAX and MIN with by
hamricka[_3_]
I need to find the MAX of a column of numbers that contain in them
with out putting the less than in a separate colum.
Example:
2
0.1
8
7
3
( 1 2)
|
|
10 |
327 |
|
|
XNPV Function by
David[_54_]
I'm using Excel 2007 and I'm trying to calculate XNPV for a certain
array within VBA. Within Excel, the XNPV function asks for 3
arguments:...
|
|
0 |
93 |
|
|
CF, MACRO??? by
Tree
I am not sure what to use but here is the situation:
I have a macro that Ron Bruin brilliantly helped with that combines data in
several tabs into one summary...
|
August 20th, 2009 02:47 PM
by Tree
|
3 |
107 |
|
|
Hyperlink to more than one file by
Tomas Stroem
Hi,
I would like to create a hyper link from one cell entry that opens two to
five different files. I can make the connection manually, dont need that to...
|
|
2 |
91 |
|
|
functioning of formulas by
Denise
Hello
I would like to know why some times my formulas don't work and 5 mins. after
they do. Do you have an explanation for this problem.
Thank you for your...
|
|
3 |
123 |
|
|
|
|
1 |
105 |
|
|
Hidden cells by
KT
I'm trying to do a simple calculation in a worksheet that contains
hidden/subtotaled cells. When I enter = to begin the calculation all hidden
cells expand...
|
|
1 |
97 |
|
|
|
August 20th, 2009 02:05 PM
by Pete_UK
|
7 |
141 |
|
|
Another Formula by
Help with cell function[_2_]
Ok, this has been a very helpful forum so here goes another.
I have 3 columns D2 (with a date ie 20 Aug 09), F2 (with a date or not ie 22
Aug 09 or blank),...
|
August 20th, 2009 01:56 PM
by Eduardo
|
3 |
157 |
|
|
Count based on multiple criteria by
birdey
I have multiple sheets. One sheet identifies the date a ticket was closed
and the ID of the technician that closed the ticket.
Open Dt Closed Dt ...
|
|
2 |
89 |
|
|
IF Lookup Formula by
Redi
Hi all,
I need your help again!
I have two worksheets.
worksheet one is the source
Worksheet two will contain the formula
worksheet one:
|
August 20th, 2009 01:36 PM
by Redi
|
2 |
80 |
|
|
Marking new names by
connexion
Hi,
The Problem:
An excel sheet has a list of names. Another excel sheet with some
additional names Is received. I want to identify and mark the new
names in...
|
August 20th, 2009 01:11 PM
by Eduardo
|
1 |
89 |
|
|
SUMPRODUCT by
ksel
Hello,
In this worksheet all the details of every invoice are shown in columns:
invoice value, weight, destination, customer, etc. There is 1 row per...
|
August 20th, 2009 08:52 AM
by ksel
|
2 |
88 |
|
|
|
August 20th, 2009 07:55 AM
by j5b9721
|
0 |
115 |
|
|
|
|
1 |
139 |
|
|
logical functions by
Terri Farm[_2_]
I have been trying for over an hour to get a formula to work. There are 4
specific items included in a column and 1 item in another column that if all
of...
|
|
6 |
145 |