LinkBack URL
About LinkBacks
Hello everybody
I have some names in range ("A1:A20") and some names are repeated (existing more than once)
and in range("B1:b20") some cells have the value the string value ("A")
I want to extract unique names that have the string value ("A")
Hello everybody
I have some names in range ("A1:A20") and some names are repeated (existing more than once)
and in range("B1:b20") some cells have the value the string value ("A")
I want to extract unique names that have the string value ("A")
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
try something like this to run through names in column A
Please Login or Register to view this content.
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
As per your description, try this......
The code below will place the unique names from col. A in col. C starting from C2. Change it as per your requirement if needed.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi,
An alternative :
RegardsPlease Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Thanks a ot everybody
Mr. sktneer
i tried to change the range to ("A2:B20")
and I changed this line
For i = 1 To 20 to For i = 2 To 20 to adjust the rows but i got error
Make the following change also other than what you already changed.
Please Login or Register to view this content.
thanks sir for help
thanks a lot everybody for wonderful solutions
One more, no loop.
Please Login or Register to view this content.
Mr. jindon I tried to edit the code to be like that
replaced the string A with the string XPlease Login or Register to view this content.
changed the variable x to be xx
changed the cell where to get the results ..
but I didn't get any results
I tested it at first and it worked very well .. but after these logical changes for me it didn't work
You have one more "A" to replace with "X....
Please Login or Register to view this content.
Thanks for help
Thank you very much everybody
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks