Hi Rambabu,
I was able to derive the result using formula but was unable to do the same
through validation. PFA the stop-gap solution.
Hope the solution is of some help to you... :)
Thanks
Vinod
On Tue, Mar 1, 2011 at 5:31 PM, Rambabu Mudiraj wrote:
> Dear All,
>
> Can anybody help me on this
Hope i'm not too late in my response... Check out the following:
Connoisseur of Excel
Virtuoso of Excel...
Exceldroit - (Excel + Adroit)
> On Tue, Mar 1, 2011 at 7:39 PM, Ayush Jain wrote:
>
>> Thank you group for all awesome ideas. Though, I was looking for Tagline
>> only, you have p
Congratulations!! Dilipji...
On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote:
> Dear Group,
>
> I am very very very very happy to share a good news with you. One of our
> dearest group member "Dilip Kumar Pandey" is awarded Microsoft MVP award on
> 1st January for his exceptional
; Srinivasan Ethirajalu,
> +919840544295
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
t; <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learn
Hi Janet,
Please enter the date in Excel recognizable format i.e., mm/dd/ instead
of dd/mm/. Then days can be calculated with the formula you have already
entered.
Thanks
Vinod N
On Sat, Sep 18, 2010 at 1:48 PM, janet dickson wrote:
> Hi Team,
>
> I have challenge, see attache
> Hi vinod,
> >
> > You are not sending me any attachment please send solve attachment please
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > regards
> > Vilas
> > On Sat, Aug 28, 2010 at 12:26 PM, Vinod N
t;><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group
mail to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers world
In addition to the above, also please check the following link:
http://chandoo.org/excel-formulas/vlookup.html
<http://chandoo.org/excel-formulas/vlookup.html>Thnx
Vinod N
On Sat, Aug 28, 2010 at 8:04 PM, rajasekhar praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> Hi,
>
Oops Missed to attach the file... Now done...
On Sun, Aug 29, 2010 at 12:56 AM, Vinod N wrote:
> Hi Vilas,
>
> Please select column A and use Text-to-Columns under Data menu... Next
> choose the desired date format from Format--> Cells option.. Solved copy of
> your sa
Hi Vilas,
Please select column A and use Text-to-Columns under Data menu... Next
choose the desired date format from Format--> Cells option.. Solved copy of
your sample file attached...
Thanks
Vinod N
On Sat, Aug 28, 2010 at 7:20 PM, VILAS CHAVAN wrote:
> Hi friends,
>
> Need help
witter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blo
el-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><>&
e notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Thanks and Regards
Vinod N
http://cavinod.blogspot.com/
--
Document (File Name - Today's Date in mmddyy format
> "sub" and number in Column A. For e.g., 073110 sub 4.xlsx) - *Macro
creation pending** - Please HELP*
Thanks
VInod N
On Mon, Aug 9, 2010 at 6:32 AM, pesh wrote:
> Hi Vinod,
>
> This is not the most efficient
Hi Team,
How about nominating Ayush, Dilip, Ankur and Dave for Microsoft MVP...
http://mvp.support.microsoft.com/gp/mvpnominate
--
Thanks and Regards
Vinod N
http://cavinod.blogspot.com/
--
--
Some important
gt;<><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group
7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Thanks and Regards
Vinod N
http://cavinod.blogspot.
Hi,
Please use Data Validation Select the Date option from Allow dropdown
and mention the start and end date in that.
If you are not satisfied with the above please send a sample data and
the group members will reply..
Thanks
Vinod N
On Sat, Jul 10, 2010 at 2:59 PM, Nikhil Shah wrote
) and not
00,000. So relatively for figures are in Lakhs, go to FORMAT CELLS ->
Number-> Custom and in "type" field write *0.0,,* (Zero Dot Zero Comma
Comma). Even though in the respective cell contains 100,000 it will display
as 0.1 only
Hope the above solution, fulfills a part of
-intuitive strategy of giving
the whole book away in one download will work fine.
Thanks for helping to spread the word about the book!
UNQUOTE
Moderators: Correct me if i'm wrong
Thanks
Vinod N
On Sun, May 16, 2010 at 1:46 PM, ayush jain wrote:
> Thanks Dave for heads up.
>
ou can download this Windows Right Management Client only if you
have a Licensed version.
--
Thanks and Regards
Vinod N
http://cavinod.blogspot.com/
On Sat, May 1, 2010 at 8:05 AM, Vijay Aggarwal wrote:
> Hi all,
>
> Is it possible or not?
>
> regards,
> Vijay
>
>
>
l 2007 Compatibility issue,
> Please contact or chat with Microsoft Specialist
>
>
> https://support.microsoft.com/oas/default.aspx?gprid=11346&st=1&wfxredirect=1
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Prashant Tripa
drive as a "Trusted Site" in Excel
3. Re-installed Excel in all the systems...
Please help me
Thanks and Regards
Vinod N
http://cavinod.blogspot.com/
--
--
Some important links for excel users:
1. Follow us
;><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google
Thanks Ankur for your kind words...
On Sat, Jan 30, 2010 at 10:40 AM, ankur wrote:
> very good approach by vinod
>
> krishnan , i think your query has been solved , if not plz explain
> more about it
>
> On 29/01/2010, Vinod N wrote:
>> Hi Gopi,
>>
>> PFA t
blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the g
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Thanks and Regards
Vinod
;<><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-mac
reply/solve even a single query posted... But I have learnt tonnes of
knowledge in the long association with the group...
Kudos to the GURUS...!!
Love u alll
Vinod N
On Fri, Jan 22, 2010 at 11:26 AM, Vinod N wrote:
> Dear Gurus,
>
> Macro or any other way in excel where the user sho
Dear Gurus,
Macro or any other way in excel where the user should be able to delete rows
only if the entire row is empty...
Please help...
--
Thanks and Regards
Vinod N
--
--
Some important links for excel users
Read hear as Hurt
2009/12/24 Vinod N
> Hi Rf1234,
>
> I dint mean to hear ur feelings Dave's reply was more appropriate for
> my requirement.. i need to check the alternative given by you...
>
> Anyways.. Thanks a Tonn!!!
>
> Vinod N
>
> On Thu, Dec 2
Hi Rf1234,
I dint mean to hear ur feelings Dave's reply was more appropriate for my
requirement.. i need to check the alternative given by you...
Anyways.. Thanks a Tonn!!!
Vinod N
On Thu, Dec 24, 2009 at 10:51 AM, Dave Bonallack
wrote:
> Huh?
>
> ---
m UniqArray(1 To UniqColl.Count)
> For i = 1 To UniqColl.Count
> UniqArray(i) = UniqColl(i)
> Next
> 'Optional sort routine can be inserted here
> Range("j3").Resize(UniqColl.Count, 1).Value =
> WorksheetFunction.Transpose(UniqArray)
> End Sub
>
> --
> Than
UniqColl.Count)
For i = 1 To UniqColl.Count
UniqArray(i) = UniqColl(i)
Next
'Optional sort routine can be inserted here
Range("j3").Resize(UniqColl.Count, 1).Value =
WorksheetFunction.Transpose(UniqArray)
Hi Ankur,
When "Tamilnadu" is selected, the Hub validation is not working... all other
regions are working fine... Please check and revert..
A new learning about data validation Thanks a lott...
Thanks
Vinod N
On Tue, Dec 22, 2009 at 3:44 PM, ankur wrote:
> hi mahesh
&
;
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>
> On Sun, Dec 20, 2009 at 9:00 PM, Vinod N wrote:
>
>> Hi Excel Gurus,
>>
>> I have an shared excel file saved in the shared folder...
>>
>> I want to allow users t
Vinod N
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA
gards
Vinod N
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3.
option in tool. Remeber some software do not ask for serial keys. :)
>>
>> Thanks & Best Regards,
>>
>> --
>> DILIP KUMAR PANDEY
>>MBA-HR,B COM(Hons.),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>&
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 12/9/09, Vinod N wrote:
>
>> Hi,
>>
>>
>> Can you suggest any site which will help me in breaki
Hi,
Can you suggest any site which will help me in breaking/cracking the
password ? A year back i had created few macros..but ironically i have
forgotten the password and the macros need to be changed with course of time
and environment...
Thanks
Vinod N
On Mon, Dec 7, 2009 at 5:34 AM
or a day earlier) and the *resultant date** **should not fall on a US
federal holidays,Sat or Sun*
Thanks in advance
Vinod N
On Sun, Oct 4, 2009 at 4:10 PM, Dilip Pandey wrote:
> Hi Vinod,
>
> You can use an inbuilt function of Excel viz. "Workday" to achive the
> req
formula or a Macro..
Your help in this matter is highly appreciated.
--
Thanks and Regards
Vinod N
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
files)
I need to cater many cities and populating this type of report is really
time consuming and i'm ending up stretching in office for about 3-4 hours on
a daily basis
If possible, please suggest an alternative...
--
Thanks and Regards
Vi
46 matches
Mail list logo