leaving

=IF($DF2=5,"5/6", IF($DF2=6,"5/6",$DF2)) I have put this formula in column DG. I would like for it to change all of the 5's and 6's in column DF to 5/6 and the leave the other values as they are . Currently, it is leaving all of the values as they are - not changing 5 and 6 to 5/6. Any idea...

Hi I have looked at this thread which was helpful but doesn't give me quite what I need.. https://www.mrexcel.com/forum/excel-questions/1002856-vba-clearing-specific-table-columns.html I also found this useful and started to write the code but realised it was referencing rows and I need...

I would like to prevent the user from leaving Sheet1 if certain conditions are not met. I'm using the Worksheet_Deactivate event in the Sheet1 module. However, when the user attempts to leave Sheet1 by selecting Sheet2, the Sheet2 Worksheet_Activate event runs even though I have...

I have had a troll through and cannot seam to find any answers to a resolution for thew below scenario. I have multiple text strings with "" in varying locations.Generally up to 1000 rows of which there are text strings withing the "" that I wish to retain. ENQUIRY-01-01-08-18\W_SC-Lightning...

Subtracting time with a flexible outcome & possibly a negative outcome In the chart below: - the "Estimated Time on Leg" is fixed -the "Time on Leg" is variable -the "Estimated Time Remaining" is the countdown from the "Time on Leg -And if B4 is blank, the I want C4 to be blank So if all is...

hi can any one help please, really stuggling to get this numbering to work, i have a list of wagons days leaving and need to order them with numbers counting, wagon leaving sum needed to auto count according to time leaving like...

<tbody> 00080236528-GP0KA I need the leading zeros to go away. leaving me with <tbody> 80236528-GP0KA thanks </tbody> </tbody> Note, there are varying numbers of 0s' and the length of the string isnt the same all the time.

I have a worksheet with hundreds of cells, some with numbers and some with zeros. Can I use the Find and Replace function to "find any number, and replace with 1" ? Leaving me with just 1s and 0s. Thanks

I would like to change a column wherein only the month needs to be changed for the whole column (day needs to stay the same). Rather than manually changing the month for each cell in the column, is there a formula to just change the month leaving day the same for the entire column? Can this be...

How do you make a box or column wider for a certain area while leaving the rest of the column below unchanged? Thank you in advance.

If i have A B C D in columns 1,2,3 and 4 respectively, then press CTRL SHIFT L, Excel swaps columns 1 and 2, with 3 and 4!!! Leaving me with C D A B . . . and i can't even UNDO IT! My coworker is fine. Excel 2013, all files, even after a reboot. Thoughts?

Hello all Can anyone spot the mistake here please The copying from one sheet to the other is working ok but it is leaving in the formulas instead of just the values [Worksheets("Statistics").Range("B3:K22").Copy Worksheets("Statistics Fixed").Range("B3:K22").PasteSpecial paste:=xlPasteFormulas]

Hi Sure this is a simple one . I have a workbook that is used by multiple users , It updates every 10 mins with data from another source . User have a habit of opening it and leaving it open , How can I close and save the workbook after a specified time , say half an hour

Firstly, many thanks for taking the time to read. I am using the following formula to return the number of employees that are leaving in the coming month which works perfectly fine. However, the report I run is always as at the last day of the month and it also neds to capture employees who...