Excel find duplicate cells except first one

Uses the countif function in excel to find duplicate cells except first one. The formula is =COUNTIF(A$1:A1,A1)>1 If the countif function returns a number greater than one then it means the value is duplicate and the value of the cell will be set to true.     If you want to highlight the cells that [...]

2017-05-10T16:14:26+00:00 May 10th, 2017|Excel|0 Comments

Split workbook to separate excel files

In relation to my previous post I received few queries on how to separate each worksheet in a workbook to separate excel files. If you want to use the VBA code below without altering it, you will need to follow the below steps: 1. Press the keys ALT + F11 to open the Microsoft Visual [...]

2017-03-07T20:32:28+00:00 October 24th, 2016|Excel, VBA|0 Comments