Summarising Data in Another Column Total

  • Thread starter Thread starter Potsy
  • Start date Start date
P

Potsy

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

--

HTH,

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:

http://tinyurl.com/2t2ozj

--

HTH,

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
Click to expand...

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.
 
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.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !






- Show quoted text -
Click to expand...

thanks - that was it :)
 
You're welcome, and appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

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.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------"Potsy"






- Show quoted text -
Click to expand...

thanks - that was it :)
 
Back
Top