|
|
|
|
1 |
178 |
|
|
Badly need help with a function by
slfwalsh
How do i create a function to give me the following mathematical formula:
(a+b+c+d+e+f)/N * 6/N
Where a-f are numbers between 0-9 inclusive and importantly N...
|
|
4 |
201 |
|
|
Data Validation by
Lost Cluster
I have a drop down with data validation and I’m trying to compare names from
two name ranges. The first name range is called NameCheck, it has the names...
|
|
1 |
207 |
|
|
|
|
6 |
390 |
|
|
|
May 21st, 2010 03:56 PM
by venus
|
0 |
255 |
|
|
|
|
3 |
209 |
|
|
|
|
2 |
192 |
|
|
Formulas That Reference ADJACENT Sheet by
mlman
I am creating a form in Excel 2003 where I need the formulas in the sheet to
reference the adjacent sheet.
i.e. I have 3 sheets called 'May 19', 'May 18' &...
|
May 21st, 2010 01:52 PM
by mlman
|
4 |
309 |
|
|
Filter by formula by
Michel
Hi max
Thks for your help but I tried it today but it don't work. In fact I have
two workbooks. One is the database file with a list of informations I have...
|
|
1 |
196 |
|
|
|
|
2 |
185 |
|
|
Summing multi-level bill of material by
Nathan356
All,
I have a multi-level bill of material and I want to create a
function that will sum it properly without having to sum up each
level
manually. Here is...
|
|
5 |
155 |
|
|
|
|
2 |
186 |
|
|
HELP!! How to formula the "sheet" link by
hsfnwa
Hi ,
I have a workbook contains 1+50 worksheet, I want to link each sheet number
to sheet one, besides manually change the sheet # in the formula...
|
May 21st, 2010 12:23 AM
by Max
|
2 |
214 |
|
|
Sorting Worksheets in a workbook by
Doehead
Hi all, I am trying to use Cpearson's VBA procedure 'Sorting by Name' but I
am not sure -- do I have to copy and save it into every worksheet? My
workbook...
|
|
5 |
293 |
|
|
VLOOKUP and IF formula by
casdaq
I have this formula already in use...
=VLOOKUP(B17,'Pivot'!$A$2:$C$291,2,FALSE)
I need it to include an "If" formula as well returning a "-" dash if it...
|
|
1 |
185 |
|
|
Count the words in a cell by
Elton Law[_2_]
Dear exper
A cell contains a lot of information.
Is it possible to count certan word in a cell please?
Say A1 contains a series of text ....
1. Daily Swing...
|
|
8 |
231 |
|
|
Ref in two worksheets by
wm
I have a bank statement on a worksheet and want to show the current balance
in another workbook.
I can copy a link for the current balance to the other...
|
|
5 |
227 |
|
|
|
|
4 |
383 |
|
|
SUMIF division by
bob
From Sheet 2, I'd like a formula to calculate the following using an array:
If Sheet1 Column A = Sheet2 Column A
AND
If Sheet1 Column K 0
THEN
Divide Sheet1...
|
|
2 |
212 |
|
|
Totaling text cells by
Malcolm
Is it possible to autosum the total of cells that contain only text, in a
worksheet that contains cells with only text and cells with only numbers?
|
|
2 |
173 |