Name :- STMicroelectronics
Location :- Greater Noida
Job Type :- Contractual.
Please let me know if somebody known to you is interested.
Send me the resume at jainayus...@gmail.com.
Thanks.
Best regards,
Ayush Jain
Group Man
possible without their valuable feedback and support in
running these initiatives.
& last but not least to Microsoft for recognizing me.
I will try my best to bring more resources and make you awesome in
Excel.
Thanks & Best regards,
Ayush Jain
Micro
group. They both have high willingness to help others
with excellent knowledge of Excel.
Thanks a tonne on behalf of whole group.
Keep posting !
Best regards,
Ayush Jain
Microsoft MVP
--
--
Some important links for
Thanks Pradeep. :)
On Sun, Oct 3, 2010 at 4:15 PM, Mattathil M. Pradeep wrote:
>
> 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 rew
group.
Best regards,
Ayush Jain
Microsoft MVP
--
--
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
. 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
Date: 2010/9/28
Subject: Fwd: कविता :- उस Expert का शुभ नाम है..पाण्डेय MR. दिलीप जी.
To: ayush jain
FYI..!!
Many
7843985936
This initiative will help to increase the reach of this group to the
people who are not aware about this group.
Let me know if you have any questions, concern or feedback.
Thank you
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, He
Hi
Use indirect function
=INDIRECT("A"&1)
I hope it helps.
regards,
Ayush
On Wed, Sep 22, 2010 at 6:03 PM, Maureeze wrote:
> Dear all,
>
> I have been looking for a solution for this problem for a while and i
> hope that someone out there can help me.
>
>
te B if A & C is given
Calculate C if A & B is given
You have to provide excel formula only...no VBA allowed
Regards,
Ayush Jain
Group Manager
--
--
Some important links for excel users:
1. Follow us on TWIT
your group and you have to make it happening
group.
Hi Dave ,
Many Many thanks for all your voluntary contribution and keeping this
group active and alive by your solutions.
Keep up the good work.
Thanks again.
Best regards,
Ayush Jain
Group Ma
Hi Guyzz,
Come on ..Please participate in this
If you dont respond, It means that you dont love excel.
Express yourself !!
Thanks to those who responded quickly :)
-Ayush Jain
Group Manager
On Aug 29, 1:26 am, Vinod N wrote:
> Excel makes life simple Be it an analysis or dashbo
Its a very handy tool for any data analysis and reporting. - Ayush
Jain
---
Guyzzz, Let me know why you like excel so muchThe best response
will be published on the home page with thanks
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 wrote:
> Hi,
>
&
Thanks PankajMy Pleasure :)
On Sat, Aug 21, 2010 at 6:16 PM, Pankaj Pandey <
pankaj.pan...@firstsource.com> wrote:
> Hi Ayush,
>
>
>
> I really thanks to you for your Help, Really appreciated
> your knowledge n helping nature. Keep it up for al
r for some :) ) .
We wish you all the best for your assignments and expect long
association with the group.
Thank you Dave :)
I have published the name of monthly top poster on Home Page...
Keep posting !!
Regards,
Ayush Jain
Group Manager
P.S. If you have any feedback for group, please fill
Hi Dilip,
You always make me feel proud by your dedication towards the group.
Hats off to your knowledge and skills.
We all are your fan and look forward for your long association with
the group.
Best Regards,
Ayush Jain
Group Manager.
On Jul 14, 10:30 am, Mathan wrote:
> Hi Dilip,
&g
values in running range.
Example:-
A2 cell will refer to range A2:A2 for counting
A3 cell will refer to range A2:A3 for counting
A4 cell will refer to range A2:A4 for counting
and so on...
I hope this helps.
Best regards,
Ayush Jain
Group Manager.
On Jul 5, 7:52 pm, Ankit Agarwal wrote:
> Hi Ay
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,
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 wrote:
> Hi,
>
> I am new to excel progra
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 ,
You may also refer to below link to extract numbers from the cell :
http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx
To attach a file you can send an email to excel-
mac...@googlegroups.com by attaching a file.
Best Regards,
Ayush
ting.
I hope 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 wrote:
> Dear all
>
> I want to know how i can protect a single cell in my work sheet so
> that nobody (else me ) ca
Hi Neil,
Thank you for sharing the useful file.
Best Regards,
Ayush Jain
Group Manager.
On Jul 3, 9:41 pm, neil johnson wrote:
> Hi Everyone,
>
> This is ppt of vlookup . I am very lucky , I am the member of this team. I
> am sending attached PPT .
>
> Thanks and Regard
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
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
Dear Magan,
It would be easier to help if you can provide some sample data in
excel sheet.
This problem can easily be solved by using vlookup, index, match
functions of excel.
Also, A macro can be written to automate this completely.
Hope it helps.
Best Regards,
Ayush Jain
On Jun 28, 7:39 am
let us know if you need any further help.
Best regards,
Ayush Jain
Group Manager.
On Sat, Jun 26, 2010 at 6:55 PM, KothariJewelry.com <
cont...@kotharijewelry.com> wrote:
> Dear All,
>
> I am herewith attaching a excel worksheet. Can someone help to me to
> provide a radio butto
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
4. Under Personalized Menus and Toolbars, click Always show full
menus
5. Click Close
Full menus always look the same, which makes it easier to find what
you’re looking for and is a much better option for new users.
Best regards,
Ayush Jain
On Jun 26, 6:41 pm, kamlesh jain wrote:
> Dear
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
your reference. :-
http://www.surveymonkey.com/s/L8BTDNQ
Thanks and Best Regards,
Ayush Jain
Group Manager
On Jun 2, 8:03 am, Ayush wrote:
> Dear group,
>
> The survey has received very few hits till date. Please spare a minute
> to share your feedback.
> It will definitely help
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 wrote:
> Hi Ayush,
>
> Recd you e-mail.But I do not have any knowledge how to use pi
Hi Nikhil,
Use Pivot tables to get this done...Let us know if any further help is
required.
Best regards,
Ayush Jain
On Jun 11, 1:09 am, Nikhil Shah wrote:
> Hi Friends,
>
> Here I am posting Query, pl help.
>
> Name Amt
>
> Bill 1,000
> Gopal 1,500
>
Dear group,
The survey has received very few hits till date. Please spare a minute
to share your feedback.
It will definitely help us to take this group to next level.
Looking forward to your active participation.
Thank you so much
Best regards,
Ayush Jain
Group Manager
On May 30, 8:55 pm
from the group..
>
> I have cheked the first option in ques no 8, as there was no other
> option, if someone is not visiting other communities
>
> Harry
>
> On May 31, 10:53 am, Stuart Redmann wrote:
>
> > On 30 Mai, 17:55, ayush jain wrote:
>
> > > D
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
make a difference in
group
Keep posting !!
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
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
Date: Thu, May 20, 2010 at 6:09 PM
Subject: You are Invited for a Deep Dive into the new Microsoft Office 2010
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
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
wrote:
> Hi,
> If somebody needs some study material and ebooks, t
copyrighted at all :)
I hope you understand the same. Any such message again could lead to
termination from the group membership.
Keep Posting.
Best regards,
Ayush Jain
Group Owner
--
--
Some important links for excel users
Hi Kantilal,
You can use the formula as mentioned below :-
=IF(G7<4/24,0,IF(AND(G7>4/24,G7<6/24),0.5,IF(AND(G7>6/24,G7<12/24),1,IF(G7>12/24,2,"NA"
Attached is the solution for your reference. Please have a look and let me
know if any further assistance is require
Dear group members,
I have added two more Shortcuts in the "Secret shortcut of excel"
ebook. You can download the ebook from the link http://bit.ly/aX6x3a
Please let me know if you know more such keyboard Shortcuts. I will
include them in next version.
Thank You.
Best regards,
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 probl
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
On
t; 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
aul W, Dave and
Dilip Pandey for taking this group to next level.
I am proud to be part of this group. If you have any suggestions,
please do not hesitate to share with the group.
Keep Posting !!
Best regards,
Ayush Jain
Group Manager
On Apr 16, 7:51 pm, Suryaprasad wrote:
> Hi All,
&g
Please let us know if any further assistance is required.
Best regards,
Ayush Jain
Group Manager
On Apr 14, 4:37 pm, rf1234 rf1234 wrote:
> Hello Dear,
> You can simply read the range,Just use this attached excel Sheet.
>
> Hope it Will Help
> Hap
Thank you Dave fro your inputs.
This is good workaround and weird too. But difficult for those who
have only XL 2003. isn't it ?
Best regards,
Ayush Jain
Group Manager
On Apr 11, 12:41 pm, Dave Bonallack wrote:
> Hi Ayush,
> There is a sort of a workaround.
> If you have xl20
nd it will automatically apply filter to
those selected ranges.
I hope it helps. Please let me know if you have further doubts.
Best regards,
Ayush Jain
Group Manager
On Apr 11, 11:35 am, vinod rao wrote:
> Hi Ayush,
>
> I could put filter to one selected range and later when i want to put t
Hi Vinod,
It is very simple. Just select the 1st range and apply the filter and
same for 2nd range.
Please let me know if you have more questions.
Best regards,
Ayush Jain
Group Manager
On Apr 11, 10:16 am, vinod rao wrote:
> Hi Vikas,
> How did you do this?.
> Regards
> Vin
>
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
oud to be
member of this group.
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 Facebook G
nks and best regards,
Ayush Jain
On Mon, Apr 5, 2010 at 8:35 PM, ChristopherL wrote:
> When I try to create a list and refer to another sheet, I get the
> below error! How can I get it to work. A working example would be
> useful.
>
>
> Where is the data for your list?
>
>
'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,
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 wrote:
> Dear Group,
>
> Please help me
more than 500 users to make this
group spam free
Best regards,
Ayush Jain
On Apr 3, 9:49 am, pavi pavithra wrote:
> Hi All,
>
> It was great to see that the group has completed 3 yrs and my heartful thanx
> to all those guys who shared their thoughts and ideas about excel here.
&
Hi Harpreet,
Its a good suggestion to have new subject title with a keyword TIP.
Dear Group,
Please share the tips and tricks in a new email message with the TIP
keyword. It really helps.
Best regards,
Ayush Jain
On Mar 24, 8:35 am, Harpreet Singh Gujral
wrote:
> Hi Ayush,
>
> L
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,
Did you try "Exit for" in FOR loop where the condition is met and
further looping is not required.
Give it a try...It should help.
Best regards,
Ayush Jain
On Mar 19, 7:00 am, scubagirl wrote:
> I have a fairly large VBA project for work - it runs a Monte Carlo
> simulat
. I loved it.
Best regards,
Ayush Jain
Group Owner.
On Mar 18, 7:28 pm, draco664 wrote:
> Personally, whenever I start a new job, or install a new version of
> Excel, the first thing I do is record the following macro.
>
> Sub CopyPasteSpecialValues()
> '
> '
of excel also. Anything about excel that you
knowanything
Sharing just increases the knowledge.
Keep Posting...
Best regards,
Ayush Jain
Group Owner
--
--
Some important links for excel users:
1. Follow us on
if any further help is required.
Best Regards,
Ayush Jain
Group Owner
On Mar 8, 3:52 pm, "sachinp1...@googlemail.com"
wrote:
> Hello Members, I want help regarding this in which we receive the data
> in below mentioned date period format.where we have to convert in
> actual dd/
Hi Gopi,
Attached is the solution. I have used vlookup formula to get this done.
Let us know if any further help is required.
Best regards,
Ayush Jain
Group Owner
P.S. Please keep group email address in your replies. Thanks
Hi Harpreet,
Simply you can use B1-A1 and change the time format to "1:00". It
should work.
Let us know if you have any further questions.
Best regards,
Ayush Jain
On Mar 6, 3:38 pm, Harpreet Singh Gujral
wrote:
> Hi Group,
>
> I have the following question:
>
> I have
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
Group Owner.
On Fri, Feb 26, 2010 at 7:59 PM, Putta Madaiah wrote:
> 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
7kn5sQ&gsc=rxA99gsB8H9FNKBXr43TG9Clr6QQ
Let us know if any further assistance is required.
Thanks.
Best regards,
Ayush Jain
On Feb 26, 3:41 pm, sudhir kumar wrote:
> Hi Dear all,
>
> Please help me for below formula.
>
> 1. how to convert numbers in text.
> 2. Example
Hi Markkim,
Would you please send the sample file containing this data?
Best regards,
Ayush Jain
On Feb 26, 6:18 am, Markkim wrote:
> Hi
> I have been trying to make these but have failed. ^ ^;;
> I’d like to create a macro
>
> A21 has a word called ‘Date’
>
> And somew
Hi Mahesh,
You may use below macro in Open_workbook procedure of your sheet. Let
us know if any further help is required.
Sub animation()
For i = 1 To 4
ActiveSheet.Range("A1").Value = i
Application.Wait (Now + TimeValue("0:00:10"))
Next
End Sub
Ayush Jain has sent you a link to a blog:
Dear Group, An amazing tip to use only visible rows in formulas.. Check
it out now.. Best regards, Ayush Jain Group Owner
Blog: Excel Daily Tip
Post: Sum/Count/Average only Visible Rows with SUBTOTAL Function
Link:
http://exceldailytip.blogspot.com/2010
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 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
ro:
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub
Best regards,
Ayush Jain
P.S Please keep Excel group in all the communications. Thanks.
On Thu, Feb 18, 2010 at 1:42 AM, janet dickson wrote:
> Hello Fans..
>
> Am in trouble, please give a *m
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, 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 of so
Hi Keith,
Would you please send the Excel file where the changes are required ?
Best regards,
Ayush Jain
On Feb 15, 7:41 am, Keith wrote:
> I consider myself a self-taught novice user of VBA for Excel. I took
> on a project at work and developed this VBA code with the help of the
>
Hi Niraj,
It is developed by Ashish Jain...Please contact him at 26may.
1...@gmail.com
Thanks and Best regards,
Ayush Jain
On Feb 13, 8:09 pm, Niraj Kothari wrote:
> Dear Ayush,
>
> I have downloaded this file from your group and i want to use to get live
> stock market quotes , it
Dear Sachin,
You can use the Mid Function to extract a particular letters from a
cell. Here is an example:
=MID(A1,4,9)
Let me know if any further assistance is required.
Best Regards,
Ayush Jain
On Feb 13, 4:49 pm, "sachinp1...@googlemail.com"
wrote:
> Hello Group Members,
e = ""
End If
End Sub
Also, if you want to apply same for other columns based on column 1, you can
use offset function like :
For column E: Target.Offset(0, 4).Value = Now()
For column K: Target.offset(0,10).value = Now()
Let me know if any further help is required on this macro.
Best
Dear Rajeev,
You may use the macro posted on
http://www.binterest.com/convert-spell-number-in-excel-into-words/
This macro can be customized as per your needs. Let me know if any
help is required.
Best regards,
Ayush Jain
Group Owner
On Feb 10, 1:47 pm, Rajeev Nandan wrote:
> Dear Mr.Di
of
the Group. I have just updated it today. :)
My Special thanks to those who take out time to help others for FREE.
Link to FaceBook group is : -
http://www.facebook.com/group.php?gid=287779555678
Best regards,
Ayush Jain
--
-
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 wrote:
> Dear Sir
>
THANKS Aindril. But In Sumifs function it is not possible to have two
criteria(of = sign) on same range.
Any example would help.
The formula =sumifs("A:A","B:B","=12","B:B","=C") does not seems to be
working.
Regards,
Ayush Jain
On Feb 11, 8:37
,"12,CM,AJ")
Any Help ?
The compounding of three sumif like = sumif(.) + sumif() +
sumif() is not I am looking for.
Thanks for advising.
Best regards,
Ayush Jain
--
--
Some important links for e
Hi Chethan,
Excel is used at most of the places so as VBA. You may apply in
Finance, BPOs, etc.
Let us know if any further assistance is required by us.
Thanks.
Best regards,
Ayush Jain
On Feb 10, 3:56 pm, chethan Bhadravathi wrote:
> Hi Everybody,
>
> i want to know which industr
Thanks Ashish. I agree with you.
The group members should not share any paid material or Password
cracker in this group. Please adhere the same going forward.
Any violation may lead to termination of membership from the group.
Best regards,
Ayush Jain
Group Owner.
On Feb 10, 12:38 pm, Ashish
Dear Suhas,
Use the below function which is a merger of three different functions.
=TRIM(CONCATENATE(PROPER(I12),PROPER(J12)))
Please let me know if any further assistance is required.
Best regards,
Ayush Jain
On Feb 8, 3:43 pm, $ⓤⓗⓐ$ wrote:
> Hi all,
>
> How to apply more than two
= "0" Then
ws.Visible = 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 wrote:
> Hi
>
> I have a workbook which has a no of worksheets. I want to hide all those
>
You are most welcome :)
On Sun, Feb 7, 2010 at 11:53 AM, Imran khan wrote:
> Thanks Ayush,
>
> This will help me lot and save my time also.
>
> Thanks a lot once again! you guys and Dilip are doing great job which is
> appreciated.
>
> Imran
>
>
>
> On Sun
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 wrote:
> Dear Friends,
>
> Please help me for solution of attached f
Ayush Jain has sent you a link to a blog:
Its funnyenjoy .. :)
Blog: Excel Daily Tip
Post: Excel Famous Ranges & Cells
Link:
http://exceldailytip.blogspot.com/2010/02/excel-famous-ranges-cells.html
--
Powered by Blogger
http://www.blogger
Ayush Jain has sent you a link to a blog:
Must read for those who deals in stock markets :))
Blog: Excel Daily Tip
Post: How to Get a Stock Quote ... COOL FEATURE
Link:
http://exceldailytip.blogspot.com/2010/02/how-to-get-stock-quote-cool-feature.html
--
Powered by Blogger
http
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 wrote:
> Hi Ayush,
>
> Thanks for the formulas. It will be great also if you can consider only for
> "N" under column &
Thank you Swapnil...It worked :)
On Feb 3, 11:54 am, Swapnil Palande wrote:
> Hi Ayush,
>
> Do the following steps
> 1. crate a function for your range
> ex:
>
> Public Function nRange() As Range
> 'Dim rng As Range
> 'Set rng = Sheets("M-RAW"
7;s because sheets and ranges are "dynamic"
> and you're trying to treat a variable as a constant
> But I could be wrong.
>
> Paul
> --
> *From:* Ayush
> *To:* MS EXCEL AND VBA MACROS
> *Sent:* Tue, February 2, 2010 11:24:36 A
ws
error.
Kindly advise.
Thank you so much.
-Ayush Jain
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video
o 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
<><><><><><><><><><><><><><><>&
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 wrote:
> Hi Dilip and Ayush,
>
> Thanks for responding quickly with the solution. As per the solution
> on
#x27;find the last row in column A
lLastRow = .Cells(.Rows.Count, 1).End(xlUp).Row
Set rngToCheck = .Range(.Cells(1, 1), .Cells(lLastRow, 1))
End With
With rngToCheck
.AutoFilter Field:=1, Criteria1:="*here*", Operator:=xlFilterValues
End With
Application.ScreenUpdating = True
End Su
201 - 300 of 392 matches
Mail list logo
