|
|
|
|
5 |
101 |
|
|
Incrementing numbers problem by
AJ
I have a workbook that has a sheet1 with product information, something like
this
Prod Length width Code
A 10 20 001
B 5 ...
|
|
1 |
72 |
|
|
|
|
2 |
90 |
|
|
Date issue by
willemeulen[_24_]
On sheet1 I complete all info displayed spread over other sheets of
which many information is repeated. So I have a direct reference to
sheet1 and only need to...
|
|
1 |
77 |
|
|
|
|
2 |
92 |
|
|
Naming of tabs from data in a worksheet by
Christine
Hello, I've looked for a post on this and in Excel help but drawing a blank.
Hoping one of you might have an answer for me.
Is there a formula that will...
|
|
2 |
70 |
|
|
|
May 22nd, 2009 07:30 PM
by PJFry
|
2 |
87 |
|
|
Sumproduct syntax question by
ocuhcs
This is my first attempt a using sumproduct and testing by rows and columns
together.
My goal is to:
Sum all cells U10:DL30
if Row 7 = the current month
if...
|
|
6 |
84 |
|
|
Extracting Table Data by
maria
First would it be to send a excel file to get some assistance with my
worksheet?
--
Maria A Adams
|
|
1 |
72 |
|
|
Why won't my spreadsheet SUM??? Help by
SnoDrift12
Having used lotues1-2-3 for 8 years to prepare income tax repoerts, I am now
using Excel for the first time. I copied my Lotus Workbook, to an Excel...
|
|
3 |
96 |
|
|
Test by
Lady Success
Test of post problem
--
Lady
|
|
0 |
106 |
|
|
Complex matching with ranges by
Steven M.[_2_]
I am not sure how to accomplish what I need to accomplish, and I'm not sure
it can be done in excel... It may need a VB code which I have no experience...
|
|
1 |
65 |
|
|
|
|
2 |
108 |
|
|
Help with Formula by
Chris
I am using this formula in CG
=IF(F11="mlf",C11*D11*E11/1000,IF(F11="RL",D11*E11,""))
I am using this formula in CE
=I11/0.95
The formula in CE is causing the...
|
|
3 |
73 |
|
|
Not sure which formula to use by
v1rt8
Column A contains #'s 1-1408 sequentially, Column E has #'s varying 80-33000
non-sequential. Now by using =if(e3:e1408,"27840") this finds this number and...
|
May 22nd, 2009 05:38 PM
by v1rt8
|
6 |
83 |
|
|
Conditional Format - greyed out? by
NICGRANT
Please can someone help me - I have a spreadsheet which I have "inherited"
and trying to add Conditional formatting to a cell, the CF menu selection is...
|
|
5 |
84 |
|
|
Stopping a CountIf by
Don Kline[_2_]
In a column I need to count how many rows from the start of the column are
greater then zero. The trick is once the value is a 0 or a negative, it is to
stop...
|
|
5 |
86 |
|
|
Links by
Smiele425
Hi to all, I got one for you: I have two workbooks, each with 14 worksheets.
I would like to create LINKS from workbook to workbook, worksheet to
worksheet....
|
|
1 |
66 |
|
|
automatic colour change of cells. by
codfather
how do i get the cells to change colour once they have gone over set
parameters ie- a training schedule on a 12 month rota to automatically change
to red...
|
|
3 |
79 |
|
|
|
|
11 |
140 |