Re: $$Excel-Macros$$ conditional formatting

Help me understand: Value 0 to 2 = Green Value greater than 2 = Red Is this what you want? On Wed, Feb 20, 2013 at 11:55 AM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Expert, > > > > I want to create conditional formatting for below information > > Please help me

Re: $$Excel-Macros$$ Help required in Bifurcation of data from one column to another two

Hi Sandeep, Welcome to the group. I hope that the experts here would help resolve your query. Meanwhile, could you also share with us the text file (in its original format) from which you have imported this data. I believe it would help in getting a better insight. Thanks, Abhishek On Wed, Fe

$$Excel-Macros$$ Help required in Bifurcation of data from one column to another two

Dear Experts, This is my first interaction with this group though I have been a member of this group for a long. Let me introduce my self as Sandeep, works for the Hospital in Accounts department. Most of my work is related with excel and I do have a sound knowledge of excel but not to the expert

$$Excel-Macros$$ conditional formatting

Dear Expert, I want to create conditional formatting for below information Please help me on this Minor (If Cell is =2 should show green &if cell is great than >2 should show red) Major(If Cell is > 0 red =0 green ) Thanks Manjunath PLEASE CONSIDER THE ENVIRO

Re: Fw: Re: $$Excel-Macros$$ IF Doubt - Query

See whether it works Kantilal Badale On Wed, Feb 20, 2013 at 11:02 AM, Kenil Gala wrote: > > I have changed the example, hope if it helps. > Pls help > > Thanks in adv. > --- On *Wed, 2/20/13, Abhishek Jain * wrote: > > > From: Abhishek Jain > Subject: Re: $$Excel-Macros$$ IF Doubt - Query > T

Fw: Re: $$Excel-Macros$$ IF Doubt - Query

I have changed the example, hope if it helps.Pls help Thanks in adv. --- On Wed, 2/20/13, Abhishek Jain wrote: From: Abhishek Jain Subject: Re: $$Excel-Macros$$ IF Doubt - Query To: excel-macros@googlegroups.com Date: Wednesday, February 20, 2013, 10:27 AM Your query is not very clear. Could y

Re: $$Excel-Macros$$ Please share inputs to format Date

Dear Users, It can be possible with =SUBSTITUTE(SUBSTITUTE(B2,".","/",1),".","/") also an another approach. Warm Regards, Gawli Anil. On Tue, Feb 19, 2013 at 6:23 PM, Kuldeep Singh wrote: > > Hi Harshad, > > Try this one. > > *=MID(SUBSTITUTE(SUBSTITUTE(A2,".","/",2),".","/",1),1,10)* > > Reg

Re: $$Excel-Macros$$ IF Doubt - Query

Your query is not very clear. Could you be a little more specific? Thanks, On Wed, Feb 20, 2013 at 10:11 AM, Kenil Gala wrote: > > > > Hi group, Pls help. > > I have a small query for solving IF Function. > i want the the answer which is in between the two given values. > > Pls Help > Thanks in

Re: $$Excel-Macros$$ Locking Particular Cells in Excel

Dear Prabakar, Pl find the attached sheet. I'm not getting any type of message. first of all select all cells by pressing cltr+A then goto formatcells and uncheck protect checkbox. then select that cell which u want to lock and again goto formatcells check protect checkbox. then goto review tab

$$Excel-Macros$$ IF Doubt - Query

Hi group, Pls help. I have a small query for solving IF Function.i want the the answer which is in between the two given values. Pls HelpThanks in adv. -- 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 official Facebook page of this for

Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need help....

Thanks Paul. :) On Tue, Feb 19, 2013 at 10:28 PM, Paul Schreiner wrote: > Sorry, you're not going to get around THAT one. > Basically, you have an Excel file (this login/logout file) > that is taking over your CPU cycles every second to update the sheet. > > If you open another Excel file, t

Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need help....

Sorry, you're not going to get around THAT one. Basically, you have an Excel file (this login/logout file) that is taking over your CPU cycles every second to update the sheet. If you open another Excel file, those silly people at Microsoft think that you want to WORK on the newly opened excel fi

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

