$$Excel-Macros$$ Re: Something is missing

2010-04-10 Thread Ayush
I am posting the first idea :- 1) There should be an inbuilt feature of converting number into words. 2) Vlookup searches only in leftmost column of range, why not rightmost or middle column ? Now its your turn :) On Apr 11, 10:59 am, Ayush wrote: > Dear members, > > Most of us work in excel da

Re: $$Excel-Macros$$ Re: Something is missing

2010-04-11 Thread Abhishek Jain
Thanks Ayush. My tuppence: Extracting unique vales from a range with a function or formula is missing. Using Advanced Filter every time is a bit lengthy process. It should be something like =UNIQUEVALUES(A1:A100). I got a workaround for the above though ;-) but I think it should reside in Excel

Re: $$Excel-Macros$$ Re: Something is missing

2010-04-12 Thread Anand Desai
Ayush, Spellcheck the way available in MS Word.. my be useful.. I m not sure any facility is available or not? Anand On Mon, Apr 12, 2010 at 11:33 AM, Abhishek Jain wrote: > Thanks Ayush. > > My tuppence: > > Extracting unique vales from a range with a function or formula is missing. > Using Ad

Re: $$Excel-Macros$$ Re: Something is missing

2010-04-12 Thread Abhishek Jain
I think it is available.The only thing is it does not red-underlines the miss-spelled words as MS Word does. Abhishek On Mon, Apr 12, 2010 at 11:54 AM, Anand Desai wrote: > Ayush, > > Spellcheck the way available in MS Word.. my be useful.. I m not sure any > facility is available or not? > >

Re: $$Excel-Macros$$ Re: Something is missing

2010-04-12 Thread Anand Desai
Abhishek, I know about spellcheck feature. red-underlines are useful and time saving.. Anand On Mon, Apr 12, 2010 at 1:20 PM, Abhishek Jain wrote: > I think it is available.The only thing is it does not red-underlines the > miss-spelled words as MS Word does. > > > Abhishek > > On Mon, Apr 12

Re: $$Excel-Macros$$ Re: Something is missing

2010-04-16 Thread Ayush
Any More inputs on this ? Come on groupPlease share :) On Apr 12, 1:40 pm, Anand Desai wrote: > Abhishek, > > I know about spellcheck feature. red-underlines are useful and time saving.. > > Anand > > On Mon, Apr 12, 2010 at 1:20 PM, Abhishek Jain wrote: > > > I think it is available.The onl

Re: $$Excel-Macros$$ Re: Something is missing

2010-04-16 Thread Harpreet Singh Gujral
Totally agree, If excel has the feature, that it automatically checks, whichever cell has been changed, should be spell checked. But at the same time, it should have the feature to also disable it, because, Excel is used for a wide variety of Data Mining things, and if the feature cannot be diable