$$Excel-Macros$$ Problem in Pivot

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

Re: $$Excel-Macros$$ Change Cell based on Selection of Other cell

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

Re: $$Excel-Macros$$ Find out the value of the cell based on row and column

-- > > > 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

$$Excel-Macros$$ Find out the value of the cell based on row and column

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 =

Re: $$Excel-Macros$$ Change Cell based on Selection of Other cell

> 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 >

$$Excel-Macros$$ Change Cell based on Selection of Other cell

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

$$Excel-Macros$$ Rows to Column data

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

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

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

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

. "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

Re: $$Excel-Macros$$ Combine two macros in to one

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: &

$$Excel-Macros$$ Combine two macros in to one

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

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

--- > 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

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

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

Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide

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

$$Excel-Macros$$ Excel Sheet Hide and Unhide

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

$$Excel-Macros$$ Re: Financial Modelling / Economic Modelling using Excel/VBA

no thanks On Wednesday, September 30, 2009 at 2:48:47 PM UTC+5:30, Sivakumar wrote: > > Dear all > > Would like to know any university/institute offering courses on > Financial Modelling/Economic Modelling using Excel/VBA. > > Regards > Sivakumar > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i

$$Excel-Macros$$ Re: Forum rules : Please adhere else you will be BANNED

hello, i am new to google groups. thanks for joining in this group On Saturday, July 23, 2011 at 5:50:06 PM UTC+5:30, Ayush Jain wrote: > > Hello everyone, > > Please adhere to below rules of the forum. You will be banned without > warning on non compliance. > Till date 806 members are banned i

Re: $$Excel-Macros$$ Excel Exctact Data

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,

Re: $$Excel-Macros$$ Excel Exctact Data

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

$$Excel-Macros$$ Excel Exctact Data

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.

Re: $$Excel-Macros$$ Excel workbook Issues

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

$$Excel-Macros$$ Help on Vlookup on multiple column

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

Re: $$Excel-Macros$$ Help in Vlook-up or any other formula

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

$$Excel-Macros$$ Help in Vlook-up or any other formula

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

Re: $$Excel-Macros$$ Help in Time Tracker

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

Re: $$Excel-Macros$$ Help in Time Tracker

> > > > > > > *“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* > - > >

Re: $$Excel-Macros$$ Help in Time Tracker

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

$$Excel-Macros$$ Help in Time Tracker

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

Re: $$Excel-Macros$$ Select cells based on custom format

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

Re: $$Excel-Macros$$ Select cells based on custom format

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

Re: $$Excel-Macros$$ mail merge with Cc options

> > 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

$$Excel-Macros$$ mail merge with Cc options

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

$$Excel-Macros$$ Fwd:

http://www.corevedico.com/j2b5mp.php -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get q

Re: $$Excel-Macros$$ $$Excel-Macros$$ Need to find out date of latest data

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

$$Excel-Macros$$ $$Excel-Ma​cros$$ Need to find out date of latest data

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

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

; > On Sat, Sep 29, 2012 at 8:39 PM, vinod rao wrote: > >> >> Any suggestions? >> >> >> I need conditional formating Yellow when the delta is 0% +2% >> >> Thanks, >> Vin >> On Sat, Sep 29, 2012 at 7:53 PM, vinod rao wrote: >> >>

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

Any suggestions? I need conditional formating Yellow when the delta is 0% +2% Thanks, Vin On Sat, Sep 29, 2012 at 7:53 PM, vinod rao wrote: > Hi Sam, > > But i am unable to put 0% to 2% to yellow. > On Sat, Sep 29, 2012 at 7:35 PM, vinod rao wrote: > >> Hi, >> &g

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

Hi Sam, But i am unable to put 0% to 2% to yellow. On Sat, Sep 29, 2012 at 7:35 PM, vinod rao wrote: > Hi, > > I want to know how to do a conditional formatting on numbers based on the > calculated percentage % > Please see attached file. Help me as quick as possible. &

$$Excel-Macros$$ Excel Conditional Formatting formula

Hi, I want to know how to do a conditional formatting on numbers based on the calculated percentage % Please see attached file. Help me as quick as possible. Thanks Vin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANN

$$Excel-Macros$$ Rank the bars in the chart

Hi, Can we rank the bar as per the value in the chart, i know that data can be sorted but i dont need, is there any ways show bar A,C B, & D. Please help. Regards, Vin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNE

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congrats, u are the live wire of this group.please do continue the same. Cheers, Prabhakar On Sun, Sep 2, 2012 at 10:44 AM, wrote: > ** > Congrats Noorain.. > > Rgds > Vaibhav > -- > *From: * Ayush Jain > *Sender: * excel-macros@googlegroups.com > *Date: *Sun, 2 Sep

