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.

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" <(E-Mail Removed)> wrote in message
news:3656AC20-ABE2-45AD-955D-(E-Mail Removed)...
>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.

Something like that, but there are hundreds of diferent part #'s under FG11
and FG13. What I need is for Excel to find, everytime there is an overcount
of one part, if there is the same part # somewhere else with a short count
and suggest me to move the part there.

"Bob Phillips" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:3656AC20-ABE2-45AD-955D-(E-Mail Removed)...
> >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.
>
>
>

Hi,

I think if you sort your data based on the column part # and the column pool
you can find it very easy.

Thanks,
--
Farhad Hodjat


"Byron720" wrote:

> 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.

Sorting doesn't work when handling hundreds of parts. It's better if I get
that comment automatically then sort that column and work over it.

"Farhad" wrote:

> Hi,
>
> I think if you sort your data based on the column part # and the column pool
> you can find it very easy.
>
> Thanks,
> --
> Farhad Hodjat
>
>
> "Byron720" wrote:
>
> > 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.