Hi Paul - OOPS! I didnt see you had finished it. Sorry. Regards David Grugeon On 20 February 2013 07:08, David Grugeon wrote: > Hi Paul > > What i think the OP wants is > > If a person started in the year he wants the end date of the year (31 > December) minus Start date (probably +1) unde

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

Hi Paul What i think the OP wants is If a person started in the year he wants the end date of the year (31 December) minus Start date (probably +1) under that years column. If a person ended during the year he wants the end date -1st January +1 in that year column If a person started before the

Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need help....

*Thanks Paul, thanks a lot, it's just perfect. :)* On Tue, Feb 19, 2013 at 8:42 PM, Paul Schreiner wrote: > you should be able to subtract the login time from the current date/time > (now()) > and format it as hh:nn:ss using: > > ThisWorkbook.Sheets(2).Range("k20").Value = Format(Now() - >

Re: $$Excel-Macros$$ Calculation of Import Value

Work it out like this a) Value b) Custom duty = value*0.2 c) Value + Custom Duty =value*1.2 d) Sales Tax = Value *1.2*0.16 e) value +custom duty +Sales tax =value*1.2+Value *1.2*0.16 = value*1.2*1.16 =value*1.392 f)Income Tax =value*1.392*0.06 g) value +custom duty + sales tax + income t

Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need help....

you should be able to subtract the login time from the current date/time (now()) and format it as hh:nn:ss using: ThisWorkbook.Sheets(2).Range("k20").Value = Format(Now() - Sheets(2).Range("i9").Value, "hh:nn:ss")   Paul - “Do all the good you can, By all t

Re: $$Excel-Macros$$ how to get cumulative sum in a cell

Hi Anton How are you calling the sub? Regards David Grugeon On 20 February 2013 04:40, Anton Jopko wrote: > Hi David, > I tried your suggestion but still no luck. I may have to get a VBA book > that is simpler than the one i have. > Thanks for looking at my macro though, > anton > > > David G

Re: $$Excel-Macros$$ Calculation of Import Value

Hi Rasheed, Use this =SUM(IF((A1:A8="custome duty")+(A1:A8="sales tax")+(A1:A8="income tax"),C1:C8,"")) with ctrl+shift+enter. On Tue, Feb 19, 2013 at 1:18 PM, Rasheed Razzaq wrote: > Dear Experts, > I need a formula or function for calculation of Taxes in single cell. > > Val

$$Excel-Macros$$ Re: Login and Logout time tracker...need help....

Sorry attached wrong file, in my previous mail... On Tue, Feb 19, 2013 at 8:09 PM, Indrajit $nai wrote: > Hi Experts, > > Need a small help from your end. I've created a login and logout time > tracker, which is working perfectly, but I want to show running login hrs > in this file, as of no

Re: $$Excel-Macros$$ What is Ylookup in Excel...

Probably a type mistake, if you translate to coordinates, Hlookup is a X-axis lookup and Vlookup is as a Y-axis lookup, you can also do lookups with match and index. On 16 February 2013 09:18, Kuldeep Singh wrote: > > Okay Thanks. > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.co

Re: $$Excel-Macros$$ Please share inputs to format Date

This still doesn't address his requirement to reverse the day/month to month/day. In fact, if you do not address this as part of the text string, then you risk corruption the date! If the original data is dd.mm. and his Windows environment is set up to display dates as mm/dd/ then, whe

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

Dear Paul, Yes your interpretation is absolutely correct and so is your formula Magnificent. Absolutely amazing. Thanks a lot for the solution On Tuesday, February 19, 2013 5:04:54 PM UTC+4, Paul Schreiner wrote: > ASSUMING my previous interpretation is correct, > then the logic is: > > The

Re: $$Excel-Macros$$ Please share inputs to format Date

