$$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 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$$ 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$$ 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$$ 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$$ 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$$ Kindly help!! Sumif vba needed.

; On Thu, Jan 14, 2010 at 1:34 PM, vinod rao wrote: > >> Hello Friends, >> Can i get a help for said query?. Thanks in advance. >> >> On Wed, Jan 13, 2010 at 3:13 PM, vinod rao wrote: >> >>> Hello Friends, >>> Can i get a help for said query?.

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

Hello Friends, Can i get a help for said query?. Thanks in advance. On Wed, Jan 13, 2010 at 3:13 PM, vinod rao wrote: > Hello Friends, > Can i get a help for said query?. Thanks in advance. > > On Wed, Jan 13, 2010 at 1:18 PM, vinod rao wrote: > >> Hi Ankur, >>

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

Hello Friends, Can i get a help for said query?. Thanks in advance. On Wed, Jan 13, 2010 at 1:18 PM, vinod rao wrote: > Hi Ankur, > > This dont work because i have 25 thousands of lines items one below another > and it takes long time to refresh page. > So better have vba program

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

I try to Slove the your Query Without The help of VBA > > Please Check the Attached File , male me for any other clarifcation > > thanks > > On 1/12/10, vinod rao wrote: > > HI Team, > > > > > > > > I want a vba for Sum if and finding duplicate

$$Excel-Macros$$ Kindly help!! Sumif vba needed.

HI Team, I want a vba for Sum if and finding duplicate values. Plz find attached with highlighted columns/rows. Is this possible? Regards, Vin -- -- Some important links for excel users: 1. Follow us in TWITTER

Re: $$Excel-Macros$$ need help in excel

This info helped me too. On Tue, Dec 15, 2009 at 1:24 PM, vinod rao wrote: > Thank you for all of my excel experts. > > On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao wrote: > >> Hi Friends, >> >> I have 2 excel file having 12 sheets in it, what I want is to merge

Re: $$Excel-Macros$$ need help in excel

Thank you for all of my excel experts. On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao wrote: > Hi Friends, > > I have 2 excel file having 12 sheets in it, what I want is to merge two > file into one. I tried using move or copy but it din't work. Is there any > method. Please not that i have formula

Re: $$Excel-Macros$$ Re: Urgent Need help on formula.

*60 -> 49 > for your example > > Hope this helped, > Rolf Jaeger > SoarentComputing > http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm > > On Nov 19, 8:47 am, vinod rao wrote: > > HI Friends, > > > > I have a question in excel formula, >

Re: $$Excel-Macros$$ Re: Urgent Need help on formula.

HI Rolf I got it, Thank you. On Fri, Nov 20, 2009 at 2:42 PM, vinod rao wrote: > Hello Rolf, > > Can you plz put it in xls file? > Thanks > vr > On Fri, Nov 20, 2009 at 11:58 AM, RolfJ wrote: > >> This might work for you. Let's assume that the total numbers

$$Excel-Macros$$ Urgent Need help on formula.

HI Friends, I have a question in excel formula, I have a number which gives total numbers of minuts, example 32269 and it is minutes total. Can excel find numbe of days and hours and minutes in that total. This is very urgent. kindly help Regards, Vr --

Re: $$Excel-Macros$$ Urgent help on simple macro

I got it, I changed Integer as long and worked fine. Thanks all the memeber in this group, On Wed, Nov 18, 2009 at 10:24 PM, vinod rao wrote: > No Sir, > > It did not go below 6500 lines.It stoped in that cell. > > I have data till end of the sheet. > > Plz help > O

Re: $$Excel-Macros$$ Urgent help on simple macro

uot;PAT" > End If > i = i + 1 > Loop While i < lngLastRow > End Sub > > > > On Tue, Nov 17, 2009 at 8:15 AM, vinod rao wrote: > >> Hello Team, >> >> I need a macro to change Column B from Tisp to PAT if the Column D is Core &

Re: $$Excel-Macros$$ Urgent help on simple macro

If ActiveCell.Value = "Tisp" And ActiveCell.Offset(0, > 3).Value = "Core" Then ActiveCell.Value = "PAT" > i = i + 1 > Next > End Sub > Please let us know if you need any further help. I am also attaching the > Excel sheet with the Macro. >

Re: $$Excel-Macros$$ Urgent help on simple macro

VR Could you explain the requirement a little more. > > > On Tue, Nov 17, 2009 at 10:26 PM, vinod rao wrote: > >> Thanks Andy. Plz help me on other file about deleting columns >> >> >> On Tue, Nov 17, 2009 at 8:46 PM, Aindril De wrote: >> >>> H

Re: $$Excel-Macros$$ Urgent help on simple macro

ot;PAT" > i = i + 1 > Next > End Sub > Please let us know if you need any further help. I am also attaching the > Excel sheet with the Macro. > > Regards, > Andy > On Tue, Nov 17, 2009 at 8:15 PM, vi

Re: $$Excel-Macros$$ Urgent help on simple macro

; > As per my understanding I have attached a solution of it. Please find the > attached file. > > Regards, > > Deepak Rai > > On Tue, Nov 17, 2009 at 6:45 PM, vinod rao wrote: > >> Hello Team, >> >> I need a macro to change Column B from Tisp

$$Excel-Macros$$ Urgent help on simple macro

Hello Team, I need a macro to change Column B from Tisp to PAT if the Column D is Core Regards, VR -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at h

$$Excel-Macros$$ Re: need macro for a simple vlookup and pivot

wrote: > Hi > > I did not understand what you want to accomplish with a VBA code. > > But can i pls know why you hate recorded macros? > > > Hemant Hegde > > > 2009/11/2 vinod rao > >> HI Team, >> >> Need a VBA code for doing pivot - below

