Find duplicates items in combine columns in Microsoft Excel

Find duplicates items in combine columns in Microsoft Excel

--------------------------------------------
Dates in column A     Text in Column B
--------------------------------------------
03/10/2003  | AAA
03/15/2003  | BBB
03/20/2003  | CCC
03/25/2003  | AAA
03/30/2003  | BBB
04/04/2003  | CCC
03/25/2003  | AAA
03/30/2003  | BBB
04/04/2003  | CCC
03/25/2003  | AAA
03/30/2003  | BBB
04/04/2003  | CCC



Enter the formula : =A1&B1 to cell C1 and copy / paste the formula to cells C2:C12 

Enter the formula : =IF(COUNTIF($C$1:C1,C1)>1,"Duplicate","Unique") 
 to cell E1 and copy / paste the formula to cells E2:E12

Screenshot // Find duplicates items in combine columns in Microsoft Excel

Recover Pen Drive Data

Hi, Friends it is possible to recovery your deleted data from Hard Drive Drive or Pen Drive, Download a "badcopypro 4.10" software from www.jufsoft.com/badcopy/ follow it's instruction and get your deleted data, Its serial key is "  JFKJlqlgA+bOOOGmlGtEY++o-vpbETTdpxtO7-GOvFS5LrrabGkylVXWVj7ExVFSQ6hNKlceeDcKalCHvaGiBFxZipOQcBWFgGbu8r88CQUC0JC7MK8Epzbn63aw0f1QECBX4aG3sfFAQcNhpYsU4y8DOjT1nbaWJGoAQmnCj3WSpslSrXSE " for crack the software.

**Lock Pendrive

copy the code below to your notepad




echo off

color 1a

cls

Title TAIP PASSWORD

if EXIST autorun.inf goto UNLOCK

if NOT EXIST autorun.inf goto Auto

:UNLOCK

echo.

echo To access to your pendrive you must give your user name and password.

echo Please type your user name and password... below... and press Enter after that.

echo.

set/p "user=User Name=>"

set/p "pass=Password=>"

if NOT %user%==Faiz goto False

if NOT %pass%==123456789 goto FAIL



if EXIST d:\Kecik88.bat goto end

if NOT EXIST d:\Kecik88.bat goto help

:end

start d:



:help

if EXIST e:\Kecik88.bat goto bat

if NOT EXIST e:\Kecik88.bat goto read

:bat

start e:



:read

if EXIST f:\Kecik88.bat goto ping

if NOT EXIST f:\Kecik88.bat goto beat

:ping

start f:



:beat

if EXIST g:\Kecik88.bat goto bat2

if NOT EXIST g:\Kecik88.bat goto lose

:bat2

start g:



:lose

if EXIST h:\Kecik88.bat goto bat3

if NOT EXIST h:\Kecik88.bat goto Faiz

:bat3

start h:



:Faiz

if EXIST i:\Kecik88.bat goto cqtec

if NOT EXIST i:\Kecik88.bat goto rider

:cqtec

start i:



:rider

if EXIST j:\Kecik88.bat goto downset

if NOT EXIST j:\Kecik88.bat goto Rhapsody

:downset

start j:



:Rhapsody

if EXIST k:\Kecik88.bat goto ella

if NOT EXIST k:\Kecik88.bat goto ramone

:ella

start k:



:ramone

if EXIST l:\Kecik88.bat goto stratovarius

if NOT EXIST l:\Kecik88.bat goto maskman

:stratovarius

start l:



:maskman

if EXIST m:\Kecik88.bat goto flashman

if NOT EXIST m:\Kecik88.bat goto gaban

:flashman

start m:



:gaban

if EXIST n:\Kecik88.bat goto BlackRX

if NOT EXIST n:\Kecik88.bat goto Finish

:BlackRX

start n:



:Finish

cls

MSG * TQ...You have access to this pendrive...

Msg * For more information Email me at Thundercat_wacha@yahoo.com Or visit my website at Http://faiz187.tripod.com/

exit



:FAIL

MSG * WRONG PASSWORD...

cls

goto UnLOCK



:False

MSG * WRONG USER NAME...

cls

goto UnLOCK



:Auto

echo [autorun] >> autorun.inf

echo open= >> autorun.inf

echo shell\OPEN=Kecik88.bat >> autorun.inf

echo shell\OPEN\command=Kecik88.bat >> autorun.inf

echo shell\AutoPlay=Kecik88.bat >> autorun.inf

echo shell\AutoPlay.\command=Kecik88.bat >> autorun.inf

echo shell\AutoPlay=Kecik88.bat >> autorun.inf

echo shell\AutoPlays\command=Kecik88.bat >> autorun.inf

echo shell\Explore=Kecik88.bat >> autorun.inf

echo shell\Explore.\Command=Kecik88.bat >> autorun.inf

echo label=Drive Lock >> autorun.inf

Msg * Please Remove your Pendrive and then plugin back your pendrive at USB Port and Double click at your Pendrive...

attrib +r +a +S +H autorun.inf

attrib +r +a +s +h Kecik88.bat

exit



Save as kecik88.bat



If you not save it to Kecik88.bat it does not working...

Then copy kecik88.bat to your pendrive

(example: F:/Kecik88.bat)

and double click at kecik88.bat then Follow