Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
Hi I am not sure of this. Thx On Wed, Apr 30, 2014 at 3:34 PM, renuka chari wrote: > Dear Sir thanks alot... > > i have a one doubt i.e my client places they are using Lotus note we are > used to send this dashboard to my client place is this macro would be work > on that place. > > please suggest. > > > On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote: > >> Hi >> >> You can do so by creating UDF. >> >> See UDF sheet. >> >> Thanks >> >> >> On Wed, Apr 30, 2014 at 12:08 AM, renuka chari wrote: >> >>> 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 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 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
Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
Dear Sir thanks alot... i have a one doubt i.e my client places they are using Lotus note we are used to send this dashboard to my client place is this macro would be work on that place. please suggest. On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote: > > Hi > > You can do so by creating UDF. > > See UDF sheet. > > Thanks > > > On Wed, Apr 30, 2014 at 12:08 AM, renuka chari > > wrote: > >> 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 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 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
Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
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 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 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 G
Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
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 > > 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 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 > 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. >>> >>>
Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
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 > > 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 >>> 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 sec
Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
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 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 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+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. > -- 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. Return Top5.xlsx Description:
Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
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 > > > 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+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.
Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
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 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+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. > -- 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. Return Top5.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
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+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. Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
