roy

  1. I

    If statement with a between date condition

    Hi Guys I have the below data <tbody> A B C 1 MANAGER DATE STATUS 2 Roy 01/01/2019 Open 3 Roy 01/02/2019 Won 4 Roy 20/02/2019 Open 5 Roy 01/01/2019 Won 6 Roy 01/01/2019 Open 7 Roy 11/02/2019 Lost 8 Roy 01/01/2019 Lost 9 Roy 01/01/2019 Other 10 Roy 01/01/2019 Lost 11...
  2. I

    Count if /Count ifs help

    Hi Guys I have the below data , i am trying to do a formula that would count the number of "open" status the Manager "roy" has. i tried a countifs but could get it right can any one provide any help? <tbody> A B C D 1 name manager id status 2 james roy 1 open 3 jack roy 1 closed 4...
  3. D

    VBA code to merge rows

    Hello, I am trying to merge cells in rows based on the value of the cell in Column A of my spreadsheet (containing Document Type) through the continuous rows containing no Document Type in Column A [see below BEFORE and AFTER examples below]. This needs to loop through the entire spreadsheet...
  4. L

    Sum Rest of Year Formula based on Month

    I need to a ROY sum based on a month number input criteria. I set up my YTD already: =SUM(A2:INDEX(A2:L2,7)) with 7 meaning July. However I then need another formula to calculate August-December ROY. My YTD formula is counting down from the top, its almost like I need to count up from the...

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
Back
Top