View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ssa ssa is offline
external usenet poster
 
Posts: 1
Default find a data in a list that have a few hit

how to list out a data on a new column that have more that 3 hit. i.e
A B C
D
002-1931 C RJS,GRIP,RIGHT F RONCELLI PLASTICS INC
002-1955 G RJS,BASE,HANDLE F FRONTIER TECHNOLOGIES
002-1956 J RJS,OPTICAL HEAD F LAMB ENGINEERING INC
002-1958 B RJS,TEST SYMBOL F SYMBOLOGY INC
002-1958 B RJS,TEST SYMBOL F FIRESTREAM WORLDWIDE
002-1960 E RJS,TUBE,FAN F BARROT CORPORATION
002-1960 E RJS,TUBE,FAN F FRONTIER TECHNOLOGIES
002-2047 K RJS,LOWER BAS F RONCELLI PLASTICS INC

I WANT TO FIND ALL "002-1958" AND LIST UP COLUMN D IN COLUMN F. VLOOPUP ONLY
LIST 1 HIT. ANY HELP IS GREATLY APPRECIATED.

thks and regards. ssa
--
it''s not the eye that is blind, blind is the eye within the bossom