Hi Experts,
Request you to help to resolve this below query.
I have put pivot for one data and it contains employee code and name. I
tried option multiple consolidation ranges while put a pivot. Name also
consider as value. Need to show employee code as well as name in pivot,
also is it possi
Hi,
I got answer in VBA. Attached is the updated file.
Regards,
Vijayendra
2017-07-23 6:00 GMT+05:30 who :
> Unless the IF() statement has changed, it only allows 7 nested ifs, which
> is not sufficient to do this with out the use of VBA. Thanks, David
>
>
> On Monday, July 10, 2017 at 4:59:17
--
>
>
> On Friday, July 21, 2017 6:53 AM, Vijayendra Rao
> wrote:
>
>
> Hi Experts,
>
> I have cell value called $A$5 (Will change based on selection of active
> cell) and need to get the suitable function which should reflect the
> value of the $A$5 (will chang
Hi Experts,
I have cell value called $A$5 (Will change based on selection of active
cell) and need to get the suitable function which should reflect the value
of the $A$5 (will change). Attached is the excel file, request you to help
on the same.
Regards,
Vijayendra
--
Are you =EXP(E:RT) or =
> Name..The variable cell
> Apply data validation
>
> On 10 Jul 2017 5:29 pm, "Vijayendra Rao" wrote:
>
> Hi Experts,
>
>
> Request you to help to resolve this below query.
>
> Need to change the cell based on selection of other cell. Attached is the
>
Hi Experts,
Request you to help to resolve this below query.
Need to change the cell based on selection of other cell. Attached is the
sample file, in this file Column E3 should contains based on the active
cell selected between A2:A14. Is it possible to do with any functions /
macros.
Regards
Hi Experts,
I have created one reconciliation statement in which I need to do many
manual work. Is there any option which i can easily prepare by any
functions or macros. Request you to help on the same.
Excel file is attached.
Regards,
Vijayendra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex
all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ---------
>
>
> On Thursday, December 15, 2016 7:43 AM, Vijayendra Rao <
> vijayendrar...@gmail.com> wrote:
>
>
> Dear Paul,
>
> I am facing one iss
. "Hide & unhilde - 2nd page" is the macro
provided by you and "TESTING - 001" is my file.
Regards,
Vijayendra
2016-12-13 18:24 GMT+05:30 Vijayendra Rao :
> Thanks Paul for your help, it is working fine. You saved my lot of time.
>
> Thank you again.
>
> Reg
you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ---------
>
>
> On Wednesday, December 14, 2016 2:40 AM, Vijayendra Rao <
> vijayendrar...@gmail.com> wrote:
&
Dear Experts,
I have created two macros, one is for suppress zero rows and another print
option. Currently I need to run first suppress zero rows and later print
macros. Is it possible to combine both the macros. By running print option,
rows should be suppress and later need to show print dialog
---
> On Tue, 12/13/16, ileanakeating via MS EXCEL AND VBA MACROS <
> excel-macros@googlegroups.com> wrote:
>
> Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
> To: excel-macros@googlegroups.com
> Date: Tuesday, December 13
ll the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Monday, December 12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA
> MACROS wrote:
>
>
>
>
> On Mon, 12/12/16, Vijayendra Rao
all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -----
>
>
> On Monday, December 12, 2016 7:04 AM, Vijayendra Rao <
> vijayendrar...@gmail.com> wrote:
>
>
> Hi Experts,
>
> I have created one excel file and except one sheet all s
Hi Experts,
I have created one excel file and except one sheet all sheets are hided. I
have added shape button in first sheet to unhide all the sheets with the
help of macro. When i worked and saved all sheets will be visible when I
opened again. Is it possible to remain hide those sheets after sa
Hi Abhishek,
It has been resolved, attached is the Excel file. Thanks for your help.
Regards,
Vijayendra
2016-02-03 15:08 GMT+05:30 Vijayendra Rao :
> Thank you very much Abhishek your help. I am facing issue in name and
> verifier column as you have given number of character 30,
Abhishek Jain :
> Does this help?
>
>
>
> On Wed, Feb 3, 2016 at 11:54 AM, Vijayendra Rao
> wrote:
>
>> Dear Expert,
>>
>>
>>
>> I have time sheet which is received from my team and I tried to extract
>> data in to separate columns. I have tried
Dear Expert,
I have time sheet which is received from my team and I tried to extract
data in to separate columns. I have tried with combination of formula of
“left, mid, right, find” but still it is not coming properly.
Request you to help me to find out the solution. Attached is the excel file.
Sheets(i).Shapes.Count
> Sheets(i).Shapes(x).Select
> Selection.Delete
> Next
> Next
> End Sub
>
> or
>
> Sub DeleteAllShapesAtOnce()
> Dim i As Integer,
> For i = 1 To Sheets.Count
> Sheets(i).Shapes.SelectAll
> Selection.Delete
> Next
Dear Experts,
Can you please help me to put vlookup or Index&Match formula for multiple
column. Attached is the excel workbook.
--
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
Regards,
Vijayendra
94491 67631
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:O
Dear Vaibhav,
Thank you very much for your quick support. This is very helpful.
Regards,
Vijayendra
2015-03-13 20:27 GMT+05:30 Vaibhav Joshi :
> PFA with #N/A handler...
>
> On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao
> wrote:
>
>> Dear Experts,
>>
>> Can
Dear Experts,
Can you please help me to put vlookup or any other formula for the the
second row. Attached is the my file and request you to help on the same.
Regards,
Vijayendra
94491 67631
--
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
ld of macros,
> then nevermind.
>
> *Paul*
> -----
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
ot 41.667 minutes!)
>
> let me know if you need help applying this logic to your workbook.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you
Dear Experts,
Can you please help me to convert time to numbers. Attached is the my file
and my formula is showing some wrong numbers. Request you to help on the
same.
Regards,
Vijayendra
94491 67631
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:O
Thank you sir, will create button as per your suggestion.
2014-06-29 20:32 GMT+05:30 Vaibhav Joshi :
> Hi
>
> You can create a button on main sheet to run macro. Create button or image
> and right click on it to assign macro.
>
> Cheers
> On Jun 29, 2014 5:43 PM, &quo
want.
>
> Cheers!!
>
> On Fri, Jun 27, 2014 at 3:42 PM, Vijayendra Rao
> wrote:
>
>> Dear Experts,
>>
>>
>>
>> Can you please help me on selecting the cells based on custom format.
>>
>>
>> In attached file some figures contains Dr
>
> On Fri, Feb 14, 2014 at 1:12 PM, Vijayendra Rao
> wrote:
>
>> Dear Experts,
>>
>> I know basic of mail merge and using from several years.
>>
>> Now I need to add cc and bcc in mail merge and is it possible to pick the
>> subject line from exc
Dear Experts,
I know basic of mail merge and using from several years.
Now I need to add cc and bcc in mail merge and is it possible to pick the
subject line from excel itself. I want to use the separate subject for each
email.
Request you to provide me any macros and steps to be followed.
Rega
ny further assistance.
>
> <><><><><><><>
> *Ms-Exl-Learner*
>
> <><><><><><><>
>
> On 08-10-2012 12:44 PM, Vijayendra Rao wrote:
>
> Dear All,
>
>
> I have some data which includes amount da
Dear All,
I have some data which includes amount data. I need the latest data’s date.
Request you to let me know what formula I can use it for the same.
Excel file is attached with example.
Regards,
Vijayendra
94491 67631
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
--
Join official facebook page of
Hi,
Please find attached file with example.
Regards,
Vijayendra
2012/8/16 Amresh Maurya
> check below link. i hope it will help you.
>
>
> http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/
>
>
> Reagrds
> Amresh
>
>
> On Thu, Aug 16, 2012 at 1:03 PM, amar t
p you out.:-
>
> For Date diffrence:- =DATEDIF(A2,(B2),"md")
>
> For Month diffrence :- =DATEDIF(A2,(B2),"ym")
>
> For Year diffrence :- =DATEDIF(A2,(B2),"y")
>
>
>
>
>
>
> Thanks & Regards,*
> *
>
> *Deba
Dear All,
I need date formula for finding how many days and months between two
different dates. Request you to resolve my query. I have attached is the
same file.
Regards,
Vijayendra
94491 67631
--
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
Regards,
Vijayendra
94491 67631
--
FORUM RULES (986
On Fri, Apr 27, 2012 at 8:13 PM, Vijayendra Rao > wrote:
>
>> Dear All,
>>
>> I need one formula which will using for accounting entries, I tried
>> sumproduct but it doesnt work. I have attached is the same file.
>>
>> Regards,
>> Vijayendra
>>
Dear All,
I need one formula which will using for accounting entries, I tried
sumproduct but it doesnt work. I have attached is the same file.
Regards,
Vijayendra
94491 67631
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Thanks Sam, Maries & Haseeb.
All three solutions are working fine.thanks again.
Regards,
Vijayendra
2012/2/27 Haseeb Avarakkan
> Hi Sam,
>
> I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces
> before the fourth digit :-) , like
>
> ABCDE 1D
>
> Hi Vijayendra,
>
> T
Dear All,
I want to validate text and numbers in PAN number. Validation required as
per below conditions.
· Length should be 10
· First 5 character should be text
· Next 4 should be number
· Last character should be text
Attached excvel file for your referenc
Hi Noorain,
It will work only one cell at a time, is it possible to put subject to
multiple cellls at a time.
Regards,
Vijayendra
2012/2/17 NOORAIN ANSARI
> Hi Renu,
>
> Please see attached Screen shot, it might be helpful
>
>
> On Fri, Feb 17, 2012 at 1:17 PM, Renukachari Kasee wrote:
>
>>
You can use the below formula
=INDEX($H$2:$J$7,MATCH($B2,$H$2:$H$7,1),2)
=INDEX($H$2:$J$7,MATCH($B2,$H$2:$H$7,1),3)
Attached is the excel file for your reference.
Regards,
Vijayendra
2012/2/4 chandra sekaran
> Hi Sanjib
> simple Vlookup forumula to solve your Query
>
> Regards
> chandru
>
Thanks...
2012/2/3 David Grugeon
> Sorry. My mistake. I must have changed the cell accidentally it should
> be =ROUNDUP(C34/2,0) similar to the ones below
>
> On 3 February 2012 13:57, Vijayendra Rao wrote:
>
>>
>>
>> Thanks David for correct answers. I
an answer
>
> 5. You need to be able to enter an ID or a name. Your formula only works
> with a name
>
> I attach a sheet with my answers.
>
>
> On 2 February 2012 14:43, Vijayendra Rao wrote:
>
>> Hi Noorain,
>>
>> I have able to solve only 1st, 2nd
Hi Noorain,
I have able to solve only 1st, 2nd and 5th questions.
Regards,
Vijayendra
2012/2/2 David Grugeon
> Hi Noorain and Congratulations on your award.
>
> For Q1 it would be more interesting to ask for the maximum negative value.
> Otherwise it looks like a catch question.
>
> Regards
>
Congratulations Noorain Ansari… keep the good work
Regards,
Vijayendra
2012/2/2
> Congrets noorain
>
> Sent from BlackBerry® on Airtel
>
> -Original Message-
> From: Dilip Pandey
> Sender: excel-macros@googlegroups.com
> Date: Thu, 2 Feb 2012 09:28:46
> To:
> Reply-To: excel-macros@go
27;s the result.
>
> I have also sorted the list based on project. Please confirm if that is
> what you are looking for.
>
> Regards,
> Sam Mathai Chacko
>
>
> On Wed, Feb 1, 2012 at 8:53 PM, Vijayendra Rao
> wrote:
>
>> Dear All,
>>
>> I want to p
t;>
>> Please use below formula and see attached sheet.
>>
>> *=COUNTIFS($B$2:$D$5,">"&4000,$B$2:$D$5,"<="&6000)*
>>
>> --
>>On Thu, Jan 12, 2012 at 12:47 PM, Vijayendra Rao <
>> vijayendrar...@gmail.com> wrot
Dear All,
I want to put countif range between 4000 to 6000. Please find attached file
for your reference.
Region Jan Feb Mar North 5000 6000 4500 South 5800 7000 3000 East 3500
2000 1 West 12000 4000 6000
Regards,
Vijayendra
94491 67631
--
FORUM RULES (986+ members already BANNED for
Software
> dguille...@gmail.com
>
> *From:* Vijayendra Rao
> *Sent:* Friday, December 16, 2011 6:44 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Help on isblank & iferror
>
> Hi All,
>
> I want to put isblank and iferror formula in one c
Hi All,
I want to put isblank and iferror formula in one cell. Can you please help.
Attached sheet for your reference.
Regards,
Vijayendra
94491 67631
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urge
50 matches
Mail list logo