leave

Hi all Wonder if someone can help. I have a table where some columns are formulas I want to keep and some are formulas I want to overwrite with their values (paste special to remove formulas). I have code to either leave the table alone (leave all formulas) or remove all formulas and leave...

Guys, is there a way to use a formula to remove all text but only leave the numbers (as per example below). Also, remove the zero from the beginning although excel normally does this anyway. Thanks <colgroup><col><col></colgroup><tbody> Tel number Formula to remove text Mobile...

Good Day. Please help with the necessary formula. My employee gets 36 days sick leave over 36 months of work. But for the first 6 months he only get 1 day for every 26 days worked. on day 1 of the 7th month the rest of the 36 days "kick in"and needs to be added to the rest. HELP ! ...

OK I am trying to build a leave tracking for my organisation. I want the the tracking tab to obtain its information for the month from the leave planning tab. This information is entered as letters. The countifs function gives me an error, the countif means I have to copy and paste this formula...

Hi, i have this IF formula that evaluates 2 condition and I would like to add a third condition if none of previous condition are true to leave cell blank or the text no amount to pay. here is the formula: =IF(C21<i21,c7& ","="" &"="" will="" pay="=====">>> ",H13&" will pay ======>>>")...

Hello everyone, I have a document that is a job tracker in which different people can go in to in order to add suggestions to the tracker. I would like to leave the initial A column blank until data is entered into any of the cells within the range of B:L. Currently I have added A1+1 within cell...

Hi all I am using this code (Courtesy of Fluff) Private Sub Worksheet_Activate() Range("A:A").AutoFilter 1, "<>0" End Sub The issue that I'm having is that when I open the sheet with this code, it runs before the sheet is calculated. The reason for that is that I have calculation set to...

Hi . I am wanting a formula that will count the number of consecutive sames values in a column that are together but not all of them in the column. I have 365 rows and i want to be able to insert the formula in B1 and drag down to B365 so that the Value in B wil update as and when A changes...

If g15<f15 use the number in f15 in g15,if e15 is>f15 or g15 usethe number in e15 in g15, if g15>e15 and f15 leave the number in g15 as is.

I am summing rows with this formula =SUM(B2:B94) when all of the cells are blank my answer is 0, is there any way to leave the answer blank instead of showing 0?

Hi Everyone, A bit of a different one, I just want to know how remove duplicates decides which duplicates to remove? Lets say I have 5 duplicates so rows 1 to 5. if I remove duplicates does it remove 1 to 4 and leave 5? 2 to 5 and leave 1? or is it random of some other rule? thanks Tony

Hi, Can someone please help me with this? Every month I have a raw data report with these columns: Employee, Leave type (vacation, statutory holyday, other paid leave), number of hours, week, day,month. Instead of doing a pivot table, I would like to organize the information with formulas...

Help, I need a if statement that will return what is in a cell based on a another cell. I need it to know if a cell is less than 2999 but greater than 8999 to return a the value in the cell next to it. If it does not meet the criteria then leave blank. Can someone help me.

Hi All, I'm having an issue with the best way to solve a request. We have multiple projects each with a project manger and an assistant. On our annual leave spreadsheet we would like it to highlight if the manager and the assistant for any specific project book leave at the same time. I...

Hi, I have created an annual leave calendar with drop down lists for each day making it possible to select the type of leave (annual leave (1day) and annual half day leave (0.5day), in a table below I have a summary where the annual leave for each month is added up, providing an annual total at...

A kind of leave called commuted leave is credited half the half pay leave (another leave) every year. While commuted leave is credited maximum 30 in a service period, half pay leave is credited 60 in a service period (15 every year). Now if E13 = Half Pay Leave Credit, H13=Commuted Leave Credit...

A kind of leave called commuted leave is credited half the half pay leave (another leave) every year. While commuted leave is credited maximum 30 in a service period, half pay leave is credited 60 in a service period (15 every year). Now if A1 = Half Pay Leave Credit, B1=Commuted Leave Credit...

Hi Folks I have the following code that basically does not allow someone to leave the sheet they are on unless all required field are complete. It works perfect for my needs My question is is it possible to have more than one worksheet_deactivate say for Range A2 with a different message...

<article>Formula below does not return any value? What is wrong with this formula? =SUMPRODUCT(SUBTOTAL(103,OFFSET(AZ8:AZ488,ROW(AZ8:AZ488)-ROW(AZ8),0,1)),--(AZ8:AZ488<>"")) Requirement is count all cells which has text or numbers and leave the blank cells from counting. Each cell in the range...

Dear Demigods, I am using the following VBA: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Address(0, 0) = "B14" Then Cancel = True Rows("15:38").Hidden = Not Rows("15:38").Hidden End If End Sub The codes works well until i come to...