Is there a syntax that I can use that recognizes that my investment amt and
resulting cash flows are not necessarily neatly lined up?
Investment is in A5 and resulting cash flows are C10:C20
It just seems as if I'm missing something simple. I know I can copy all the

I am trying to determine an interest rate using excel
Example:  If I start with $45 and in 5 years it grows to $100, what is the
rate it is compounding at?

i have two workbooks, both are open,
first book : "Book1_ERRangers2.xls"
with a sheettab named as : "Result_count"
2nd book : "CUADRO.xls"

I want to link a specifc number into the middle of a sentence in a different
cell.
Example: "x% of Total" where I'm pulling x from another cell.

I hope this is the correct forum for this question; I didn't see a more
appropriate choice.
When I copy or cut and paste within a workbook from one worksheet to another
and I choose "Paste Special" I'm given a range of choices such paste

I have an issue with ranking a dynamic range.  I have a list of data that I
need to rank, but each week the length of the list changes.  The regular rank
formula would work, but I have another caveat, the last item in this random
length list needs to be excluded from ranking.  So ...

=IF(L74="Spiral Preformed steel galv straight
lengths",LOOKUP(G74,{"6x6x4","8x8x4","10x10x4","12x12x4","14x14x4","16x16x4","18x18x4","20x20x4","24x24x4"},{7.35,9.05,12.7,14.35,20.5,32.5,41,44.5,50,53.5,60}),IF(L74="Steel
PVC coated both sides straight
lengths",LOOKUP(G74,{"6x6x4" ...

I know it is simple, but I'm blanked out...........
How do I count the number of cells that have an "*" as the last character?

Hi Group,
I am tring to come up with a formula. I have two columns of numbers ie. the
"change" column is only for reference and illistration.
ColA        ColB   Change

Can anybody help with a formula please
Data is in columns & I need to apply an inflation % to a value IF ColA=Yes &
add up the values of each
y/n    bci end

Hi there, I've created a macro at the top of a page that inserts two rows and
copys some text from above, to create another 'entry' but ive also done this
further down but after ive run the top one it then puts the bottom one out of
sync, is there any way of making a macro ...

Hello everyone, this is something I could just say = A1 then A=17 then A so
and so.  But why, when I could use an offset formula, but jeezz louise, I
cant get it to work.  I need a formula in I800to look at I63 bring back the
data, then on I801 to bring back I79 then on I802 to ...

Entire column has -ve numbers, wants to chage it to +ve numbers, with just
one step.
I have hundreds of colums to be changed
I will appreciate any help I can get. .

What i need is to have numbers which are in in some number ranges
rounded to use them with MROUND formula but according to more conditions
(according to in which range some number is to round it properly) and i
am struggling all day with no succes with this MROUND issue!

Just for cosmetic purposes is there anyway to set the input on a cell so that
no matter how something is entered it shows as a capital.