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.