Comparing Channel List
Closed
C_Gaf
Posts
2
Registration date
Sunday September 16, 2012
Status
Member
Last seen
September 17, 2012
-
Sep 16, 2012 at 07:58 PM
C_Gaf Posts 2 Registration date Sunday September 16, 2012 Status Member Last seen September 17, 2012 - Sep 17, 2012 at 11:23 AM
C_Gaf Posts 2 Registration date Sunday September 16, 2012 Status Member Last seen September 17, 2012 - Sep 17, 2012 at 11:23 AM
Related:
- Comparing Channel List
- My contacts list names - Guide
- Make youtube channel private - Guide
- Youtube search within channel - Guide
- Channel keywords - Guide
- Whatsapp country code list - Guide
2 responses
Mehedad
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
Sep 17, 2012 at 04:23 AM
Sep 17, 2012 at 04:23 AM
There are several solutions for that: You can apply the 'Vlookup' formula
=VLOOKUP(A2,C:C,2,TRUE)
[Use "FALSE" instead of "TRUE" for exact matches to be found]
This will give you the channel numbers in the adjacent column if the names are almost the same.
Also, in the Match Function, you are using "" (zero) which is done for an exact match. Try changing it to "1" instead of "0".
There is another solution if the list has same number of entries. But either of the above two should work.
=VLOOKUP(A2,C:C,2,TRUE)
[Use "FALSE" instead of "TRUE" for exact matches to be found]
This will give you the channel numbers in the adjacent column if the names are almost the same.
Also, in the Match Function, you are using "" (zero) which is done for an exact match. Try changing it to "1" instead of "0".
There is another solution if the list has same number of entries. But either of the above two should work.
C_Gaf
Posts
2
Registration date
Sunday September 16, 2012
Status
Member
Last seen
September 17, 2012
Sep 17, 2012 at 11:23 AM
Sep 17, 2012 at 11:23 AM
Thanks, Adding the "1" did the trick...I still have to sort few a bunch but it got rid of a good 6-700
