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

Purchase a Domain Name

http://www.publicdomainregistry.com/

Computer Tricks - Hacking Tips

Computer Tips - Hacking Tricks

Welcome to the web's most helpful Online Free computer tips and tricks website. This site contains allLatest and Cool Computer tricks as well as some Internet Tricks, Registry tricks, Orkut tricks, Windows tips to customize and Optimize the performance of the system by tweaking or tricking the windows registry keys. Solve your computer problems by browsing the website for related Computer solution.

Latest and Best Computer Tips Tricks

• Increase your RAM by Increasing system speed
• Top 20 Tips To Keep Your System Faster
• Hack XP Speed up to 60%. Believe me, Its True
• Put Your name in place of Date (AM/PM)
• Speed Up Acrobat to open it like notepad
• Computer Maintenance tips for keeping it healthy
• Simple Trick to Turn off all system beeps
• Top Ten Tips to Improve System Speed
• Trick to Improve XP Shutdown Speed
• Folder Options missing? help provided here

Top Viewed Internet Tips

• Secret Google Search Tricks
• Increase Internet Speed
• Speed up your internet by 20%
• Multiple login in yahoo without any software
• Find Who is Invisible on Yahoo
• Multi Google Talk - Hacked
• Boost Up Your Firefox Speed
• Hidden Emotions In Yahoo
• Top Tips to increase bittorent download Speed
• Internet Explorer Hotkeys - Mozilla Firefox keys

Hacking - Ethical Hacking Tips Tricks

• Tricks for Hacking Windows Send To Menu
• Secret Google Search Tricks
• Hacking Windows Start Button, put your name
• Be Safe from Hackers and Hijackers| Ethical Hacking
• Find Who is Invisible on Yahoo
• Simple Virus Coding (Only for knowledge purpose)

Mobile Phone Hacking Tricks - Codes

• Check china mobile IMEI number valid and original
• Trace Mobile numbers or IP-Address
• Hidden Secret China Mobile Phones Codes
• Top Ten Tips to Improve System Speed
• Trick to Improve XP Shutdown Speed
• Nokia Mobile Phone Secret Codes

Technology Tips and PC tricks

• Gmail Drive guide to use Gmail space as online storage drive
• Shutdown Computer With Command Prompt or Create shortcut for shutdown
• Secret Tips How I Make Free Calls from Computer to Mobile Phone
• Offline Gmail to browse gmail from computer by downloading the whole gmail
• Skip or bypass Rapidshare, Megaupload, hotfile, zshare, Waiting time with Skip Screen - Free
• Delete Autorun.inf Virus Manually using Winrar

Updated Latest Computer Tips

• Free ways and methods to get google wave account
• Handy and best computer tip to join Video Files using Command Prompt Hack
• Browse anonymously For downloading multiple files at Rapidshare, hotfile or fileserve
• Schedule or Auto shutdown PC at specified time - Freeware for Windows Linux or MAC
• Windows registry tweaks to provide restrictions or Enable/disable
• Download Youtube, Google Videos, megavideo Free Trick

Windows XP Registry tricks

• Make Your Menus Load Faster
• Boot your Computer Faster
• Delete Recycle Bin Icon from Desktop
• Improve XP Shutdown Speed
• Enable/Disable Registry Editing tools
• Turn off all system beeps

Orkut Tricks - Tips - Orkut Softwares

• Orkut Softwares
• Latest Orkut Scrap Flooder
• Orkut Trick to Post Colorful Scrap
• Adding Special Symbols in Scraps
• Delete Topic from a community
• Orkut Trick to Write Your Name in Heart Shape

Best Keyboard Shortcuts-Commands

• RUN Commands In Windows XP
• DOS Commands (Ms Dos Commands List)
• REGEDIT (Registry) Keyboard Shortcuts
• Microsoft Word Hotkeys | Keyboard Shortcuts
• Internet Explorer Hotkeys | keyboard Shortcuts
• Mozilla Firefox Hotkeys | Keyboard Shortcuts
• FDISK Tutorial

Miscellaneous Tips and Articles

• Hair Fall and Hair Removal Solutions
• Mesothelioma (Cancer) and AIDS Treatment
• Greetings
• Yuvraj's 6,6,6,6,6,6
• FDISK Tutorial
• 1 Rupee= 45$ ?? Just Imagine
• Beauty tips to become fair quickly

