Dear Sir, countif function creating more violation for huge data range. is there any possible to overcome or use any other function.
please guide me........... thanks....... On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote: > > Dear sir, > > thank you so much.............your given a great help...... > > > On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote: >> >> Hi >> >> PFA alternate method using formula & help sheet. >> >> Thanks >> >> >> On Tue, Apr 29, 2014 at 8:57 PM, renuka chari <jva....@gmail.com> wrote: >> >>> Dear sir, >>> >>> Thank you so much for your time and effort into problem. >>> >>> my dashboard having huge no of sheets and if i make pivot sheet then my >>> workbook size is increasing more i was applied your formula earlier itself. >>> but i need even better solution. and my dash board data range is not >>> constant if this data set count increase or decrease on daily basis. that >>> scenario every time we are going to apply refresh or expand data option >>> for PIVOT it is time consuming process >>> >>> >>> so kindly think even better output for this problem...... >>> >>> >>> On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote: >>> >>>> Its not possible to do without any help column. >>>> >>>> Another way out is shown in attached file. Ref col E & F. >>>> >>>> Thx >>>> >>>> >>>> On Tue, Apr 29, 2014 at 2:34 PM, renuka chari <jva....@gmail.com>wrote: >>>> >>>>> Dear sir, >>>>> >>>>> i dont want to use pivot. i need only formula for offset or index is >>>>> it possible... >>>>> >>>>> On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote: >>>>> >>>>>> Hi >>>>>> >>>>>> You can do using Pivot Table, see attached file. >>>>>> >>>>>> >>>>>> 1. In the Pivot Table, click the drop down arrow in the RowLabels >>>>>> field heading. >>>>>> 2. In the pop-up menu, click Value Filters, then click Top 10 & >>>>>> change it to 5. >>>>>> >>>>>> You can sort on Descending on Output by going thru More Sort option >>>>>> under filter >>>>>> >>>>>> Cheers! >>>>>> >>>>>> >>>>>> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee < >>>>>> jva....@gmail.com> wrote: >>>>>> >>>>>>> Dear experts, >>>>>>> >>>>>>> please help me >>>>>>> >>>>>>> >>>>>>> Thanks & Regards´¨) >>>>>>> ¸ •´ ¸.•*´¨) ¸.•*¨) >>>>>>> (¸.•´ (¸.•* ♥♥♥...♪♪♪....RenukaChari. Kasee...♥♥♥...♪♪♪ >>>>>>> >>>>>>> P Let us do our best to save nature, save water, plant trees, protect >>>>>>> greenery, keep our surroundings clean, reduce usage of plastics, and >>>>>>> use renewable energy sources. >>>>>>> >>>>>>> -- >>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES >>>>>>> >>>>>>> 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) Jobs posting is not allowed. >>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>> >>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum >>>>>>> owners and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to excel-macros...@googlegroups.com. >>>>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>>>> >>>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> -- >>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES >>>>> >>>>> 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) Jobs posting is not allowed. >>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>> >>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>> and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to excel-macros...@googlegroups.com. >>>>> To post to this group, send email to excel-...@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros...@googlegroups.com. >>> To post to this group, send email to excel-...@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
