Re: $$Excel-Macros$$ Need City in Blanck Coloume.
Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in we will provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 11:26 AM, priti verma pritiverma1...@gmail.comwrote: Hi Sunnny , sometime its better to think very simple , we can use Index match as an array formula but if you have a large data you can have a slow and a heavy workbook. so i think of sorting data with if function . let me know if you have any question on this regards Priti verma On Tue, May 7, 2013 at 10:26 PM, Sunny Chauhan sunnyc...@gmail.comwrote: Hi Priti, Have you checked your solution. it's working fine? (Please sort the data and check) Priti please don't put inoperable solution.. its my request On Tue, May 7, 2013 at 7:28 PM, priti verma pritiverma1...@gmail.comwrote: Hi Manoj, Please see the attachment Regards, Priti verma On Tue, May 7, 2013 at 6:13 PM, Manoj Kumar manoj.11...@gmail.comwrote: Dear Expert. please help to solve query. regd Manoj -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Re: $$Excel-Macros$$ Need City in Blanck Coloume.
Thanks for your suggestion, i know what i need to do .. On Wed, May 8, 2013 at 5:05 PM, Sant Ram santram...@gmail.com wrote: Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in this group we will try to provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 5:04 PM, Sant Ram santram...@gmail.com wrote: Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in we will provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 11:26 AM, priti verma pritiverma1...@gmail.comwrote: Hi Sunnny , sometime its better to think very simple , we can use Index match as an array formula but if you have a large data you can have a slow and a heavy workbook. so i think of sorting data with if function . let me know if you have any question on this regards Priti verma On Tue, May 7, 2013 at 10:26 PM, Sunny Chauhan sunnyc...@gmail.comwrote: Hi Priti, Have you checked your solution. it's working fine? (Please sort the data and check) Priti please don't put inoperable solution.. its my request On Tue, May 7, 2013 at 7:28 PM, priti verma pritiverma1...@gmail.comwrote: Hi Manoj, Please see the attachment Regards, Priti verma On Tue, May 7, 2013 at 6:13 PM, Manoj Kumar manoj.11...@gmail.comwrote: Dear Expert. please help to solve query. regd Manoj -- 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?hl=en . For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
Re: $$Excel-Macros$$ Need City in Blanck Coloume.
Dear Sant Ram, You may note that in the original query there was nothing related to the sorting and I tried to apply a different and simple approach which works without the sorting so the solution is not inoperable and if the data is not sorted, it is not temporary also. You can find problems with any solution provided by anyone and I think you guys are working hard to do it. You or anyone else can point out any mistake in any of the solutions, but twisting with the query and adding scenarios just for the sake of objecting is not in the right spirit. I agree with you that we people try and provide solutions but we do it voluntarily and if there is any problem with the solution, the one who asked the query always points it out. I just don't see the point in jumping in between, adding new things and judging people without any application of mind. The only reason, other people should judge the solutions of other's query could be learning, which I am sure is not the intention here. If I wanted to increase my post counts, there are many other ways to do it rather than actually trying to resolve the query. Hope this makes sense to you. Regards, Priti On Wed, May 8, 2013 at 5:11 PM, priti verma pritiverma1...@gmail.comwrote: Thanks for your suggestion, i know what i need to do .. On Wed, May 8, 2013 at 5:05 PM, Sant Ram santram...@gmail.com wrote: Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in this group we will try to provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 5:04 PM, Sant Ram santram...@gmail.com wrote: Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in we will provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 11:26 AM, priti verma pritiverma1...@gmail.comwrote: Hi Sunnny , sometime its better to think very simple , we can use Index match as an array formula but if you have a large data you can have a slow and a heavy workbook. so i think of sorting data with if function . let me know if you have any question on this regards Priti verma On Tue, May 7, 2013 at 10:26 PM, Sunny Chauhan sunnyc...@gmail.comwrote: Hi Priti, Have you checked your solution. it's working fine? (Please sort the data and check) Priti please don't put inoperable solution.. its my request On Tue, May 7, 2013 at 7:28 PM, priti verma pritiverma1...@gmail.comwrote: Hi Manoj, Please see the attachment Regards, Priti verma On Tue, May 7, 2013 at 6:13 PM, Manoj Kumar manoj.11...@gmail.comwrote: Dear Expert. please help to solve query. regd Manoj -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
Re: $$Excel-Macros$$ Need City in Blanck Coloume.
and one more thing best solutions with no acknowledgement whatsoever On Wed, May 8, 2013 at 5:46 PM, priti verma pritiverma1...@gmail.comwrote: Dear Sant Ram, You may note that in the original query there was nothing related to the sorting and I tried to apply a different and simple approach which works without the sorting so the solution is not inoperable and if the data is not sorted, it is not temporary also. You can find problems with any solution provided by anyone and I think you guys are working hard to do it. You or anyone else can point out any mistake in any of the solutions, but twisting with the query and adding scenarios just for the sake of objecting is not in the right spirit. I agree with you that we people try and provide solutions but we do it voluntarily and if there is any problem with the solution, the one who asked the query always points it out. I just don't see the point in jumping in between, adding new things and judging people without any application of mind. The only reason, other people should judge the solutions of other's query could be learning, which I am sure is not the intention here. If I wanted to increase my post counts, there are many other ways to do it rather than actually trying to resolve the query. Hope this makes sense to you. Regards, Priti On Wed, May 8, 2013 at 5:11 PM, priti verma pritiverma1...@gmail.comwrote: Thanks for your suggestion, i know what i need to do .. On Wed, May 8, 2013 at 5:05 PM, Sant Ram santram...@gmail.com wrote: Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in this group we will try to provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 5:04 PM, Sant Ram santram...@gmail.com wrote: Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in we will provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 11:26 AM, priti verma pritiverma1...@gmail.comwrote: Hi Sunnny , sometime its better to think very simple , we can use Index match as an array formula but if you have a large data you can have a slow and a heavy workbook. so i think of sorting data with if function . let me know if you have any question on this regards Priti verma On Tue, May 7, 2013 at 10:26 PM, Sunny Chauhan sunnyc...@gmail.comwrote: Hi Priti, Have you checked your solution. it's working fine? (Please sort the data and check) Priti please don't put inoperable solution.. its my request On Tue, May 7, 2013 at 7:28 PM, priti verma pritiverma1...@gmail.com wrote: Hi Manoj, Please see the attachment Regards, Priti verma On Tue, May 7, 2013 at 6:13 PM, Manoj Kumar manoj.11...@gmail.comwrote: Dear Expert. please help to solve query. regd Manoj -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
Re: $$Excel-Macros$$ Need City in Blanck Coloume.
Priti, You are absolutely right. It is up to the person who raised the query to test sugestested solutions and respond. If it is not working to say in what respect it is not working, If it is working to acknowledge that. Regards David Grugeon On 8 May 2013 22:16, priti verma pritiverma1...@gmail.com wrote: Dear Sant Ram, You may note that in the original query there was nothing related to the sorting and I tried to apply a different and simple approach which works without the sorting so the solution is not inoperable and if the data is not sorted, it is not temporary also. You can find problems with any solution provided by anyone and I think you guys are working hard to do it. You or anyone else can point out any mistake in any of the solutions, but twisting with the query and adding scenarios just for the sake of objecting is not in the right spirit. I agree with you that we people try and provide solutions but we do it voluntarily and if there is any problem with the solution, the one who asked the query always points it out. I just don't see the point in jumping in between, adding new things and judging people without any application of mind. The only reason, other people should judge the solutions of other's query could be learning, which I am sure is not the intention here. If I wanted to increase my post counts, there are many other ways to do it rather than actually trying to resolve the query. Hope this makes sense to you. Regards, Priti On Wed, May 8, 2013 at 5:11 PM, priti verma pritiverma1...@gmail.comwrote: Thanks for your suggestion, i know what i need to do .. On Wed, May 8, 2013 at 5:05 PM, Sant Ram santram...@gmail.com wrote: Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in this group we will try to provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 5:04 PM, Sant Ram santram...@gmail.com wrote: Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in we will provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 11:26 AM, priti verma pritiverma1...@gmail.comwrote: Hi Sunnny , sometime its better to think very simple , we can use Index match as an array formula but if you have a large data you can have a slow and a heavy workbook. so i think of sorting data with if function . let me know if you have any question on this regards Priti verma On Tue, May 7, 2013 at 10:26 PM, Sunny Chauhan sunnyc...@gmail.comwrote: Hi Priti, Have you checked your solution. it's working fine? (Please sort the data and check) Priti please don't put inoperable solution.. its my request On Tue, May 7, 2013 at 7:28 PM, priti verma pritiverma1...@gmail.com wrote: Hi Manoj, Please see the attachment Regards, Priti verma On Tue, May 7, 2013 at 6:13 PM, Manoj Kumar manoj.11...@gmail.comwrote: Dear Expert. please help to solve query. regd Manoj -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
$$Excel-Macros$$ Need City in Blanck Coloume.
Dear Expert. please help to solve query. regd Manoj -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Dummy.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need City in Blanck Coloume.
Hi Priti, Have you checked your solution. it's working fine? (Please sort the data and check) Priti please don't put inoperable solution.. its my request On Tue, May 7, 2013 at 7:28 PM, priti verma pritiverma1...@gmail.comwrote: Hi Manoj, Please see the attachment Regards, Priti verma On Tue, May 7, 2013 at 6:13 PM, Manoj Kumar manoj.11...@gmail.com wrote: Dear Expert. please help to solve query. regd Manoj -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Need City in Blanck Coloume.
Hi Sunnny , sometime its better to think very simple , we can use Index match as an array formula but if you have a large data you can have a slow and a heavy workbook. so i think of sorting data with if function . let me know if you have any question on this regards Priti verma On Tue, May 7, 2013 at 10:26 PM, Sunny Chauhan sunnyc...@gmail.com wrote: Hi Priti, Have you checked your solution. it's working fine? (Please sort the data and check) Priti please don't put inoperable solution.. its my request On Tue, May 7, 2013 at 7:28 PM, priti verma pritiverma1...@gmail.comwrote: Hi Manoj, Please see the attachment Regards, Priti verma On Tue, May 7, 2013 at 6:13 PM, Manoj Kumar manoj.11...@gmail.comwrote: Dear Expert. please help to solve query. regd Manoj -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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