 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Summarising Data in Another Column Total
Hi Is there any way to lookup the data showing in Column A2:A5000 (Manufacturer) and duplicate this in E2:E500 down but only show it once i.e. do not allow repetition of the same manufacturer. At the moment I am adding it manually once a new part number goes in if the Manufacturer is not listed. Ideally as an when someone enters or pastes a new part in Column E checks if it alreday has it and if not adds it? Any help appreciated.... Thanks Potsy This old post should do what you want: http://tinyurl.com/2t2ozj  SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== Hi Is there any way to lookup the data showing in Column A2:A5000 (Manufacturer) and duplicate this in E2:E500 down but only show it once i.e. do not allow repetition of the same manufacturer. At the moment I am adding it manually once a new part number goes in if the Manufacturer is not listed. Ideally as an when someone enters or pastes a new part in Column E checks if it alreday has it and if not adds it? Any help appreciated.... Thanks Potsy > This old post should do what you want: > [quoted text clipped - 25 lines] > > Potsy hmmm, can't seem to get this to work - it returns duplicates still in the column although seems to filter some out - strange. I'd almost be willing to bet that those apparent duplicates are not really duplicates. Check to see if there might not be perhaps trailing or leading spaces, or ... if it's imported data, maybe some invisible imbedded characters. SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > > This old post should do what you want: > > [quoted text clipped - 28 lines] > hmmm, can't seem to get this to work - it returns duplicates still in > the column although seems to filter some out - strange. > I'd almost be willing to bet that those apparent duplicates are not really > duplicates. [quoted text clipped - 47 lines] > > - Show quoted text - thanks - that was it :) You're welcome, and appreciate the feed-back. SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- On 13 Sep, 04:05, "Ragdyer" <RagD...@cutoutmsn.com> wrote: > I'd almost be willing to bet that those apparent duplicates are not really > duplicates. [quoted text clipped - 53 lines] > > - Show quoted text - thanks - that was it :) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.