Re: Actions recommended formula

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Bob Phillips" <bob.ngs@xxxxxxxxxxxxx>
Date: Fri, 24 Aug 2007 13:27:00 +0100

Do you mean

="Move "&C1&" to "&A1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Byron720" <Byron720@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3656AC20-ABE2-45AD-955D-A94AD513C610@xxxxxxxxxxxxxxxx

I have to following inventory data:

Pool Part # Final Discrepancies Actions

FG11 286692-001 -1
FG13 286692-001 1 Move 1 to FG11

I need a formula that automatically gives me the comment "Move 1 to FG11"
considering 1 as the number of parts to move in order to correct both
inventories.
The -1 means I'm short one piece and the 1 I'm over one piece.

Prev by Date: Re: change excel document into word document
Next by Date: Re: Does "Too many different cell formats" apply on excel 2007
Previous by thread: Re: change excel document into word document
Next by thread: Re: How can I invert an Excel List, means colums become rows and vv.?
Index(es):
- Date
- Thread

Relevant Pages

Re: Selection.Cells vs Range reference - strange behaviour (using
... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... parentheses to indicate the parameters to be passed. ... I have a series of subs for formatting text along the lines of ...
(microsoft.public.excel.programming)
Re: Help with SUMIF
... It worked because any non-zero value is TRUE, so for the odd columns *1 ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... "Bob Phillips" wrote: ...
(microsoft.public.excel.worksheet.functions)
Re: A bit more help needed on an =SUMPRODUCT if possible?
... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... Try posting the data with some cell character to show where they change, ... GD and a separate monthly readout for analysis purposes... ...
(microsoft.public.excel)
Re: Formula to get sum from one 31 sheets to a summary sheet.
... "Bob Phillips" wrote: ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... This is brand new to me, please forgive me if my related communication is ...
(microsoft.public.excel.misc)
Re: visual basic error
... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... ' AvgRounds Macro ... Dim total_plays As Byte, used_plays As Byte ...
(microsoft.public.excel)