1. O

    Dividing a sumifs() statement by another sumifs() statement - Problem: Second sumifs() not recognizing valid ranges.

    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...
  2. W

    time calculation first time last time

    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...
  3. T

    Create list based on user selection from multiple drop down boxes

    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...
  4. A

    Reactivating last active workbook: need help!

    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...
  5. P

    Delete second duplicate rows

    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...
  6. U

    Converting sheet formular which incudes operators into VBA .formula

    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)...
  7. S

    Copy and paste values only - Help Please

    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...
  8. A

    VBA to write a formula into a range of cells, but the formula needs a ">"

    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...
  9. L

    Using Countifs formula with And/Or operator (?)

    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...
  10. S

    Autofilter equal to and between two values

    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...
  11. B

    Operators in Array Formulas

    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 =...
  12. F

    INDIRECT formula construction

    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;"...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back