Learn Flash & Action Script Tutorials

Flash and ActionScript Tutorials

Since 1999, this page has been dishing out a regular dose of Flash and ActionScript tutorials that do a body good. Check out the content or post in our friendly forumsto get help.

Animation

Intro to Animation in Flash CS4 (  1, 2 )   Motion Tweens in Flash CS4 ( No Popup |  Video ) Property Based Animations Create a Motion Tween (  Flash MX 2004 ) Animation Setup (  Flash 8 |  Video  ) Creating a Simple Animation (  Flash 8 |  1, 2, 3, 4 ) Frames and Rates (  1, 2 ) Motion Tweening (  Flash 8 |  1, 2, 3 ) Principles of Animation (  Flash 8 |  1, 2, 3, 4 ) Principles of Animation, Part 2  (  Flash 8 |  1, 2, 3 ) Creating a Basic Flash MX Animation (  Flash MX ) Creating a Simple Motion Tween  (  1, 2, 3 )   Creating and Applying a Custom Ease (  1, 2, 3 ) Using the Bone Tool on Shapes (  1, 2 ) Motion Presets (  1, 2 ) Using the 3D Translation Tool ( No Popup |  Video )  Fading Text (  Flash MX ) Problems with Rotating Animations (  Flash 8 |  Video ) Simple Page Transitions (  Flash 8 |  Video ) Frame Jumping (  Flash MX 2004 ) Simple Custom Scrollbar (  Flash 8 |  1,2,3,4,5,6,7,8,9) Using Code Snippets in Flash CS5 (  Flash CS5) Workspaces in Flash ( No Popup |  Video )

Drawing and Design

Drawing Shapes in Flash Introduction to 3D Using Flash CS4 (  Flash CS4 |  1, 2, 3, 4 ) A Guide to Shading in Flash Fill Techniques (  Flash MX 2004 |  1, 2, 3, 4 ) Drawing Line Art in Flash Flash Vector Illustration: Part 1 Stop Blurry Images Tiled Background in Flash 8 Bevel in Flash (  Flash MX 2004 ) Converting Bitmap to Vector (  Flash MX 2004 ) Using Pixel Fonts (  Flash MX ) Creating a Shadow Effect (  Flash MX ) Symmetrical Round Objects (  Flash 8 |  Video  ) Creating a Wooden Frame (  1, 2, 3 ) Illustration Optimization (  Flash 8 |  Video  ) Creating Masks (  Flash MX 2004 |  1, 2 ) Logo Replication (  Flash MX ) Skinning a Scrollbar (  1, 2 ) Shiny Orbs (  Flash MX 2004 )

Common Tasks

Buttons in Flash (  1, 2, 3 ) Using the Library (  Flash MX 2004 )   Using the Shared Library   JavaScript Pop-Up Windows (  Flash 8 |  Video  ) Common Mistakes using Buttons (  Flash 8 |  Video  ) Magic Cursor (  Flash 8 |  Video  ) Hide/View the Scrollbar Component (  Flash MX 2004 ) Creating Drop-Down Menus (  Flash MX ) Creating Multi-Column Text in Flash Hyperlinks in AS3   Creating a Hyperlink (  Flash MX ) Editing the Registration Point (  Flash MX ) Making an Object Transparent (  Flash MX ) Using Video (  Flash MX 2004 |  1, 2 ) Full Screen Flash Page (  Flash MX 2004 )

ActionScript Basics

