Hi i am using excel 2010.i am actually using the following formula =IF(A2=A1,1,0) to find duplicate values.the result is shown as 0, 1, 0 ,1, etc. whenever the values are not duplicate the formula returns 0, 0.now I want to use conditional formatting to highlight only those cases which appear as 0 but only if they are consecutive
I have 5 excel files with the same header shared with 5 different users. I want the 6th excel file named consolidated to be automatically updated as and when any user enter data in the relevant field starting from row 2 as row 1 is the header.I am using excel 2010. Regards
in the Search button above Search by User name and write your kris26: http://www.excelforum.com/search.php?searchid=3158744
Find latest posts