Hi Sajal,
Please find the attached .xlsx. I hope it will help to you.
Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Wed, Aug 1, 2012 at 12:45 P
thanks Kuldeep
I was rather showing an abnormal function or may be bug. When tried with a
macro the results seen erroneous so manually checked what happened...
Mine is more of a data entry requirement than reporting so each time these
cells need alteration and summarizing...
YOurs..sajay
On T
You can try this functions:
Pivot Table
Remove Duplicates
Countif
Vlookup
any more..
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789,9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environm
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
