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
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
Hi Sam,
But i am unable to put 0% to 2% to yellow.
On Sat, Sep 29, 2012 at 7:35 PM, vinod rao vinod.ma...@gmail.com 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.
Thanks
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 vinod.ma...@gmail.com 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 vinod.ma...@gmail.com wrote:
Hi
rao vinod.ma...@gmail.com 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 vinod.ma...@gmail.comwrote:
Hi Sam,
But i am unable to put 0% to 2% to yellow.
On Sat, Sep 29, 2012 at 7:35 PM
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
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
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 dguille...@gmail.com wrote:
Just use datafilterautofilter
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* vinod rao
be entered using ctrl+shift+enter
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* vinod rao vinod.ma...@gmail.com
*Sent:* Monday, August 20, 2012 1:05 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ MS Excel Vlookup query
Hi,
I
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 vinod.ma...@gmail.com 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 dguille
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+
/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Thu, Mar 22, 2012 at 8:05 PM, vinod rao vinod.ma...@gmail.com wrote:
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
Thank you Meeran :)
On Thu, Mar 22, 2012 at 8:39 PM, Damimkader S. Meeran damim.ka...@gmail.com
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.
://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Wed, Mar 7, 2012 at 11:42 PM, vinod rao vinod.ma...@gmail.com wrote:
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
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
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*
Please help, it is very very important to me.
On Mon, Sep 19, 2011 at 8:37 PM, vinod rao vinod.ma...@gmail.com 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 2
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
--
Thank you for your solution.
On Wed, Apr 13, 2011 at 10:19 AM, STDEV(i) setiyowati.d...@gmail.comwrote:
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 vinod.ma...@gmail.com wrote:
Hi,
I need a formula adding
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 :
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
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
it Will Help
On Tue, Apr 27, 2010 at 11:39 PM, vinod rao vinod.ma...@gmail.com wrote:
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
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
--
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 vinod.ma...@gmail.com wrote:
Hi Vikas,
How did you do this?.
Regards
Vin
On Wed, Apr 7, 2010 at 7:00 PM, Vikas Chouhan
Hi Vikas,
How did you do this?.
Regards
Vin
On Wed, Apr 7, 2010 at 7:00 PM, Vikas Chouhan vikask...@gmail.com wrote:
Hi,
Go format as table,
On Wed, Apr 7, 2010 at 6:23 PM, Jai jaihumtu...@gmail.com wrote:
Dear All Members.
How can put the filter 2 times in One Excel file .
--
Hello Friends,
Can i get a help for said query?. Thanks in advance.
On Wed, Jan 13, 2010 at 3:13 PM, vinod rao vinod.ma...@gmail.com 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 vinod.ma...@gmail.comwrote:
Hi Ankur
, 2010 at 1:34 PM, vinod rao vinod.ma...@gmail.comwrote:
Hello Friends,
Can i get a help for said query?. Thanks in advance.
On Wed, Jan 13, 2010 at 3:13 PM, vinod rao vinod.ma...@gmail.comwrote:
Hello Friends,
Can i get a help for said query?. Thanks in advance.
On Wed, Jan 13, 2010
Hello Friends,
Can i get a help for said query?. Thanks in advance.
On Wed, Jan 13, 2010 at 1:18 PM, vinod rao vinod.ma...@gmail.com 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
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
:
hi Vinod
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 vinod.ma...@gmail.com wrote:
HI Team,
I want a vba for Sum if and finding duplicate values. Plz find attached
Thank you for all of my excel experts.
On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com 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
This info helped me too.
On Tue, Dec 15, 2009 at 1:24 PM, vinod rao vinod.ma...@gmail.com wrote:
Thank you for all of my excel experts.
On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote:
Hi Friends,
I have 2 excel file having 12 sheets in it, what I want is to merge
Hope this helped,
Rolf Jaeger
SoarentComputing
http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm
On Nov 19, 8:47 am, vinod rao vinod.ma...@gmail.com wrote:
HI Friends,
I have a question in excel formula,
I have a number which gives total numbers of minuts, example 32269
HI Rolf
I got it, Thank you.
On Fri, Nov 20, 2009 at 2:42 PM, vinod rao vinod.ma...@gmail.com wrote:
Hello Rolf,
Can you plz put it in xls file?
Thanks
vr
On Fri, Nov 20, 2009 at 11:58 AM, RolfJ r...@pacificsound.us wrote:
This might work for you. Let's assume that the total numbers
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
--
Could you explain the requirement a little more.
On Tue, Nov 17, 2009 at 10:26 PM, vinod rao vinod.ma...@gmail.com wrote:
Thanks Andy. Plz help me on other file about deleting columns
On Tue, Nov 17, 2009 at 8:46 PM, Aindril De aind...@gmail.com wrote:
Hi VR,
Please use the following code
, 2009 at 8:15 AM, vinod rao vinod.ma...@gmail.com wrote:
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
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
wrote:
Hi,
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 vinod.ma...@gmail.comwrote:
Hello Team,
I need a macro to change Column B from Tisp to PAT if the Column D is Core
attaching the
Excel sheet with the Macro.
Regards,
Andy
On Tue, Nov 17, 2009 at 8:15 PM, vinod rao vinod.ma...@gmail.comwrote:
Hello Team,
I need a macro to change Column B from Tisp to PAT if the Column D is Core
Regards,
VR
hemantbales...@gmail.comwrote:
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 vinod.ma...@gmail.com
HI Team,
Need a VBA code for doing pivot - below condition is needed
1
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
to all
Hemant Hegde
2009/10/15 vinod rao vinod.ma...@gmail.com
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
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
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),
, 21:28, vinod rao vinod.ma...@gmail.com wrote:
Hello Team,
Need ranking formula.See attached, kindly help.
Regards
Text.xls
18KViewDownload
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
in 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 vinod.ma...@gmail.comwrote:
Hello Vivek,
Still it didn't work. if the number
...@gmail.comwrote:
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 vinod.ma...@gmail.com wrote:
Hello Team,
How do i
GoogleMoonlight.com - Saving energy-Save Earth
On Wed, Aug 26, 2009 at 11:04 AM, vinod rao vinod.ma...@gmail.comwrote:
Thank you Very much.
Can we have in reverse order, I mean low to high.?
Advance thanks to all members.
Example
Amount Rank
200 4
1002
-50
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 vinod.ma...@gmail.com wrote:
Hello Vivek,
I could not get the right answer. I need like
Example
Amount Rank
200 3
100 2
-50NA
Thanks 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 vinod.ma...@gmail.comwrote:
Hello Vivek,
I could not get the right answer. I need like
Example
Amount Rank
200 3
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
--~--~-~--~~~---~--~~
it should rank (1,2,3)
Please assist.
Regards,
Vinod
On Fri, Aug 21, 2009 at 1:09 PM, vinod rao vinod.ma...@gmail.com 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
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?
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
Hello,
Plz let me know below query.
On Thu, Jul 2, 2009 at 2:26 PM, vinod rao vinod.ma...@gmail.com 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 sachina...@gmail.comwrote:
Dear Dilip
58 matches
Mail list logo