((My comments in double parentheses - Homer)) THE COMPUTER MODEL OF THE MIND FG - 13 No Date Copyright (C) Frank Gordon Redistribution rights granted for non commercial purposes In his early writings about Dianetics, LRH used the

field MT<]<9S3-YE95`Y)P*M+2Y)8^S7$;`*,@<$BGW)EC<(X8''`-3HV(AW>9=+%%( M_!/WCVJ:>P0D>0X8CE@3T%%#ERM%%)71+9I($;*QNON:HWW%%P2#CI2C\0WHC0L MS]NTYH&(,L/S*3Z>E9XY(`SPV3[TXZ70/74;.-LA`YR:AW8;D\"M$):$@"NA M;S0#_=QBGQCG=W]J$)C'5H\;\YZ_2K%%NN9,9X-)["Z"O$RAI#QCI5;)R,]*2 JC![]*,X89R*H1=MXU<[YONGG`[U4NF4R$JNWGM41W&5B"2?2GQ`#E^@K M1[#2N26$+33A`..I/M5VXO!;@01#:.C8-925Y6-(Z)LSF#1L5//\C2D\X4UH M9V'1DX)SR/2K2ONB7CH

Not that helpful "PCLIVE" wrote: Maybe a formula like this: =INDIRECT("D" & MATCH(1,C1:C10,0)) HTH, Paul -- "Byron720" <Byron720@discussions.microsoft.com> wrote in message news:0E149078-A0FB-4D48-A95E-AA0051E485CC@microsoft.com... I have to following inventory data: Pool Part # Final Discrepancies Actions FG11 286692-001

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:

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