|
|
|
|
3 |
603 |
|
|
excel links by
Struggling with If, Then
I have a series of workbooks linked by multiple "If, Then, Else" equations -
50 per cell, approximately 200 cells per workbook. When I try to send the...
|
May 17th, 2009 11:43 PM
by art
|
1 |
625 |
|
|
calculation-iterations by
widman
Is there any way to set 1 worksheet for iterations so that it doesn't return
the circular reference, but leave other sheets working normally?
|
May 17th, 2009 11:42 PM
by art
|
5 |
651 |
|
|
|
May 17th, 2009 11:34 PM
by FSt1
|
2 |
707 |
|
|
|
May 17th, 2009 11:20 PM
by joeyg
|
0 |
755 |
|
|
Plotting calculated point by
Bradley Steve
My data
781 249.77
781 449.72
766 649.93
761 849.49
723 1049.39
719 1249.65
692 1449.54
672 1649.80
644 1849.70
|
|
4 |
716 |
|
|
counting matching multiple entries by
colensa
I have two columns containing numbers.
I want to count the frequency with which the two columns' numbers match i.e.
the number of times 5,9 or 6,8 or 13,21...
|
|
2 |
799 |
|
|
How to reference variable range? by
WhatsUp31415
I have one column of data (B9:B721) and a parallel column of tags (C9:C721).
The data are arranged with all of "Tag1" data, followed by all of "Tag2"
data,...
|
|
4 |
707 |
|
|
combine cells with different formats by
Truong
I want to combine the contents of 3 cells that have different formats (e.g.
cell 1= normal text, cell 2=italics text, cell 3= normal text) so that I have
a...
|
May 17th, 2009 06:21 PM
by FSt1
|
2 |
642 |
|
|
|
|
2 |
636 |
|
|
Display zero is no data is found by
wcurtis
I have an IF formula that displays a zero if the number falls between a set
of numbers.
=IF(B30450,B30-450,IF(B30426,B30-426,"0"))
But if no data is found...
|
|
3 |
638 |
|
|
Employee login time sheet by
widman
Does anyone know of a simple excel based time sheet where 5 employees can
log-in and out (morning and afternoon) with passwords and excel could mark
the...
|
May 17th, 2009 03:10 PM
by widman
|
2 |
698 |
|
|
Text Box in Excel for noddy users! by
Anita
I've created a 'form' in Excel (not using the form controls though) - and
protected the sheet so that only certain cells can be edited. However, I
have to...
|
May 17th, 2009 03:08 PM
by Anita
|
5 |
746 |
|
|
A1 and B1 by
Omar
Dear all,
I have two cells A1 and B1. B1 takes from A1
If A1$B!b(B zero, I want the real digit in A1 to be presented in B1, but if
A1=zero, then I need to...
|
|
3 |
635 |
|
|
Concatenation by
M Thompson
Hi
I need to join the numbers from 2 cells so that I can use them in a vlookup.
When I do a concatenation, then a paste special, values, the vlookup can't...
|
May 17th, 2009 11:16 AM
by Max
|
5 |
753 |
|
|
|
|
7 |
791 |
|
|
Why does this work? by
M Thompson
I got this formula from Max, Singapo =VLOOKUP((A1&B1)+0,Sheet2!A1:C6,3,0)
I would like to know how the +0 is working in this. I've spent about alot of...
|
|
4 |
647 |
|
|
|
|
2 |
662 |
|
|
|
|
1 |
632 |
|
|
Random Numbers by
robert morris
I need help with a VBA for creating NON-REPEATING random numbers between 0-9
in Col B4:B13 and Row C3:L3
Bob
( 1 2)
|
|
14 |
990 |