Developer Basics - Starting Point (  Flash CS4/CS5 |  Video ) Introduction to OOP Strings as our First Variable  (  Video ) Classes in ActionScript 3  (  1, 2, 3, 4 )   Classes and MovieClips  (  1, 2, 3, 4, 5 ) Introduction to Arrays using AS3  (  Video ) Introduction to 3D using AS3 (  1, 2 ) Specifying a Document Class Hiding Mouse Cursor After Some Time If and Else Statements Physics-Based Bounce Effect  (  1, 2, 3, 4 ) Trigonometric Animations  (  1, 2, 3, 4 ) What removeMovieClip Becomes in AS3 Removing Things using Code Measuring Performance in Flash/AS3 Output vs. Compiler Errors  (  Video ) Changing Color in ActionScript 3   Random Colors in AS3 Changing Colors (  AS 1.0 ) Counting in Hexadecimal Reading RGB/aRGB Color Values Using the Keyboard in AS3 Tweening with Code (  1, 2, 3 ) Animating with TweenLite Using the Drop Shadow Filter in AS3 Introduction to XML in Flash (  Index Page: 40+ Pages )   Using XML in Flash CS3/AS3 (  1, 2,..., 7 ) Displaying XML Data in Flash (  1, 2, 3, 4, 5 ) XML-Driven Drop-Down Menu  (  1, 2, 3, 4, 5, 6, 7 ) Photo Gallery using XML and Flash (  1, 2, 3,...,9 )   Animating Dynamic MovieClips in AS3  (  1, 2, 3 ) Random Movement in AS3 Displaying Library Content in AS 3.0 (  1, 2 ) Auto-Resizing and Centering your Content Managing Movie Clip Instances (  1, 2 ) Detecting When Mouse Leaves Movie Detecting Direction of Mouse Movement in AS3 Finding the Distance Between Two Points What is Flex? Why Use It? Creating a Hello World Application in Flex Flex Application Anatomy Finding Values in an Array  (  AS 2.0 ) Duplicate Movie Clips (  AS 1 ) Detecting Mouse Direction (  AS 2.0 ) Finding Maximum/Minimum Value in Array (  AS 1 ) Associative Array Access  (  AS 3.0 ) Calculating Distance (  AS 1 |  1, 2 ) Binary-Decimal Conversion (  AS 1 ) Tab Ordering Forms (  AS 1 ) Functions  (  AS 1 |  1, 2 ) AS2.0 Variable Names (  AS 2.0 ) Comment Your Code (  AS 1 ) Naming Conventions (  AS 1 ) Global Variables (  AS 1 ) Variable Scope (  AS 1 ) Relative Addressing (  AS 1 ) Conditionals and Toggle Switches (  Flash 8 |  Video  ) Goodbye Complex Code (  Flash CS4 |  Video  ) Parsing External Array Data Flash, PHP, and MySQL Integration Live Hit Counter Flash/PHP Flash Email Form Login Using Flash MX, PHP, and MySQL Use Flash with PHP and mySQL  (  1, 2 ) Displaying Flash Data in PHP Displaying Google Maps in Flash  (  1, 2 ) Working with Native Mouse Features Using the Timer Fast Sorting with QuickSort Depth First and Breadth First Search Abstract Data Types Shuffling an Array

External Data

Creating a Preloader and Progress Bar Simulating Bandwidth Displaying a Preloader for External Content Loading an External Image (  1, 2, 3 ) Connecting to a RSS Feed (  Flash CS4 |  Video  ) Connecting to a Web Service using Flash (  Flash CS5 / FB 4 ) Loading Files from Disk (  1, 2 ) Loading Pictures Dynamically (  Flash 8 |  Video ) XML/Flash Photo Slideshow (  Flash MX 2004 |  1, 2, 3 ) XML/Flash Photo Gallery (  Flash MX 2004 |  1, 2, 3,...,9 ) Calling JavaScript from Flash using AS3

Sound

Playing Sounds from the Library Playing Sounds using ActionScript 3 (  AS 3.0 )   Playing Sounds using ActionScript 1 (  AS 1.0 ) Creating a Sound Bar (  Flash MX ) Reading ID3 Tags in Flash/AS3 Using the Microphone (  Flash MX 2004 ) Working with Dynamic Sound

Special Effects

