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" wrote in message
...
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" wrote in message
...
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.