Anil it s not the count of loads.. i need the count of distinct values for every load no
ie Load 0241 7151865O 7154687O 7175843O 7202990O 7212856O 7253406O has 6 values both from top row and bottom row.. so 6 should be the output for load 0241 in some case as u see, some loads have 3 rows of data... i want to calc count of unique values in all three file attached again hope that helps On Fri, Apr 27, 2012 at 5:43 AM, anil panchal <anil.kan...@gmail.com> wrote: > Dear Sara,a > > Its Working Fine please find the attached file. > > Thanks & Regards > Anil Kumar > 9999113784 > > On Fri, Apr 27, 2012 at 2:52 PM, Darwin Chan > <darwin.chankaw...@gmail.com>wrote: > >> See if you understand array formula. >> >> http://www.excelfunctions.net/Excel-Array-Formulas.html >> >> >> 2012/4/27 Sara Lee <lee.sar...@gmail.com> >> >>> thee are two similar rows with same load no---this is not working >>> >>> On Fri, Apr 27, 2012 at 4:06 AM, anil panchal <anil.kan...@gmail.com>wrote: >>> >>>> you can use >>>> >>>> =SUMPRODUCT(--($A$2:$A$23=AB2)) >>>> >>>> >>>> >>>> >>>> On Fri, Apr 27, 2012 at 1:26 PM, Sara Lee <lee.sar...@gmail.com> wrote: >>>> >>>>> yes i need count of distinct records for each load no-- sample output >>>>> >>>>> load 0241 6 >>>>> load 0242 3 >>>>> load 0245 2 >>>>> load 0246 2 >>>>> >>>>> >>>>> On Fri, Apr 27, 2012 at 3:45 AM, Abhishek Jain <abhishek....@gmail.com >>>>> > wrote: >>>>> >>>>>> Actually count of values stored in adjacent columns of each load >>>>>> number is required. For Load 0241 - there are 6 values so the formula >>>>>> should return 6. >>>>>> >>>>>> >>>>>> >>>>>> On Fri, Apr 27, 2012 at 1:09 PM, Darwin Chan < >>>>>> darwin.chankaw...@gmail.com> wrote: >>>>>> >>>>>>> Hi Sara, >>>>>>> >>>>>>> Seems formula COUNTIF can solve your problem simply. >>>>>>> >>>>>>> 2012/4/27 Sara Lee <lee.sar...@gmail.com> >>>>>>> >>>>>>>> hi >>>>>>>> >>>>>>>> i have data as in the attached data. i need count of unique values >>>>>>>> of column A.... i.e i need output as in column AB, AC... pls advise a >>>>>>>> formula thanks >>>>>>>> >>>>>>>> -- >>>>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>>>> >>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>>> Advice will not get quick attention or may not be answered. >>>>>>>> >>>>>>>> 2) Don't post a question in the thread of another member. >>>>>>>> >>>>>>>> 3) Don't post questions regarding breaking or bypassing any >>>>>>>> security measure. >>>>>>>> >>>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>>> >>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this >>>>>>>> forum in signatures are prohibited. >>>>>>>> >>>>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>>>> Forum owners and members are not responsible for any loss. >>>>>>>> >>>>>>>> >>>>>>>> ------------------------------------------------------------------------------------------------------ >>>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Best Regards, >>>>>>> Darwin Chan >>>>>>> darwin.chankaw...@gmail.com >>>>>>> kw42c...@yahoo.com.hk >>>>>>> >>>>>>> -- >>>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>> Advice will not get quick attention or may not be answered. >>>>>>> >>>>>>> 2) Don't post a question in the thread of another member. >>>>>>> >>>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>>> measure. >>>>>>> >>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>> >>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>>>> in signatures are prohibited. >>>>>>> >>>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>>> Forum owners and members are not responsible for any loss. >>>>>>> >>>>>>> >>>>>>> ------------------------------------------------------------------------------------------------------ >>>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>>> >>>>>> >>>>>> -- >>>>>> FORUM RULES (986+ members already BANNED for violation) >>>>>> >>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>> Advice will not get quick attention or may not be answered. >>>>>> >>>>>> 2) Don't post a question in the thread of another member. >>>>>> >>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>> measure. >>>>>> >>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>> >>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>>> in signatures are prohibited. >>>>>> >>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>> Forum owners and members are not responsible for any loss. >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------------------------------ >>>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>>> >>>>> >>>>> -- >>>>> FORUM RULES (986+ members already BANNED for violation) >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> >>>>> 2) Don't post a question in the thread of another member. >>>>> >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> >>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> >>>>> >>>>> ------------------------------------------------------------------------------------------------------ >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>> >>>> >>>> >>>> -- >>>> >>>> >>>> >>>> Thanks & Regards >>>> Anil Kumar >>>> >>>> -- >>>> FORUM RULES (986+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> >>>> 2) Don't post a question in the thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> >>>> 4) Acknowledge the responses you receive, good or bad. >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> >>>> >>>> ------------------------------------------------------------------------------------------------------ >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> >> >> -- >> Best Regards, >> Darwin Chan >> darwin.chankaw...@gmail.com >> kw42c...@yahoo.com.hk >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > > > > Thanks & Regards > Anil Kumar > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
Book2.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
