work

Hey guys, I'm brand new here, and I just joined a few minutes ago. I work at a prison work release and we have to sign prisoners in and out of the facility, and sometimes it gets pretty overwhelming. When you work 12 hour graveyard shifts, it's kind of hard to convert, calculate and subtract...

Hi All, What would be the best way to see what values obtained by Dischargers were above Pollutant Limit Values? I am dealing with 77 Dischargers and 126 pollutants, meaning, I have 77 spreadsheets and I need to check for each pollutant (126) if they were above the limit. I know how to do...

Hi, I have the following code which calculates a weighted average: =SUMPRODUCT(--($U$2:$U$1203=AE3),$AB$2:$AB$1203,$C$2:$C$1203)/SUMIF($U$2:$U$1203,AE3,$C$2:$C$1203) It works very well except that I would like it to ignore blank cells in the range $AB$2:$AB$1203 I tried to change it to the...

Hi all, how can I "converting" this formula: Range("B2") = "=TYPE(RC[-1])" into VBA ? as: Msgbox Application.WorksheetFunction.Type("B2") ---> (but does not work!!!) Tia.

Good Afternoon, I am trying to make some changes to an old work book. It has some buttons that are slightly different to anything I have come across before. I am used to buttons that have a macro assigned to them, however these buttons are all triggered by cmd_Click events on the work sheets...

Hi, Any ideas why this simple formula wont work: =IF(COUNTBLANK(I10:J10),"",NETWORKDAYS(I10:J10)) ? Many thanks

Hello all I want to print my userform on a4 in landscape. i have searched the web for answers, have found code also, but it just does not work for me. i cant really pull the data from the userform to a sheet either, well not easily, i have certian layout and tickboxes etc the code i have...

Morning all, Apologies for the second Index/Match query this morning... wasn't sure if piggy-backing onto that thread was allowed! I would like the formula to look at two separate cells in one worksheet, compare them to columns A and C in a second sheet and return the value in column E... I...

Hi all, I need some help, please. I am a truck driver and need to record my working hours, rest hours, weekly hours, fortnightly hours plus "long Hours" which are any hours worked after midnight. Not being a wiz with excel even though I use it every day to record just about everything, this...

What I have: A bunch of CSV files with data. Say 300k rows each one. CSV files: if opened directly, they're in the wrong encoding and characters don't show up as they should. There's no option to select which encoding to use or which should be the default for all files? What also doesn't...

Hi! I have made workbook with userform with Excel 2010 and now im trying to open it with Excel 365 and get error &H8000FFFF. Can anyone help me how i would get my workbook work with Excel 365? -Late

I have a list of phone #'s in the format 519-555-5551 410-555-5222 I would like to remove the dash so the output looks like 5195555551 4105555222 I've tried find and replace but it does not work. Any thoughts? TIA

<ytd-expander id="expander" class="expander-exp style-scope ytd-comment-renderer" style="display: block; --ytd-expander-button-margin:4px 0 0 0; --ytd-expander-collapsed-height:80px;"><yt-formatted-string id="content-text" slot="content" split-lines="" class="style-scope ytd-comment-renderer"...

Hello, I'm starting to sweat over something I just discovered. An Excel workbook with a Form as the first worksheet and the values transferred to the second worksheet that I created in Excel 2013 no longer transfers the values from the first worksheet to the second worksheet. What is going...

I need one more thing <d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""><d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8="">=IF(H8< D2,"In Darkness",IF(H8=D2,"Under Light",IF(AND(H8> D2,H8< F2),"Under Light",IF(H8>...

Hi All, I have a workbook that as two sheets with master data. Each week I have to send only the relevant data to specific users. I need a macro that will select the criteria on the filter, on each sheet in 'Column B' with everying except the data that need to be sent to the user and delete...

If H8 is less then D2 say "Not Ready", If H8 is between D2 and F2 say "All Most", If H8 is more than F2 say "Done"

Hi, Hope I can get some help with adding code to loop through the dates in column A of Sheet1 & compare them to the dates in Column A, Sheet2. If the date on Sheet2 is greater than Sheet1 run the MatchColumns macro. Sheet1 accumulates jobs with recommendations through out the year. Sheet2...

Hi, I'm trying to replicate a sumproduct formula in Power query editor within a custom column. Previously used working formula: =IF(SUMPRODUCT(($C$2:$C2=C2)*($E$2:$E2=E2))>1,0,1) I know sumproduct isn't used in power query, and after searching the net have attempted to use SumX but this...

Hello, I have a userform and looking for a way to add a popup calendar to insert a date in a textbox, I searched google and found the way below, I followed it step by step, but it didn't work, https://chandoo.org/wp/pop-up-calendar-excel-vba/ Do you have any way to activate it? I have...