Fading out Letters in Text Colorful Explosion (  Flash CS4 |  1, 2, 3, 4 ) Collision Detection among Multiple Objects   Advanced Collision Predicting Collisions Elastic Collisions (  1, 2 ) Falling Snow in Flash CS4/AS3  (  Flash CS4/AS3 |  1, 2, 3, 4, 5 )   Flash Snow 3.0 (  Flash 8 |  1, 2 ) Falling Snow 2.0 (  Flash MX 2004 |  1, 2 ) Text Gradient Fills (  Flash 8 |  Video  ) Creating and Animating Clouds (  Flash 8 |  Video  ) Shine Effect  (  1, 2, 3 ) Interactive Image Pan  (  1, 2, 3 ) Sliding Menu (  Flash 8 |  1, 2, 3, 4, 5 ) Zoom Motion Blur (  Flash 8 |  1, 2 ) Digital Clock (  Flash 8 |  Video  ) Gradient Art (  Flash 8 |  1, 2 ) Launch Centered  Window (  Flash 8 |  1, 2 ) Random Jumping (  Flash 8 |  Video  ) Falling Text (  Flash 8 |  Video  ) Apply and Animate Filter Effects (  Flash 8 |  1, 2 ) Flash Video Loops (  Flash 8 |  1, 2, 3 ) Creating a Platform Game (  Flash MX 2004 |  1, 2, 3, 4, 5 ) Hover Captions (  Flash MX 2004 |  1, 2, 3 ) News Ticker (  Flash MX 2004 |  1, 2, 3, 4 ) Duplicate Background (  Flash MX 2004 ) Loading Random Quotes (  Flash MX 2004 |  1, 2 ) Adding Thumbnails (  Flash MX 2004 |  1, 2, 3,...,7 ) Animated Blur (  Flash MX 2004 ) Complex Button RollOut/RollOver Effects Liquify Image Effect (  Flash MX 2004 |  1, 2, 3, 4 ) Coloring Book (  Flash MX 2004 |  1, 2, 3 ) Menu with Slider (  Flash MX 2004 |  1, 2 ) Creating the Shine Effect (  Flash MX 2004 ) Random Motion (  Flash MX 2004 |  1, 2 ) Loading Random Movies (  AS 1 |  1, 2 ) Pausing Animation (  Flash MX 2004 ) Masking Dynamic Text and Device Fonts Film Grain (  Flash MX 2004 ) Transitions between External SWFs (  AS 1 |  1, 2 ) Timeline Effects (  Flash MX 2004 |  1, 2 ) Context Menu (  Flash MX 2004 ) Using CSS Styles (  Flash MX 2004 |  1, 2 ) Applying CSS to Externally Loaded Text Chromeless  Window (  Flash MX 2004 ) Dynamic Mouse Trail Effect  (  Flash CS4 |  1, 2, 3, 4 )   Mouse Trail (  Flash MX ) Date Countdown Timer  (  Flash MX |  1, 2 ) Vibration Effect (  Flash MX ) Creating a Volume Control Slider Falling Snow  (  Flash MX |  1, 2 ) Cartoon Animation (  Flash MX ) Equilibrium Points (  Flash MX ) Grassy Field: Case Study  (  Flash MX |  1, 2 ) The Infinite Menu (  Flash MX ) Easing on Mouse Click (  Flash MX ) Mouse Follow with Easing Alpha Graphic Fade with Inertia (  Flash MX ) News Flasher (  Flash MX ) Circular Movement (  Flash MX ) Launch a Centered  Window (  Flash MX ) Create a Photo Gallery (  Flash MX ) Creating Continuous Movement  (  Flash MX |  1, 2 ) Making Flash Movies Transparent (  Flash MX ) Loading a Random Background  (  Flash MX |  1, 2 ) Random Movement in Flash MX (  Flash MX ) Fractals  (  SUBsection ) Fading Grid  (  Flash MX |  1, 2, 3 ) Creating a Grid in Flash/AS (  AS 1.0 ) Mouse Actions (  AS 1.0 ) Drawing Board: Draw in MX  (  AS 1.0 ) Digital Clock (  AS 1.0 ) ActionScript Text Animation (  AS 1.0 ) Outline Effect (  AS 1.0 ) Analog Clock (  AS 1.0 ) Real Fake Drag Mask (  AS 1.0 ) Advanced Rollovers (  AS 1.0 ) Follow Mouse (  AS 1.0 ) Random Letter Cycling 2.0 (  AS 1.0 )

Isometry

Isometric Transforms (  1, 2, 3, 4 ) Isometric Hit Testing (  1, 2, 3 ) Isometric Perspective Using Grids to Draw Isometric Views Isometric Alternative to 30 Degrees Planning Isometry in Flash Basic Key Movement Different Approach Towards Isometric Positioning Isometric Coded Isometric Grid Development Simple Example Advanced Method w/FLA Basic Movement w/FLA Depth Sorting 3D Movement (Isometry)

Game Development

Making Money from Flash Games (  Video ) Creating a Vertical Shooter (  1, 2, 3, 4 ) RPG Programming (  1, 2, 3, 4, 5, 6, 7 ) Game Story Writing  (  1, 2, 3, 4, 5, 6, 7, 8, 9, 10 ) Game Programming Intro Flowchart Gametypes What makes a Role-Playing Game?