|
|
|
August 28th, 2008 04:48 AM
by GAK
|
0 |
113 |
|
|
How do I set a static date? by
Shawn
In A1 I'm putting an Id number in and I would like to set a formula in B2 so
that a static date appears, can this be done?
|
|
5 |
192 |
|
|
Multiple "IF"'s by
Solar Man[_2_]
I thought I had this one licked. I have a list of TRUE FALSE cells. There
are 18 of them. Say they were listed A1:A9 and B1:B9 then if A! is TRUE,
insert...
|
|
6 |
134 |
|
|
Excel by
CCJ
how can i find the rate using VLOOKUP.
Selling Price Loan Term
26,5354 30
|
August 28th, 2008 01:35 AM
by smartin
|
1 |
106 |
|
|
Convert to Binary and Break out results by
DCLittlejohn
I would like to take a 16-bit integer value, convert it to binary and then
break the individual 1s and 0s into seperate columns.
For example, a value of 5 in...
( 1 2)
|
|
10 |
203 |
|
|
|
August 28th, 2008 12:29 AM
by Peter
|
5 |
103 |
|
|
nesting sumproduct with subtotal by
SteveDB1
morning all,
I have a worksheet that I'm attempting to analyze, and wanted to see if a
nested sumproduct with subtotal would work. I.e., the idea made sense...
|
|
9 |
58 |
|
|
|
|
6 |
149 |
|
|
Replace Link by
Annette
I have 83 workbooks with 5 sheets per book and 21 links per sheet - and I
need to replace - (basic link - ='C:\Users\Annette\Desktop\Annette Daily...
|
|
5 |
56 |
|
|
|
|
9 |
66 |
|
|
Consolidating a Matching List by
Peter
Assume I have a list of 30 rows with 5 fields each. A user can select whether
a row is a match or not a match. I have setup a test to catch the selected...
|
August 27th, 2008 10:45 PM
by Spiky
|
1 |
64 |
|
|
|
August 27th, 2008 10:41 PM
by Spiky
|
3 |
78 |
|
|
What are the COUNT or other options ... by
rugbykats
I am creating a spreadsheet that will allow me to keep track of a football
game's statistics by entering the result as each play occurs. Generally, no...
|
|
3 |
70 |
|
|
Multiple IF Formula Question by
Rob
I'm looking to do the following:
If C5=1, -C21*12.50%, IF C5=2, -C21*15.00%, IF C2=3 and so on all the way
until IF C5=10.
Thanks.
~~Rob
|
|
6 |
68 |
|
|
Average by
Vercingetorix.XIII
I need some help creating a formula to calculate who was at #1 status the
most throughout the month. Some people were not on list everyday and some
were, so...
|
|
9 |
93 |
|
|
VLOOKUP and "-" characters by
Exxet
Hi,
I'm using VLOOKUP to to convert a set of cells with values based on a lookup
table. Some of these defined values are "C--" and "C-" as per the example...
|
August 27th, 2008 09:45 PM
by Exxet
|
4 |
60 |
|
|
|
|
1 |
102 |
|
|
SUMIFS including hidden rows by
moosie
Hello,
I am using the SUMIFS function but I have alot of rows hidden because
otherwise it will become a very long list of data and I only need to see the...
|
|
1 |
95 |
|
|
Concatenate a VLOOKUP by
lehigh46
Hi All,
How can I concatenate a VLOOKUP from 3 cells showing city, state & zip
into one cell?
Thanks in advance
|
|
2 |
85 |
|
|
Searching A List by
smartin
Given the following in a column:
Number
0
1
1
0
0
1
0
|
August 27th, 2008 08:41 PM
by smartin
|
1 |
54 |