Actions recommended formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 
Hi,

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

Thanks,
 
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.
 
Back
Top