Would like equation that says if A1 to A10 has 400 in it, the change 400 to
"James"
Could someone please help me.

Afternoon
I have a data set (50K+) with various product codes such as 618B TPR, 618B
PGR, 13 VCR etc.
Firstly I want to complete a count exercise using the above codes to see how

Hello, for long time now I'm searching a way in excel to solve following:
Data I have:
Name    Score
Annie    11

I have tried the Excel Options Menu and on to the sub-menu "Show this number
of Recent Documents" but it is not allowing any editing for changine "0" to
any number.  Can any one help solve that problem?  Thanks

I have a series of cells that sum the columns above them (O12:X12) on
multiple worksheets. I would like to write a formula to report the cell that
has a value and is the furthest to the right. I used:
=LOOKUP(10^10,'Worksheet reference'!O12:X12)

Hi,
I come across small problem that I can't copy formulae for relative address
reference to move every 4 cells downwards.
For instance, I have a table as follows :

I have a data base pull that shows a starting time in hh:mm military format,
and an elapsed time in number format (i.e. 30 minutes  equals .50). I am
trying to find an equatioin that will add the Starting time and the elapsed
time and show me an ending time in hh.mm military ...

A client's pivot table always gives 'count' in the data area even on a
numeric field.  Is there any way to set the default to always show 'sum'?  i
thought this was the default.  Any ideas why this is happening?
Thanks

I have a worksheet with a column of names.  Some names are listed many times
and some just once.  I need to count each name just one time.  Is there a
function for this?  

I have a multiple work sheet set up.  Trying to set up a formula to auto
update from 1 sheet to another.  I have the formula set up for person # 1  
(fred) and am trying to copy the formula to person # 2 (Chris) and so on.  
So my formula reads  Fred!M409 for Jan, Fred!M410 for Feb ...

I am trying to make a macro which cuts and pastes lines into a new worksheet
within the workbook when certain cells are populated with a "Y"...NEver wrote
Visual Basic code, only used recorded macros and the 'wizards' within
access..Thanks!

hi all,
Need assistance here. I need a formula to calculate the total amount expired
by month if the fund allocate did not utilize within 6 months.
e.g. Total balance amount of 330 in Apr 07 did not utilize in the 7th month

Can anyone help me figure out the easiest way to do this?
Sheet 1            Sheet 2
    A       B           A             B (Results)
1) 20        1) 70        1) 4050                                  1)

I am working with 2 worksheets, Audit Log and Stats Report.  I have a count
if function working properly - =COUNTIF(' Audit Log'!T:T,'Stats Report'!B10)
where T is a column of week numbers and B10 is week 15 (=WEEKNUM(A10)).
Now I need to use the above count if combined with ...

Is it possible to group a table only by years. I want the total by year
only, not by months.
Please advice.
Sanjeev.