$$Excel-Macros$$ Excel 2010 Remove Duplication

2012-07-31 Thread sajays
Hi.. anobody noticed this? if you try to remove duplicate fields via "Data -> Remove Duplicates" in formulas the result is erroneous.. Just like this A BC 1 TEST1 =B1 2 TEST2 =B2 3 TEST3 =B3 4 TEST4 =B4 5 TEST2 =B5 6 TEST5 =B6 if we try to find duplicates in

$$Excel-Macros$$ Re: Validation

2008-09-09 Thread sajays
just reverse the formula. or xplain little more pls On Sep 6, 1:54 pm, "Ajay Varshney" <[EMAIL PROTECTED]> wrote: > What is the problem? What do you actually want to know? > > There is a formula in column F : =IF(E17<>"","You Cant Left the Cell > Blank","")  this formula means if cell in column E