if data is a value(no.) then u cn use countif function which gives u
no.of duplicate value as output
Ex:
AB
789=countif(A1)=2
789=countif(A2)=2
check this if useful.
On Fri, Aug 27, 2010 at 10:42 AM, Pankaj Kumar wrote:
> Hi,
>
> I have a problem i have a lot of data & i want
Hi Frnds,
i also have same Query
As mentioned i tried for the B1-A1 but its not working.as it contains
date and time also,one of my frnd has made macro for the same.i wil gv
it to u tomorrow.
On 3/6/10, Ayush wrote:
> Hi Harpreet,
>
> Simply you can use B1-A1 and change th
