Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread Sant Ram
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

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread priti verma
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

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread priti verma
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

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread priti verma
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

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread David Grugeon
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

$$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-07 Thread Manoj Kumar
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

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-07 Thread Sunny Chauhan
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

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-07 Thread priti verma
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,