Posted to microsoft.public.excel.misc

vlook fomula vlook fomula is offline

external usenet poster

Posts: 43

Repeated Nos

Hi,

I have a list of material code in which every material code reaped several
time
Now I need a list on another sheet in which every material code come only
one time
Is there any method, I can use formula for that
Example

Material code
1002
1002
1002
1002
1003
1003
1003

Result

Material code
1002
1003

Thanks
Zafar

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
repeated value	climate	Excel Worksheet Functions	8	May 28th 08 05:03 PM
maximum repeated value	markag	Excel Worksheet Functions	2	June 16th 06 08:56 PM
Printing text in a repeated cell/row that is longer than repeated	Valerie Dyet	Excel Discussion (Misc queries)	1	February 13th 06 03:27 AM
Repeated row	carlo	Excel Discussion (Misc queries)	2	December 3rd 04 10:47 AM
repeated numbers	Iboa	Excel Worksheet Functions	1	November 2nd 04 05:40 PM

All times are GMT +1. The time now is 09:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us