View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
M. Farooq M. Farooq is offline
external usenet poster
 
Posts: 1
Default FILTER (REPEATED NUMBERS)

dear Sir,

kindly clarify me that the same numbers with different descriptions,
quantities and unit prices, i want keep dat's one ref number with other
data's any one.
like
1701012 HOUSING REAR 3
1701012 HOUSING REAR part 4
1701012 HOUSING REAR 2
1701012 HOUSING REAR p 5

i need to make like this
1701012 housing 14

please help me to learn more about this function.