Re: $$Excel-Macros$$ MS Excel Vlookup query

thanks Don. I could get the right result. Thanks for your help. Have a nice day. On Tue, Aug 21, 2012 at 12:09 AM, vinod rao wrote: > can i request you to put in the excel file. I am unable to get the > relevelt result > > > On Tue, Aug 21, 2012 at 12:02 AM, dguillett1 wrote:

Re: $$Excel-Macros$$ MS Excel Vlookup query

entered using ctrl+shift+enter > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* vinod rao > *Sent:* Monday, August 20, 2012 1:05 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ MS Excel

Re: $$Excel-Macros$$ MS Excel Vlookup query

Hi, I need a formula plz. My data base is very huge. i cannot use autofilter. On Mon, Aug 20, 2012 at 11:18 PM, dguillett1 wrote: > Just use data>filter>autofilter > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From

$$Excel-Macros$$ MS Excel Vlookup query

Hi Team, I want to put vlookup or any other foumula and get the second/third lookup data. See attached file for example. Thanks advance for any help. Regards Vin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

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

Re: $$Excel-Macros$$ Reduce size of Excel file(XLSM)

ans 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 > *- > > > -- > *From:* Girish

Re: $$Excel-Macros$$ Reduce size of Excel file(XLSM)

Hi Noorian, Thanks for the code. But this is not working, >The macro is removed all the formatting of the actual sheet. >It actually deleted the pivot itself. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for v

$$Excel-Macros$$ Reduce size of Excel file(XLSM)

Hi, I have created a Pivot based dashboard, the data is huge so the file size is around 35MB. Is there any way to reduce the file size to around 7-8MB. I have tried to reduce the size by removing all the unwanted columns data. Thanks for all your help -- Join official facebook page of this

Re: $$Excel-Macros$$ Multiple Versions of Excel

Hey, Do u have the genuine Excel 2010?? if yes, Do you mine sharing this. Cheers, Prabhakar On Tue, May 29, 2012 at 10:09 PM, Ashish Pradhan wrote: > > Hey > > Thanks Don and CoRe for the prompt replies. Am going ahead with the > multiple installations. Hope all goes well. :-) > > Thanks > > As

Re: $$Excel-Macros$$

