operators

Hi, I am trying to divide the result of one sumifs() statement by the result of another sumifs() statement, but the sum range and criteria ranges referenced in the second statement are not working.The ranges are valid but they are not highlighted in the sheet and the formula returns an error...

I have a spreadsheet where the columns are (A)operator (B) time of transaction (C) transaction type. The same operator can be listed up to 200 times in the spreadsheet. I need a way to calculate the operators total time (Last transaction minus first transaction). I have 50 operators within the...

I am trying to create a list on one worksheet based on data from another worksheet using two drop down boxes. I have a main spreadsheet that houses a list of operators, with their corresponding status (active, dropped, termed) and supervisor name. I would like to be able to select the supervisor...

Hello, This is my first time posting. Everyday my operators collect data and save them as a WB with the date as the name. I have created a "Master" WB where I copy and store only specific cells from the operator's WBs. Due to the nature of the formatting in the WBs I need to constantly go back...

Hi all, i would like to write a vba so that to delete the second duplicate entire rows as my below extracts. In sch. 2. are the original data and on sch. 2. is the expected result. Thanking you in advance Sch.1. <colgroup><col...

Hi All, For the life of me I can't get this working, despite throwing quotes all over it. The sheet has a formula in it at present: =IF(COUNTIF($H$5:$H$50000,"<"&">"&"")=0,"",COUNTIF($H$5:$H$50000,"<"&">"&"")) Which simply counts the nonblank cells (likely not the best way but hey, it works)...

Hi I have a workbook which has 6 worksheets, on 1 particular worksheet "NEW PLAN" jobs are moved around by the operators and these cells contain formating and conditional formatting.. What I am after for this worksheet ONLY by VBA code to let the operators copy but restrict to paste value ONLY...

Hi everyone, Thanks for reading my question. Here is some background: I have some code that uses a formula to write a formula then its result into a selected range of cells that are in a table. It works fine for a formula such as: rng.Formula = "=COUNTIF([Material Number],[@[Material...

I am stuck on how to make a formula that would count how many people in Section B telework on the First Monday of the pay period. The Telework data is in 4 different columns. I am stuck on using the And/Or operators. Any ideas? Countifs(C:C,"Section B") And countifs(F:F, "Monday P1") or...

Hello, I am having an issue with an Autofilter in VBA. See below for the current code. The desired result is to specify two dates and filter between those dates but also include the dates as well. Currently the filter is not returning the EDate values (it is returning the Sdate values). Also, I...

By way of explanation, I am in the real estate business. Over the years I have found the MLS to be too one-dimensional, so I built an ever-evolving means of illuminating the ways in which markets behave. For example, consider the following array formula: <?xml:namespace prefix = o ns =...

My formula is working fine, and sits in cell B2: <table x:str="" style="border-collapse: collapse; width: 422px; height: 36px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 206pt;" width="274"><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 206pt;"...