A couple of things here: The original request was a result that changed the "dd.mm." format to "mm/dd/" If you were ONLY wishing to replace the "." with "/", then you wouldn't need the "nested" substitutes: =SUBSTITUTE(A3,".","/") would replace all of the occurrences of the "." the =Mid

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

ASSUMING my previous interpretation is correct, then the logic is: The starting date for each "year" is the larger of the first day of the year in row 1, and the date in column B. to determine THAT, the start date would be: Start Date = MAX($B2,DATEVALUE("1/1/"&D$1)) The End date would be the s

Re: $$Excel-Macros$$ Please share inputs to format Date

Hi Harshad, Try this one. *=MID(SUBSTITUTE(SUBSTITUTE(A2,".","/",2),".","/",1),1,10)* Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print thi

Re: $$Excel-Macros$$ Please share inputs to format Date

are you wanting a VBA solution or an Excel solution? For Excel: If your string is consistent, as the formatting suggests, and the date is in cell A1, then you can use: =DATEVALUE(MID(A1,4,2)&"/"&LEFT(A1,2)&"/"&RIGHT(A1,4))   Paul - “Do all the good you ca

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

I'm really very sorry, but your explanation continues to make no sense. Basically, it's this: You want the number of days between two dates. For that, you need two dates. So, in your example, the solution in D2 of 365 days. What was used as the Start Date and what was used as the End Date? perhap

$$Excel-Macros$$ Please share inputs to format Date

Hi, I want to convert 18.01.2011(DD.MM.) to 01/18/2011 (MM/DD/). Best Regards, Harshad Khandare -- 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 official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM R

Re: $$Excel-Macros$$ Locking Particular Cells in Excel

Please follow the below link u will get the awesome detailed answer bro.. http://www.techonthenet.com/excel/cells/protect2007.php On Tue, Feb 19, 2013 at 11:21 AM, Prabhakar H wrote: > Can you explain me how did you do lock the cell. > > Rgds, > Prabhakar > > On Tue, Feb 19, 2013 at 10:13 AM,

Re: $$Excel-Macros$$ Locking Particular Cells in Excel

Can you explain me how did you do lock the cell. Rgds, Prabhakar On Tue, Feb 19, 2013 at 10:13 AM, अनिल नारायण गवली wrote: > Dear Prabakar, > > Pl find attached sheet . > > Warm Regards, > Gawli Anil > > On Tue, Feb 19, 2013 at 10:07 AM, Prabhakar S H > wrote: > >> Hi Experts, >> >> I am not a

Re: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

Thanks for the response. Both the solution does not give the result I wish to have... Let me try to explain it with the Data in S.No. 1 only I wish to have a formula in D2 which will calculate the elapsed days between the Start and End Date under that particular year. For example S.No. under 2010

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password *

Don't post questions regarding breaking or bypassing any security measure. On Tue, Feb 19, 2013 at 6:00 AM, Will Smith wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (willsyssm...@gmail.com) Add cleanup > rule

Fwd: $$Excel-Macros$$ Need Excel Formula for Color Count

Dear Brother, What is this xlsm file as this formula is not working in my excel sheet. On Tue, Feb 19, 2013 at 11:57 AM, अनिल नारायण गवली wrote: > Dear ikhan, > > Pl find attached herewith. > > Warm Regards, > Gawli Anil > > On Tue, Feb 19, 2013 at 11:47 AM, Imran khan wrote: > >> Hi, >>

Re: $$Excel-Macros$$ Need formula to retrieve value

This might help - http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ On Tue, Feb 19, 2013 at 1:16 PM, Rakesh Kumar Sharma wrote: > Dear Abhishek, > > Working fine > > Will yo please explain this how it works? > > > > > On Tue, Feb 19, 2013 at 12:55 PM, Abhishek Jain wrote: > >> Check at

RE: $$Excel-Macros$$ Count No of Days between Start and End Date over a period of different years

Use this =MAX(DATE(D$1,MONTH($C2),DAY($C2))-$B2,0) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rashid Khan Sent: 19 February 2013 1:41 To: excel-macros@googlegroups.com Subject: $$Excel-Ma