Thanks Don, Could you please let us know why you have taken "Weight" field to calculate the ranking..and also explain us how this SumPoduct function works. Regards, Prabhakar 2012/5/19 dguillett1 > =RANK(C2,$C$2:$C$55)+**SUMPRODUCT(--($C$2:$C$55=C2),-**-($A$2:$A$55 > > > Don Guillett > Micros

Re: $$Excel-Macros$$ Dynamic List range for Data validation

91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* 28 May 2012 1:56 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Dynamic List range fo

Re: $$Excel-Macros$$ Dynamic List range for Data validation

Thanks Ansari.. On Mon, May 28, 2012 at 1:56 PM, NOORAIN ANSARI wrote: > Dear rao, > > The -- is used as an unary operator to convert a boolean value ie, > TRUE/FALSE in to 1/0. > > So to negate this, we use unary operator -- with TRUE or FALSE to give 1 > or 0 > > We

Re: $$Excel-Macros$$ Dynamic List range for Data validation

I > *Sent:* 28 May 2012 1:56 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Dynamic List range for Data validation > > ** ** > > Dear rao, > > The -- is used as an unary operator to convert a boolean value ie, > TRUE/FALSE in to 1/0. > >

Re: $$Excel-Macros$$ Dynamic List range for Data validation

Hi Rajan, I ma not able to understand the formula that u have created in column2, especially the "--", what do they signify =SUM(--(A2>$A$2:$A$8))+1 Please advice Regards, Prabhakar On Thu, May 17, 2012 at 6:22 PM, Rajan_Verma wrote: > Hi > > Please find the attached Sheet > > *It p

Re: $$Excel-Macros$$ 2 Values in the same cell

ds* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *rao > *Sent:* 26 May 2012 2:44 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ 2 Va

Re: $$Excel-Macros$$ 2 Values in the same cell

Hi , I am not able to understand this part, could you please explain. rngOutput.Offset(lngLoopCounter).Offset(-1, -1).Value = rngCell.Value rngOutput.Offset(lngLoopCounter).Offset(1, 1).Value = rngCell.Value cheers, Prabhakar On Sat, May 26, 2012 at 2:41 PM, rao wrote

Re: $$Excel-Macros$$ 2 Values in the same cell

cros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *rao > *Sent:* 26 May 2012 1:46 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ 2 Values in the same cell > > ** ** > > Thanks Rajan, > I am seeing a runtime error

Re: $$Excel-Macros$$ 2 Values in the same cell

Thanks Rajan, I am seeing a runtime error while selecting the range for the "rngOutput"..Could you please advice on this.I have selected range from A1:C14 *Set rngOutput = Application.InputBox("Please select Output Cells", , , , , , , 8)* Cheers, Prabhakar On Wed, May 16, 2012 at 6:23 PM, Rajan_V

Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

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

$$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days

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

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ $$Excel-Ma​​cros$$ Formula Need for accounting entries

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 >>

$$Excel-Macros$$ $$Excel-Ma​cros$$ $$Excel-Ma​​cros$$ Formula Need for accounting entries

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,

Re: $$Excel-Macros$$ Re: Excel conditional formatting-Urgent plz

Thank you Meeran :) On Thu, Mar 22, 2012 at 8:39 PM, Damimkader S. Meeran wrote: > Hi, > > Please review the below link it is very helpful with simple examples. > > > http://www.free-training-tutorial.com/animations/conditional-formatting-examples.html > > > Regards, > Damimkader S. Meeran > > On

Re: $$Excel-Macros$$ Excel conditional formatting-Urgent plz

/noorainansari.com/* > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > > On Thu, Mar 22, 2012 at 8:05 PM, vinod rao wrote: > >> >> Hello Experts, >> >> I need a conditional cell color showing where Region 1 showing the value >&

$$Excel-Macros$$ Excel conditional formatting-Urgent plz

Hello Experts, I need a conditional cell color showing where Region 1 showing the value over 10 should colour red and Region 2 value showing over 12 should show green. Attached file for the same. Region Value in $ 1 20 2 22 1 11 2 11 2 5 2 15 2 3 1 29 Regards, Vin -- FORUM RULES (986+ members

Re: $$Excel-Macros$$ Multipal sheet vlookup-Urgent plz

orain Ansari > *http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > > > On Wed, Mar 7, 2012 at 11:42 PM, vinod rao wrote: > >> HI Team, >> >> I need to put a vlookup for multipal sheet and get result on one sh

$$Excel-Macros$$ Multipal sheet vlookup-Urgent plz

HI Team, I need to put a vlookup for multipal sheet and get result on one sheet. Based on the sheet selection in cell hc6 the formula should get result as shown in the attached sheet. Regards, Vin -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titl

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Validate text and number in PAN

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

$$Excel-Macros$$ $$Excel-Ma​cros$$ Validate text and number in PAN

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

Re: $$Excel-Macros$$ is ther any way to keep subject line while opening outlook new mail

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: > >>

Re: $$Excel-Macros$$ Regarding VLOOKUP FUNCTION IN CLOSEST MATCH

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 >

Re: $$Excel-Macros$$ ExcelTest

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

Re: $$Excel-Macros$$ ExcelTest

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

Re: $$Excel-Macros$$ ExcelTest

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 >

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

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

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula

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

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

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

$$Excel-Macros$$ $$Excel-Ma​cros$$ Need Help on Countif formula

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

Re: $$Excel-Macros$$ Help on isblank & iferror

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

$$Excel-Macros$$ Help on isblank & iferror

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

Re: $$Excel-Macros$$ Need quick help on macros

Please help, it is very very important to me. On Mon, Sep 19, 2011 at 8:37 PM, vinod rao wrote: > Hi, > > > I need a dynamic macro delete the worksheet based. Should segregate files > accordingly, First one should contain Worksheet 1 to 7 and second file > should contain 1 to

$$Excel-Macros$$ Need quick help on macros

Hi, I need a dynamic macro delete the worksheet based. Should segregate files accordingly, First one should contain Worksheet 1 to 7 and second file should contain 1 to 2 and 8 to 11 and thrid file will be 1 to 2 and 13 & 14. Worksheet1 *Total* ** *should remain * Worksheet2 *Summary*

$$Excel-Macros$$ Excel Formula needed-Urgent help

Hi, I have put a pivot table and i need to get Gross% starting from 0% and above data listed in pivot. Can i know how to get in pivot by by adding formula? My data has both -ve and +v % but what i need is any % with greater than 0% Regards, Vin -- -

Re: $$Excel-Macros$$ Excel formula help

Thank you for your solution. On Wed, Apr 13, 2011 at 10:19 AM, STDEV(i) wrote: > try this formula and see if it helps > > =SUM(OFFSET($D8:$I8,0,0,1,MONTH(TODAY( > > > > On Wed, Apr 13, 2011 at 12:23 AM, vinod rao wrote: > >> Hi, >> I need a formula addin

$$Excel-Macros$$ Excel formula help

Hi, I need a formula adding each month one column. Attached file has a details. Regards, Vin -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/excelda

$$Excel-Macros$$ Excel graphs and formula for adding time spent

Hi Team, I need a graphs in the attached file and need a formula to add the total time spend. Any quick help will be appreciated. Regards, Vin -- -- Some important links for excel users: 1. Follow us on TWITTER for

$$Excel-Macros$$ Question about excel

Hello, I have details in summary sheet and i want the details posted to the respective sheet also. Do we have any method to have details posted to the respective sheets. Example in summary tab i have west region details and the entire row of west should also be in West sheet also is there any m

$$Excel-Macros$$ Quick help needed to Find duplicate by formula

HI I have multipal duplicate numbers and excluding one for others it should say duplicate. how do i enter formula in 2003/2007 Thanks Vinod -- -- Some important links for excel users: 1. Follow us on TWITTER for tip

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

Hi Ayush, You got the deserved Regards, Tulasi Rao On Tue, Oct 5, 2010 at 10:40 AM, seema mba wrote: > Hi Ayush! > > You really deserve that title... > > Regards, > > Seema > > On Tue, Oct 5, 2010 at 9:26 AM, Aindril De wrote: > >> Hey Ayush!! Y

Re: $$Excel-Macros$$ vlookup with 2 criteria

- Original Message From: manoj kukreja To: excel-macros@googlegroups.com Sent: Sat, 15 May, 2010 7:42:40 PM Subject: Re: $$Excel-Macros$$ vlookup with 2 criteria use vlookup ( match ,,,) funtion or sumproduct or array formula On Mon, May 10, 2010 at 8:10 PM, Sandeep Kumar Maurya

Re: $$Excel-Macros$$ Help me in contitional formating

gt; > > > > > > Hope it Will Help > > > On Tue, Apr 27, 2010 at 11:39 PM, vinod rao wrote: > > Hello, > > I want a conditional formating for the string found "to be done" in > column F > > and colour the entire row. > > > > Exa

$$Excel-Macros$$ Help me in contitional formating

Hello, I want a conditional formating for the string found "to be done" in column F and colour the entire row. Example in cell F17 i found to be done then the entire row should colour next if it is in say cell F25 then it should colour entire row of that cell Regards, Vinod --

Re: $$Excel-Macros$$ FILTER

he 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 > > &g

Re: $$Excel-Macros$$ FILTER

Hi Vikas, How did you do this?. Regards Vin On Wed, Apr 7, 2010 at 7:00 PM, Vikas Chouhan wrote: > Hi, > > Go format as table, > > On Wed, Apr 7, 2010 at 6:23 PM, Jai wrote: > >> Dear All Members. >> >> How can put the filter 2 times in One Excel file . >> >> -- >> Thanks For Mail. >> >> -- >>

Re: $$Excel-Macros$$ need help

equirements for automating the reports. > > > Regards > Yogananda.Muthaiah > Ph : 9731237267 > > On 3/19/10, Shilpa Rao wrote: > > Hi, > > > > Do we have any tools to automate financi

$$Excel-Macros$$ need help

Hi, Do we have any tools to automate financial reports? -- Regards, Shilpa -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: $$Excel-Macros$$

Hello, Please provide me any material to learn VBA codings. Advance thanks to all the experts for your help. . Regards, Shilpa On Mon, Jan 25, 2010 at 4:39 PM, Shilpa Rao wrote: > Thankyou Dave, Mahesh Ashish for all your help. Thankyou all members in > this group.. > > On Mon,

Re: $$Excel-Macros$$

Thankyou Dave, Mahesh Ashish for all your help. Thankyou all members in this group.. On Mon, Jan 25, 2010 at 6:43 AM, Dave Bonallack wrote: > Hi Shilpa, > If you really want to do this with VBA, use the code below. > > Sub VlookupVBA() > A = 1 'Start Row > Do Until Cells(A, 1) = "" >

Re: $$Excel-Macros$$ Re:

, Ayush wrote: > Hi Shilpa, > > There is no need of Macro for this...Just drag the formula for 50k > lines and it will automatically change the refernce. > Use autofill & it should work.. > > Let us know if you have doubts. > > Best regards, > Ayush Jain > > On Ja

  1   2   >