Thread
:
Creating a recap of from data in worksheet.
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Creating a recap of from data in worksheet.
A really good way to learn this is to search the archives for
duplicate
--
Don Guillett
SalesAid Software
"KimberlyC" wrote in message
...
Hi,
I have codes in column A5:A25 of a template workeheet.
Users enter these codes into this column and they change all the time..
Some codes might be repeated in the cells.
In cells E5:E25, I need to recap the codes that were used...and not
duplicate any codes that were entered.
For example:
the following codes might be entered in A5:A10
1235
2366
2366
1235
2022
2022
I would need the recap list in cells E5:E10 to look like:
1235
2366
1235
2022
This needs to update automatically as users enter codes into the template
file.
I'm not sure if a formla would work best or code.....
Any help is greatly appreciated..
Thanks in advance for your help...
Kimberly
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]