Dear Friends, I Sincerely appreciate your suggestions. But i think in both the solutions in column C is taken in to consideration Nowhere Data in the column B is considered. My problem is little complicated. it is not necessary that the same values will come next to each other, and i want the result which is linked with column B also as if the Name in the column B changes it must recalculate the Result. I am again attaching the file with some different combinations.
I am having some 4 files with around 50000 rows each of such kind of data, so there could be N number of combinations in it. Please revert back if u need some more information. Regards Mayank Patel ITC LTD 9822978041 9422749110 On Mon, Apr 27, 2009 at 9:39 PM, Ahmedhonest <ahmedhon...@gmail.com> wrote: > Dear Fabio Lemos, > > I appreciate your solution to the Query but may i know the logic of this > formula how it works plzzzzzzzzzzz > > *=IF(C8<>C7,1,0) <------------- Explain this plz* > > Regards > Ahmed > On Mon, Apr 27, 2009 at 4:31 PM, Fabio Lemos <flnle...@gmail.com> wrote: > >> Hi, >> You can use: >> >> =IF(C8<>C7,1,0) >> >> regards! >> >> 2009/4/27 Mayank Patel <mkpat...@gmail.com> >> >>> Dear Friends >>> >>> Please suggest the formula. >>> sample file is attached. >>> >>> Thanks to all in Advance >>> >>> >>> >>> Regards >>> Mayank Patel >>> ITC LTD >>> 9822978041 >>> 9422749110 >>> >>> >>> >> >> >> -- >> Fabio L Lemos >> >> email: flnle...@gmail.com >> >> >> >> > > > -- > Ahmed Bawazir > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
OUTLET_DATA(1)(1).xls
Description: MS-Excel spreadsheet
