Dear All
I Wish you a very Happy Diwali and pray for you that you have a
prosperous new year ahead.
Diwali is celebrate all over India.
May God Bless U Fulfill all your Dreams.
Take care of yourself and play safe.
Thanks Regards
AYUSH JAIN
Group Owner
queries and make this
a best group.
If you find use of abusive language or any mis-happening in the group,
Please directly mail to me @ [EMAIL PROTECTED] or
[EMAIL PROTECTED]
Thank you all for your contribution.
Best regards,
Ayush Jain
--~--~-~--~~~---~--~~
Visit
on regular period. Please inform the group to download the
material that you have published as soon as possible before I delete
them.
I really really appreciate your participation in the group. Please
contact me if you have any concerns.
KEEP POSTING !!
Thanks.
Ayush Jain
(Group Manager
://exceldailytip.blogspot.com
Any comments would be highly appreciated.
Please share these tips with your friends and associates. You
are one of the 2300 members around the world.
If you have any tips,please share it in the group.
Thanks Best Regards,
Ayush Jain
Group Manager
, Go to:
http://exceldailytip.blogspot.com
Any comments would be highly appreciated.
Please share these tips with your friends and associates. You
are one of the 2500 members around the world.
If you have any tips,please share it in the group.
Thanks Best Regards,
Ayush Jain
Group Manager
://exceldailytip.blogspot.com
Any comments would be highly appreciated.
Please share these tips with your friends and associates. You
are one of the 2600 members around the world.
If you have any tips,please share it in the group.
Thanks Best Regards,
Ayush Jain
Group Manager
Excel Tips, Go to:
http://exceldailytip.blogspot.com
Any comments would be highly appreciated.
Please share these tips with your friends and associates. You
are one of the 2600 members around the world.
If you have any tips,please share it in the group.
Thanks Best Regards,
Ayush Jain
Group Manager
, My GREAT thanks to all elite members listed in home page
who are continuously helping 5000 members of the group.
I really appreciate your knowledge and courage to help people free of cost.
This is really astonishing !!! Keep it up !!
Keep posting !!
Best regards,
Ayush Jain
an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 group, please send an email to:
Ayush
Hello all,
The issue of Debasis banerjee is resolved. The auto calculation
setting was disabled which is now enabled.
Best regards,
Ayush Jain
On Jul 25, 2:29 pm, Daniel dcolarde...@free.fr wrote:
Try opening it with Open Office.
Daniel
From: excel-macros@googlegroups.com [mailto:excel
://www.vbamacros.blogspot.com
4. 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 group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
HELP US GROW
Hello All,
Please find attached input and desired output of Pinky.
Thanks for your help,
Ayush Jain
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
of tips and
tricks.
DO let me know if you need any clarifications.
Let me begin by submitting the first tip for this week competition.
---
Name : Ayush Jain
from the group.
Hi Mageshwaran,
Please don't do this again in future.
Hi TAIgo,
Our apologies to you. Thanks for keeping us updated about such violation
KEEP POSTING !
Best regards,
Ayush Jain
--- On Sat, 1/8/09, mageshwaran jayaraman macwa...@yahoo.co.in wrote:
From: mageshwaran jayaraman
, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
HELP US GROW !!
We reach over 5,200 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let
any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000
Hi Upendra,
Thanks for your inputs. I totally agree with your guidelines and request
members to adhere the same.
Dear members,
Please follow the guidelines as suggested by Upendra. Any member not
following this shall be banned. Let me know if you have any concerns.
Best regards,
Ayush Jain
Hi Upendra,
Thanks for your inputs. I totally agree with your guidelines and request
members to adhere the same.
Dear members,
Please follow the guidelines as suggested by Upendra. Any member not
following this shall be banned. Let me know if you have any concerns.
Best regards,
Ayush Jain
.
Attached is the solution for your reference. Let us know if you have further
queries.
Best regards,
Ayush Jain
Group Owner
--- On Sun, 18/10/09, mahesh parab mahes...@gmail.com wrote:
From: mahesh parab mahes...@gmail.com
Subject: $$Excel-Macros$$ if condition based on two cell value
To: excel
to trust the certificate. Click the
don't ask this again box, and then click yes.
Next when you will open the excel file , it will not show any warning
Let us know if above steps helps or not.
Thanks and best regards,
Ayush Jain
--- On Sun, 18/10/09, karthikeyan karthikeyansankar...@gmail.com
).AutoFilter Field:=13,
Criteria1:= _
9-Jul-2009, Operator:=xlAnd, Criteria2:==13-Jul-2009
'***
Worksheets(Cover Page).Select
Range(A2).Select
End Sub
Best regards,
Ayush Jain
--- On Sat, 14/11
Hi Abhishek,
Jai Jinendra ! You are most welcome !
Attached is the updated solution. Please see the file and let me know if this
is the desired solution. I have added data validation in column E.
Best regards,
Ayush Jain
[Group Manager Owner]
--- On Sun, 15/11/09, Abhishek Jain abhishek
Hi Joginder,
Requesting a password recovery software is against forum rules. Please do
not post such request again.
Regards
-- Forwarded message --
From: xlstime xlst...@gmail.com
Date: Tue, Mar 6, 2012 at 3:59 PM
Subject: spam Re: $$Excel-Macros$$
To: Ayush Jain jainayus
You always rock Noorain. This is really a great skill.
Thanks for writing poem and your great contribution to forum
-Ayush Jain
On Thursday, 22 March 2012 18:42:08 UTC, NOORAIN ANSARI wrote:
जहाँ Excel के दीवानों की, है बहूत घनी आबादी.
जहाँ Question,Answer करने की,है खूब आज़ादी
banned from the forum. if you see any such email, Please report
@jainayus...@gmail.com
Thanks
On Thursday, 5 April 2012 09:13:46 UTC+1, Asa R. wrote:
Is that what that was? It went right over my head! :)
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com]
BANNED
On Wednesday, 18 April 2012 02:35:12 UTC+1, Asa R. wrote:
Must be sending to all contacts. I believe it's some kind of
solicitation--obviously misdirected--but based on info so far (3 of these
emails in 2 days, hasn't responded to list questions about the messages), I
think
Thank you everyone.
Regards
Ayush Jain
On Friday, 27 April 2012 05:35:18 UTC+5:30, Sam Mathai Chacko wrote:
Happy Birthday Ayush. Have a great new year.
REgards,
Sam Mathai CHacko
On Fri, Apr 27, 2012 at 3:24 AM, Michael Brumby mikebru...@yahoo.comwrote:
*Happy birthday
posting jobs will be banned without any warning.
Let me know if you have any questions.
Regards
Ayush Jain
Group Manager and Microsoft MVP
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
for your understanding.
Regards
Ayush Jain
Group Manager
Microsoft MVP
On Mon, May 21, 2012 at 9:37 PM, Mangesh Dayne mangesh.da...@gmail.comwrote:
Hi All,
Welcome decision.
In addition, it is also good that job posting should be related to excel,
vba only.
Our objective is to make universal
Sai Girish is banned
Regards
Ayush Jain
On Thursday, 24 May 2012 22:42:55 UTC+5:30, hilary lomotey wrote:
Why do you keep sending this ad over and over again.
Sent from my BlackBerry® smartphone from Airtel Ghana
--
*From: *sai girish saigiris...@gmail.com
Hello everyone,
I hope the book which is being shared in this thread is free ebook and not
the paid one.
I am strongly against sharing pirated copies without the consent of author.
Let me know if you have any queries.
Thanks.
Regards
Ayush Jain
Group Manager Microsoft MVP
Thanks guys for your support.
I have banned that user.
Regards
Ayush Jain
On Friday, 8 June 2012 21:50:25 UTC+5:30, sandeep chhajer wrote:
Hi Ayush, Noorain and all mentor,
You all are the best mind in the field of Information Technology. So
please do needful to stop this type of cross
Dear all,
Good to know you all and feels proud to be part of this forum.
Let me introduce myself.
I am Ayush Jain from Delhi, India. Presently working as senior analyst in
Ernst Young and my work includes bulding Excel Access based models for
clients for analysis, reporting, planning etc.
I
Nazia Menaz is banned.
-Ayush
On Sunday, 10 June 2012 17:32:13 UTC+5:30, Ashish wrote:
What has this link to do with Excel??
Thanks
Ashish Pradhan
On 10-06-2012 17:31, Nazia Menaz wrote:
Please Add Your Id This Link
http://shorttextmassages.blogspot.com/
--
FORUM RULES (986+
Dev Karan is banned.
Regards
Ayush Jain
On Thursday, 14 June 2012 02:48:03 UTC+5:30, Dev Karan wrote:
Dear Friend,
We need your help for following open position:
*Mail Resumes to: d...@tecknowledgie.com*
*
*
*ATG - Java J2EE Developer*
* *
*Duration : 3 - 6 month contract to hire
as right most option when you post using google groups.
https://lh5.googleusercontent.com/-MXyhghaaziM/T9l1OYPeoVI/AWo/LKudJuFrQ5Q/s1600/highlight_code.JPG
An example is given at the end.
Please use this feature in your postings going forward.
Thank you.
Regards
Ayush Jain
Group Manager
Jacob John is banned.
-Ayush Jain
On Thursday, 14 June 2012 22:53:13 UTC+5:30, Jacob john wrote:
Hello Consultant,
Please let me know if you are interested in this requirement. If yes,
kindly send us your
resume along with contact information.
If you are not looking for new projects
Hi Yogananda,
Please note that Job posting is allowed in this forum. Please do not post
any jobs going forward.
Thanks.
On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote:
Hi,
We have a opening for MIS - Executive in Bangalore location. Do call my
below number on
Hi Yogananda,
Please note that Job posting is *NOT* allowed in this forum. Hence, do not
post any jobs going forward.
Thanks.
On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote:
Hi,
We have a opening for MIS - Executive in Bangalore location. Do call my
below
where
you can post the jobs.
For now, Job posting is NOT allowed in forum. Let me know if you still have
any queries.
Thanks and best regards
Ayush Jain
Group Manager
Microsoft MVP
On Mon, Jun 18, 2012 at 10:21 PM, yogananda muthaiah
yogananda.mutha...@gmail.com wrote:
Hi,
Thank you everyone
the scope of this forum limited to excel related queries only,
Regards
Ayush Jain
On Mon, Jun 18, 2012 at 11:25 PM, in.vaib...@gmail.com wrote:
**
Hi Ayush,
Why can't we have separate team of moderator like other sites.
--
*From: *Ayush Jain jainayus...@gmail.com
Thanks everyone and welcome to this group !!
Keep introducing yourself and keep this thread alive.
Regards
Ayush Jain
On Thursday, 21 June 2012 21:41:19 UTC+5:30, Rajan_Verma wrote:
Dubey G
Welcome on the group J
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk
Don,
You are valuable to this forum and a star performer.
We really admire you and appreciate your great contribution to this forum.
Regards
Ayush Jain
On Sun, Jul 1, 2012 at 10:34 PM, dguillett1 dguille...@gmail.com wrote:
And, Don Guillett was not re selected.
Don Guillett
Microsoft
Thanks Dilip and everyone for your great contribution to this forum.
The forum is really doing well and we will achieve more and more milestones.
Together we can and we will make a difference.
Cheers,
Ayush Jain
On Wed, Jul 4, 2012 at 5:11 PM, Indrajit $nai talk2indra...@gmail.comwrote
Thanks and Regads,
Pankaj Michael
On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
I am extremely happy to inform you that two members of the group are
awarded Microsoft Most Valuable Professional Award.
My heartiest congratulations to *Ashish koul
it for
you.
Best regards,
Ayush Jain
On Dec 22, 10:55 pm, Andre Gobet andre.go...@sesamnet.ch wrote:
Hello
I've a list in Excel of about 1000 e-mail adresses from our internal
Database. Now i want to extract from this list only the domain names
to put in to our Spam Filter for Whitelisting
Dear Group,
The below mail is on behalf of Karthik Seshadri. Its a good opportunity for
bangalore job seekers.
Cheers. Merry Christmas :)
Best regards,
Ayush Jain
Group Owner
Hi ,
I am Karthik and I work for a MNC in bangalore
I am looking for profiles of people who are good in VBA and MS
queries.
Best regards,
Ayush Jain
Group owner
--- On Sat, 26/12/09, Shamit Shailesh shamitshail...@rediffmail.com wrote:
From: Shamit Shailesh shamitshail...@rediffmail.com
Subject: $$Excel-Macros$$ max_units_on_a_day
To: excel-macros@googlegroups.com
Date: Saturday, 26 December, 2009, 4:10 PM
Dear
Ayush Jain has sent you a link to a blog:
Dear Group, One more tip for youAvailable in Excel 2003 and 2007
both. Thanks. Follow us on Twitter @ http://twitter.com/exceldailytip
Blog: Excel Daily Tip
Post: Tip # 49 The Camera Tool in Excel
Link:
http://exceldailytip.blogspot.com/2009/04/tip
Hi MRafique,
You can use pivot tables for all the 6 sheets and which will have source
data as master sheet.
It would be easier if you could provide the data to our forum to help you.
Thanks and best regards,
Ayush Jain
On Sun, Jan 17, 2010 at 3:48 PM, MRafique Ujjan imrafiqu...@gmail.comwrote
settings, you just need to add
that add-in to your workbook no extra efforts.
Let us know if you need any further help on this.
Best regards,
Ayush Jain
[Group Owner]
On Sun, Jan 17, 2010 at 3:47 AM, Markkim mark@gmail.com wrote:
Hi
Well, it has happened to me many times.. but I have never
,
Ayush Jain
On Sun, Jan 24, 2010 at 1:17 PM, San Pat myitems2...@gmail.com wrote:
Hi Friends,
I am exporting stock (Gain/Loss) data from the web which has multiple buys
of the same company. Please see the attached excel file (Exported data)
Is there any way I can group this same company data
know if you still have any questions.
Best regards,
Ayush Jain
On Mon, Jan 25, 2010 at 7:12 AM, San Pat myitems2...@gmail.com wrote:
Hi Ayush,
Thanks for your help.
But the pivot table will not auto refresh the data if there is any change
in other sheet?
I am trying to find a formula
Hi Steve,
Attached is the solution.
Column H : the formula extracts location code from column A based on last
two characters of cell
Column I : The formula assigns the location based on the location code.
Please let us know if you need any further help.
Best regards,
Ayush Jain
On Mon, Jan 25
in all your communications.
Best regards,
Ayush Jain
Group owner
On Mon, Jan 25, 2010 at 9:22 AM, San Pat myitems2...@gmail.com wrote:
Hi Ayush,
Can you please send me the macro which will automatically refresh the
pivot?
So how this auto refresh macro will work? Do I need to assign to any
Dear Atul,
Use Rank formula for ranking of data. Attached is the solution for you.
Let us know if further help is required.
Best regards,
Ayush Jain
Group Owner
On Tue, Jan 26, 2010 at 10:00 AM, Atul atul_pate...@yahoo.com wrote:
Hi,
Following is the list of financial Institution
know.
Thanks and best regards,
Ayush Jain
Group Owner
On Mon, Jan 25, 2010 at 10:01 PM, harish chandru
harish.chan...@gmail.comwrote:
Hi All,
May I kindly request you to help me out on the below
attached spreadsheet query..
I need it today as i need to submit this tomorrow morg in my class
if any further help is required.
Best regards,
Ayush Jain [Group Owner]
On Tue, Jan 26, 2010 at 5:08 AM, Wilbur Kush ocwil...@gmail.com wrote:
I have a scale that inputs data into excel via rskey, a keyboard
emulator that comes with the scale. No problems getting the data into
excel from
Dear Atul,
Attached is the solution for unique rank. Let us know if you need any
further help.
Best regards,
Ayush Jain
[Group Owner]
On Wed, Jan 27, 2010 at 10:15 AM, Atul atul_pate...@yahoo.com wrote:
Hi Dilip and Ayush,
Thanks for responding quickly with the solution. As per the solution
modules ?
Public rngNetLineAmt as range
Set rngNetLineAmt = Sheets(M-RAW).Range(AQ:AQ)
If i use above code outside the procedure..it does not work and throws
error.
Kindly advise.
Thank you so much.
-Ayush Jain
Hi Madajah,
Attached is the updated solution with the new condition.
Best regards,
Ayush Jain
Group Owner
On Fri, Feb 5, 2010 at 5:43 PM, Putta Madaiah puttamada...@gmail.comwrote:
Hi Ayush,
Thanks for the formulas. It will be great also if you can consider only for
N under column 'Doc
jain jainayus...@gmail.com wrote:
Dear Imran,
Attached is the solution. Use MID function to separate the Text in
different cells.
Let us know if any further help is required.
Best regards,
Ayush Jain
On Sun, Feb 7, 2010 at 10:40 AM, Imran khan ikha...@gmail.com wrote:
Dear Friends
= xlSheetHidden
End If
Next
End Sub
Let us know if any further help is required.
Thanks and best regards,
Ayush Jain
On Sun, Feb 7, 2010 at 3:01 PM, Yahya yahya...@gmail.com wrote:
Hi
I have a workbook which has a no of worksheets. I want to hide all those
worksheets
Hello Shiv,
Thanks so much for help solution i am surprised to see that sumif
function does not work this way. We have to use combination of sum if
function.
Anyways thanks much.
Best regards,
Ayush Jain
On Thu, Feb 11, 2010 at 10:47 PM, N.Shivkumar shiv1...@gmail.com wrote:
Dear Sir
Hi Keith,
The files can only be send via emails which attaches to it automatically.
Best Regards,
Ayush Jain
On Wed, Feb 17, 2010 at 6:05 PM, dkb...@gmail.com wrote:
Yes it did thanks. I was wondering if you had the option of attaching files
to thread so everyone on group could see progress
Ayush Jain has sent you a link to a blog:
Dear members, An ASCII converter function for quick reference. Best
regards, Ayush Jain
Blog: VBA Macros Code examples
Post: ASCII code converter : Column Number to Alphabetical reference
Link:
http://quickvba.blogspot.com/2010/02/ascii-code-converter
Ayush Jain has sent you a link to a blog:
Dear Group, Here is a wonderful Tip about Vlookup. To get regular
updates on Excel Tips...Just follow us on Twitter @
http://twitter.com/exceldailytip Thank you. -Ayush Jain Group Owner
Blog: Excel Daily Tip
Post: Check VLOOKUP Formula for #NA Error
,
Ayush Jain
Group Owner.
On Fri, Feb 26, 2010 at 7:59 PM, Putta Madaiah puttamada...@gmail.comwrote:
Hi Ayush,
I need another favour from you.
Please check the attached sheet and provide me the formulas as required in
the table.
Rgds- Madaiah, Bangalore
On Fri, Feb 5, 2010 at 8:47 PM
Ayush Jain has sent you a link to a blog:
Dear Excel Enthusiasts, Here is a Excel 2007 Tip about Filtering.
Please keep sharing tips and tricks in group. Thanks. Best regards,
Ayush Jain
Blog: Excel Daily Tip
Post: Filter by the Selected Cell
Link:
http://exceldailytip.blogspot.com/2010/02
Ayush Jain has sent you a link to a blog:
Dear Group, Here is a tip for you to faster access of worksheets in
Excel Best regards, Ayush Jain Group Owner
Blog: Excel Daily Tip
Post: Faster access to worksheets
Link:
http://exceldailytip.blogspot.com/2010/03/faster-access-to-worksheets.html
Hi Venkat,
Please use the below formula to get the desired output. Attached is the
excel sheet for your reference.
*=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))*
Thanks and best regards,
Ayush Jain
On Mon, Apr 5, 2010 at 1:14 PM, Venkatesan c venkat1@gmail.com wrote:
Dear Group,
Please
the 'Lock project for viewing' option.
6) Provide the password and confirm password
7) Click Ok...save ...close
Open the file again to Test the password .
Please let us know if any further assistance is required.
Thanks and best regards,
Ayush Jain
On Mon, Apr 5, 2010 at 6:44 PM, Jai jaihumtu
, reply using remove me as the subject.
--
Best regards,
Ayush Jain
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
is required.
It appears to me that this can be done in much better way rather than
updating each value. If you have any logic to update the data from one place
to another, We can help you doing same. Do let us know with relevant data,
if you have any questions.
Best regards,
Ayush Jain
Group Manager
and someone in group should
help you out on same, Please submit a separate query with detailed example.
Best regards,
Ayush Jain
Group Manager
On Tue, Apr 20, 2010 at 8:38 PM, Chaudhry Zahid Ali
chaudhry.zahid@gmail.com wrote:
Dear Ayush,
Thanks for the file. But the problem is that when
Hi Kantilal,
You can use the formula as mentioned below :-
=IF(G74/24,0,IF(AND(G74/24,G76/24),0.5,IF(AND(G76/24,G712/24),1,IF(G712/24,2,NA
Attached is the solution for your reference. Please have a look and let me
know if any further assistance is required.
Best regards,
Ayush Jain
Group
banned till date
due to spamming.
Many many thanks to top posters and query solvers...This will take us to new
heights.
Keep Posting !!
Best Regards,
Ayush Jain
Group Manager
On Sun, May 16, 2010 at 1:29 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
If somebody needs some study material
Ayush Jain has sent you a link to a blog:
Dear group, Here is a wonderful tip: One can open a group of workbooks
in a single step by creating a workspace file. For more details and
steps visit http://bit.ly/asYC3b Share this tip with your friends
colleagues. Thanks. Best regards, Ayush Jain
Blog
Dear Group,
This invite is for you.
Please try to make as much as possible from this event.
Thanks.
-Ayush Jain
Group manager
-- Forwarded message --
From: Microsoft micros...@e-mail.microsoft.com
Date: Thu, May 20, 2010 at 6:09 PM
Subject: You are Invited for a Deep Dive
feedback is highly appreciated.
To participate in survey, Please follow the below link
http://www.surveymonkey.com/s/L8BTDNQ
Thanks again and Keep Posting. :)
Best regards,
Ayush Jain
Group Manager
--
--
Some
Hi Nikhil,
Please keep group email in all your communications.
You may send us sample data and we will prepare a pivot for you.
Best regards,
Ayush Jain
On Fri, Jun 11, 2010 at 9:31 AM, Nikhil Shah nikhil201...@gmail.com wrote:
Hi Ayush,
Recd you e-mail.But I do not have any knowledge how
Ayush Jain has sent you a link to a blog:
Dear Members, Here is a small tip for you. Hope you will find it
useful.:) Thanks. Best Regards, Ayush Jain
Blog: Excel Daily Tip
Post: Expand menus in excel 2003
Link:
http://exceldailytip.blogspot.com/2010/06/expand-menus-in-excel-2003.html
--
Powered
Ayush Jain has sent you a link to a blog:
Here are the shortcuts to open MS office applications :)
Blog: Excel Daily Tip
Post: MS office Application Shortcuts
Link:
http://exceldailytip.blogspot.com/2010/06/ms-office-application-shortcuts.html
--
Powered by Blogger
http://www.blogger.com
Hi Nadine,
You may also use mid function as *=MID(A2,9,LEN(A2)).*
Also, your message posting is moderated. Hence your post will not appear
immediately in group. It may take 3-10 hours for message to get approved.
Let me know if any further assistance is required.
Best regards,
Ayush Jain
Group
Ayush Jain has sent you a link to a blog:
Dear Members, A small tip to hide the formulas and protect cells. Best
regards, Ayush Jain.
Blog: Excel Daily Tip
Post: Hiding Formulas
Link: http://exceldailytip.blogspot.com/2010/06/hiding-formulas.html
--
Powered by Blogger
http://www.blogger.com
this helps..
Please let us know if any further assistance is required.
Best Regards,
Ayush Jain
Group Manager
On Sun, Jul 4, 2010 at 2:05 PM, ROOP roopaggar...@gmail.com wrote:
Dear all
I want to know how i can protect a single cell in my work sheet so
that nobody (else me ) can change
Hi Neil,
As there are multiple items in a range, You need to use FOR EACH statement
to add items of range one by one in listbox.
Attached is the solution for your reference.
I hope it helps. Please let me know if any further assistance is required.
Best Regards,
Ayush Jain
Group Manager
Hi Dtenz,
I think this task can easily be done by using Excel formulas. Attached is
the sheet for your reference.
Please let us know if you need further assistance.
Best regards,
Ayush Jain
Group Manager
On Mon, Jul 5, 2010 at 3:41 PM, dtenz dtenz...@gmail.com wrote:
Hi,
I am new to excel
Hi Wizexcel,
Attached is the solution. You have to use the combination of countif,
indirect and row function.
The formula is :- *=COUNTIF(INDIRECT($A$2:$A$ ROW(A2)),A2)*
Please let us know if any further assistance is required.
Best regards,
Ayush Jain
Group Manager
On Mon, Jul 5, 2010 at 5
users or take any other action in accordance with its email
use policy.
*
--
--
Best regards,
Ayush Jain
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Hi Pankaj,
You can use conditional formatting to identify Duplicate Values in Excel
2007.
1) Go To -- Conditional Formatting
2) Highlight Cells Rules
3) Duplicate Values
Hope it helps.
Regards,
Ayush Jain
Group Manager
On Fri, Aug 27, 2010 at 10:42 AM, Pankaj Kumar rajputpanka
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
--
Best regards,
Ayush Jain
Dear member,
The winner of this quiz is *ROBERTO MENSA* whose answer and timing is
perfect among all.
Congrats Roberto...Keep it up and thanks.
Regards,
Ayush Jain
On Wed, Sep 22, 2010 at 7:43 PM, Shreedar Pandurangaiah
shreedar.panduranga...@gmail.com wrote:
Hi Ayush, Here are my answers
. May be you will write poem
in English next time for our English readers.
Best Regards,
Ayush Jain
Group Manager
-- Forwarded message --
From: Dilip Pandey dilipan...@gmail.com
Date: 2010/9/28
Subject: Fwd: कविता :- उस Expert का शुभ नाम है..पाण्डेय MR. दिलीप जी.
To: ayush jain
Thanks Pradeep. :)
On Sun, Oct 3, 2010 at 4:15 PM, Mattathil M. Pradeep mprad...@ccc.com.qawrote:
Congratulations Mr. Ayush Jain.
I was very happy to hear that you were awarded the position of MVP. It
reinforces my belief that determination, hard work and loyalty are
ultimately rewarded
the product.
yes the $100 dedicated coupon expiring soon in 2 hours...
Please feel free to ask any questions you have.
Thank you!
Best regards,
Ayush Jain
Microsoft MVP
Group Manager
On Thu, Nov 18, 2010 at 11:17 AM, Ayush jainayus...@gmail.com wrote:
Dear Group,
I quite often receive queries
free to forward this link and email to all your friends,
coworkers and followers.
So what are you waiting for...Download it now..
I hope it helps. Thanks.
Best regards,
Ayush Jain
Microsoft MVP 2010
P.S. Those who have downloaded this eBook already can ignore this message
!!
Best Regards,
Ayush Jain
Group Manager
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http
).Range(E lastrow :O20).Select 'Refer this
line
Selection.Copy
Sheets(2).Range(E25).PasteSpecial
End Sub
I hope it helps.
Best regards,
Ayush Jain
Microsoft MVP
Group Manager.
Note :- Please keep group email in all your communications. Thanks.
On Tue, Dec 7, 2010 at 5:00 AM, ali
1 - 100 of 181 matches
Mail list logo