pending

  1. J

    VBA If value exists in column R get data from subsequent columns and rows

    Hi All, I'm having some difficulty building some reports, I have a main database where users are submitting information from a userform to the next empty row on a sheet, what I'd like to do is if a user clicks the button that it finds all values with "Pending" in Column R and get all other...
  2. B

    VBA Question - Search Multiple Sheets & Put Data in Summary Sheets

    I've been searching this for days and I've actually found a code that works for one sheet. I'm an amateur at Excel and a complete newbie at Visual...any help is greatly appreciated! I have a workbook that has several tabs/worksheets for months (as well as a few for customers, etc) It's...
  3. D

    Multiple IF Formulas

    Hello guys, need your help i have the below table <tbody> 1 A B C D 2 Qty Received Missing Completed 3 50 10 =A3-B3 </tbody> i need to create a formula in D3 that will do the following: IF C3 is empty D3 is empty IF C3 is lower then A2 = Pending IF C3 is equil to B3 = Completed...
  4. J

    Open Ticket Age - Week Calculation

    Hello Experts, I need help for creating an Open aging incident report. I’m part of Service desk and my team lead has assigned me this task. I have pulled raw_data of incidents from ServiceNow a ticketing tool that we use. Below is how the raw data looks. Raw data generated on 4-Aug-2017...
  5. H

    Formula for automatically adjusting running total where change can be plus or minus values

    Hi I have a spreadsheet with each column representing a day of the month starting with the 28th which is payday. Down the left are all the income and outgoing that are predictable and repeating. In row 46 I have my Predicted balance ie what it would be if the income and expenditure occurred...

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