Tech Talk

Lets say you have a column full of data in your excel and you want to find out the duplicates in it: Method 1 - Using Countif function Let's say your data is this Column A Siri Sekhar Sahan Sahiti Sahana Siri Sekhar Sekhar Now in Column B enter the formula in the first cell =CountIF($A$1:$A$8, A1) Then sort the data by Column B and you will know which data is repeated Method 2 - Using Pivot Table In Excel 2013, go to Insert --> Pivot Table When asked to select Table or Range, select the Column A data Now when the pivot table fields are shown select the Column A and drag it to "Row Labels" and "Values" -  Set "Values" to Count This will give you the count of each of the element thus enabling you to find the duplicates.

From all the questions I have been asked about and I have asked mostly are related to Excel Formulas If I filter even further I will find that I am looking for information on vlookup most of the times… Here is one attempt from my end to explain what vlookup is all about. What’s VLOOKUP? Ya ya apart from the obvious answer that its an excel formula, it’s a search function! It can find you matching information from a particular table of data – something similar to a hashtable or dictionary in data structures   You give it an identifier and it will find the corresponding value for it…   Can I get a VLOOKUP Example? Of course! That’s what this blog is about   Jokes apart, here is an example of VLOOKUP Problem Statement: Your boss asks you to find out the work experience in number of years of your team mates Data you have: Now you have to fill in this table to present it to your boss: Now you’ll get the data in columns H, I from C and D – isn’t it? that’s simpl...