|
|
Sumproduct and filters by
Niller
Hi,
being quite new to the world of sumproducts I struggle to find a formula
that works when filtering.
The formular I am currently using is:...
|
May 25th, 2009 07:55 AM
by Niller
|
2 |
87 |
|
|
Look Up challenge by
Guntars
I hope that the picture will be displayed or you could click on the link and
open it up.
http://www.eonstone.com/F250/list_1.jpg
This is my challenge: I got...
|
|
3 |
133 |
|
|
Recurring Date by
Mickey
Hi,
I am new to excel formulas and would like to know if it is possible to have
a recurring date. For example:
Column E = Start Date
Column F = Status
When...
|
May 25th, 2009 03:46 AM
by Mickey
|
2 |
90 |
|
|
sumif, countif, datedif formula by
v1rt8
K3:K1408 contain dates of hire i.e. 4/30/2007
would like to count how many were hired in year 2007, 1999, etc.. how what
would be the formula, is it a nested...
|
|
3 |
116 |
|
|
=hour formula by
Karen
I have summed up the total time, e.g 34:40. Needed to split this into 2 cells
for hours and minutes.
I used the =minute formula which worked fine but the...
|
May 25th, 2009 02:19 AM
by Karen
|
3 |
113 |
|
|
Rounding up decimals by
Darren
is it possible to round up a decimal number regardless of it's value?
Example:
45.01 shown as 46
|
|
2 |
94 |
|
|
Median with Quantity Column by
SDShannonS
How do I calculate the Median value when using a separate Quantity column?
For example, say there are two columns, Quantity and Value. There are two
rows...
|
|
3 |
85 |
|
|
Outline/group data below by
Leon[_4_]
Hi Group
Using excel 2007.
I want to make e group - outline - of rows.
Want to have a line with a number and some text
8 text here
|
May 24th, 2009 09:51 PM
by JT
|
4 |
48 |
|
|
Formula/functions by
Kay
(1) Start Date:January 13, 2007 (B3;)
(2) I have column C1:C12 with months from January to December.
(3) In D1:D12 you have 1 each month.
(4) In E1:E12...
|
May 24th, 2009 08:13 PM
by Kay
|
0 |
62 |
|
|
Get Data from Word to Excel by
Francis
Pls ignore my earlier as I press enter too fast.
I have a Word document which contents shows as :
1.Apart from formal legal education, what alternative...
|
|
6 |
76 |
|
|
Sub or function not defined by
wmdmurphy
I would like to add some VBA functionality to a workbook in order to set a
default value for a cell named Month and another named Year. I've opened
the...
( 1 2)
|
|
13 |
156 |
|
|
copy 10 workbooks to a combined workbook by
Phil
I have 10 employees who keep data in their own workbooks. I would like to
have a workbook that contains all 10 workbooks in a master workbook that
updates...
|
|
1 |
99 |
|
|
|
|
1 |
95 |
|
|
Formula by
Kay
I have start date march 26, 2006 in cell k3 and D8:o8 the month from july to
june below I have a formula to issue 1 every four months (that is row 9)
march,...
|
May 24th, 2009 04:44 PM
by Kay
|
2 |
71 |
|
|
|
|
1 |
72 |
|
|
Formula in Excel by
Jayesh
I want Baht formula in Excel his language change Thai to English
This function is more useful for me.
Please provide your help step by step...
|
May 24th, 2009 01:40 PM
by Jayesh
|
0 |
81 |
|
|
|
|
1 |
115 |
|
|
Delete from Listbox by
[email protected]
Hi All,
In excel i have created one userfrom in that I have created 3
commandbuttons.
1. for search
2.for updating
3.for delete
I have macro to search the...
|
|
0 |
70 |
|
|
auto populate masterlist from 3 other lists by
Harold Good
Hi, I'm working on a budget spreadsheet. Presently it has room for up to 25 expense categories, but the project reviewers would like for those 25 categories to...
|
|
1 |
82 |
|
|
Question about a complicated lookup by
Jack.Matos
I have a list of names with duplicates in column A of sheet 1 and related
info in columns B & C . I have a second list in column A of sheet 2
containing...
|
|
6 |
69 |