$$Excel-Macros$$ need macro for a simple vlookup and pivot

HI Team, Need a VBA code for doing pivot - below condition is needed 1 Z F C I am eliminating these from pivot table, see pivot for more details 2 if name k is available it should be considered in pivot 3 I don’t want recorded vba macro Second simple macro on vlookup. See attache

$$Excel-Macros$$ Re: Need a formula in picking right status

ali to all > > Hemant Hegde > > > > 2009/10/15 vinod rao > >> HI Expert Guru, >> >> I need a formula in finding status in column G. For reference the result >> expected is given in column J. >> >> The contion is the status should be picked

$$Excel-Macros$$ Need a formula in picking right status

HI Expert Guru, I need a formula in finding status in column G. For reference the result expected is given in column J. The contion is the status should be picked based on the latest date. condition 2 is if the date is same for expire and active consider active At least i want the first conditio

$$Excel-Macros$$ Re: Need help in finding solution

>MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > On 9/30/09, vinod rao wrote: >> >> Hi >> >> Plea

$$Excel-Macros$$ Need help in finding solution

Hi Please find attached sheet with questions Thanks in advance. Regards, Vr. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), F

$$Excel-Macros$$ Need urgent help on finding formula

HI Team, need a foumula to find the latest Date and in next column the Status Plz find attached.file. Thanks in advance. VR --~--~-~--~~~---~--~~ -- Some important links for excel users

$$Excel-Macros$$ Re: Urgent_ Need ranking formula

amesh > > > On 9 Sep, 21:28, vinod rao wrote: > > Hello Team, > > > > Need ranking formula.See attached, kindly help. > > Regards > > > > Text.xls > > 18KViewDownload > > > > --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Urgent_ Need ranking formula

Hello Team, Need ranking formula.See attached, kindly help. Regards --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-i

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

red with yellow... > > Hope this helps > > Thanks and Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > > > > On Thu, Aug 27, 2009 at 7:15 PM, vinod rao wrote: > >> >> Hello Vivek, &g

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

and Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > > > > On Wed, Aug 26, 2009 at 3:47 PM, vinod rao wrote: > >> Hello Vivek, >> >> I could not get the right answer. I need like >

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

Plz help! I am looking as mentioned in column G Plz see attached file. On Wed, Aug 26, 2009 at 3:47 PM, vinod rao wrote: > Hello Vivek, > > I could not get the right answer. I need like > > Example > > Amount Rank > 200 3 > 100

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

- vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > > > > On Wed, Aug 26, 2009 at 11:04 AM, vinod rao wrote: > >> Thank you Very much. >> >> Can we have in reverse order, I mean low to high.? >> Advance thanks to all memb

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

Hi > > attached is the solution to your query > > Hope it helps > > > > Thanks and Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > > > > On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wro

$$Excel-Macros$$ Need help on formula

Hello Team, How do i rank only positive numbers. Plz help me on formula. Example Amount Rank 200 2 100 3 -50NA 10 4 -5 NA 3001 --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

Hi Prashanth, Your solution is perfect but the disadvantage is the file size is going to increase as my data his huge. But good attempt i really appreciate Regards, Vinod On Sat, Aug 22, 2009 at 9:02 AM, Prashant Bhawar wrote: > > > On Fri, Aug 21, 2009 at 1:09 PM, vinod r

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

Hi Dave, You are a STAR!!!. I really appreciate your efforts. Thank you very much. Best regards, Vinod On Fri, Aug 21, 2009 at 4:11 PM, Dave Bonallack wrote: > Hi Vinod, > Have a look at the attached. > I have had to use a helper column to extract the "Bricks, Tiles, Glass" > info > Then u

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

should rank (1,2,3) Please assist. Regards, Vinod On Fri, Aug 21, 2009 at 1:09 PM, vinod rao wrote: > Hello Team, > > I have attached file in which i need a formula in the column E, instead of > the manual ranking in need a formula based on the item mentioned in the > column C. &g

$$Excel-Macros$$ Need Urgent help in finding formula.

Hello Team, I have attached file in which i need a formula in the column E, instead of the manual ranking in need a formula based on the item mentioned in the column C. Please make a note, ranking is based on the largest value to the particular item in C. ie Glass/Tiles/Bricks Kindly assist asap.

$$Excel-Macros$$ Need Urgent Excel Help needed

Dear Expert Members. I need automatically hide or unhide the column without using macro. For Example: I will type Hide B the given cell A1 and excel should hide column B column I will type Unhide A in the given cell A1 and excel should unhide B column. Is this really possible without macros? Ki

$$Excel-Macros$$ Help needed on MS Access user guide.

Hello Team, Can someone help me in getting the MS access user manual or guide which help to understand?. Thanks in advance Regards Vinod --~--~-~--~~~---~--~~ -- Some important links

$$Excel-Macros$$ Re: Urgent Help Required

Hello, Plz let me know below query. On Thu, Jul 2, 2009 at 2:26 PM, vinod rao wrote: > Hello, > > Can i know how was radio icon created linked to year 1,2 3.? > > Thanks in advance. > Vinod > > On Wed, Jul 1, 2009 at 5:09 PM, Sachin Shukla wrote: > >> De

$$Excel-Macros$$ Re: Urgent Help Required

Hello, Can i know how was radio icon created linked to year 1,2 3.? Thanks in advance. Vinod On Wed, Jul 1, 2009 at 5:09 PM, Sachin Shukla wrote: > Dear Dilip, > > Thanks a lot. Its working. > > > Thanks > > Sachin Shukal > > On Wed, Jul 1, 2009 at 3:57 PM, Dilip Pandey wrote: > >> Hi Sachin