status

  1. FracinDean

    General Questions: Member Status and Board Funding

    Hello members. This is an awesome board. I have two questions that I haven't been able to find answers to within the existing threads, FAQs, etc. They may be there -- but I couldn't find them. 1. What determines a members status ("New", "Board Regular", "Mr. Excel MVP", etc.)? 2. How is...
  2. K

    Updated Data Shows In Excel After Some Inconsistant

    Hi, I am updating data in a table in sql server from excel, and after updating the data I am fetching the updated data in excel, and when I fetch the updated data sometime updated record show and some time after 2 or 3 click on refresh button then the updated data shows, I don't know what I am...
  3. C

    Counting Records by Status but NOT printing all records

    All records in my mdb are assigned 1 of 3 statuses: Pending, Active or Closed. In the header of one of my main reports, I have 3 unbound textboxes to display the count of records for each status. For example, =Sum(IIf([RecruitmentStatus]="Closed",1,0)) and so on. Here's what I am trying to...
  4. R

    Need match of two different values

    I have a list of customers each with a unique ID number Each customer can show up multiple times on a very large report. The customer ID stays consistent throughout and does not change. Each Customer can have a status of Ordered or Ordering or None Using the customer number I need to know which...
  5. U

    VBA Group Row Based on Cell Critieria

    Hello Guys, I have below data that I need to group based on criteria below: Raw (Sheet1): <tbody> ID Name Status 01 Donna Done 05 Karl Complete 06 Ems Pending 02 Shawn Incomplete 05 Mae 03 Ann OK </tbody> End Result: <tbody> ID Name Status 01 Donna Done 03 Ann OK 05...
  6. O

    Why does my Status Bar stop updating.

    I'm running a simulation with over 500,000 iterations. I've got screenupdating turned on on, statusBar display is on, and I've activated the status bar to print on the iteration number, but it prints out 6000+ and then stops. Could it be that the software is running faster than the screen can...
  7. J

    Formula to rank invoices based on status and date

    HELLO, I ALREADY HAD SPEND TO MUCH TIME TRYING TO FIND THIS FORMULA FOR MY OWN, SO I DECIDED TO ELEVATE THIS TO THE EXPERTS. IM LOOKING FOR A FORMULA TO RANK INVOICES BASED ON STATUS AND DATE. <tbody> STATUS DATE RANK (must Be) RANK FORMULA PAID 31-JAN-2019 6 PAST DUE 28-FEB-2019 1...
  8. D

    Save Embedded Documents

    Hello, Please help me, any one has idea on how to manage saving embedded files(PDF,Word,excel) in excel or word into a folder. I have below codes but it not saving the embedded files. Thanks Sub ExtractEmbeddedObjects()' The following macro extracts the embedded objects from all docx & docm...
  9. S

    Multiple formulae in one cell (vague title, sorry)

    I have to create a work plan spreadsheet that tracks tasks, which have steps. <tbody> Task X Status Step 1 1. Status 1 Step 2 2. Status 2 Step 3 3. Status 3 Step 4 4. Status 4 Step 5 5. Status 5 Step 6 6. Status 6 </tbody> As each staff member completes the step, they will...
  10. 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...
  11. V

    Based on the status, copy-paste entire row on another sheet

    Dear Team, I have one sheet where col H contains "open" or "close" status. What i'm trying in vba is wherever status is "open" in col H, all that records paste in "Sheet1". Can anyone pls help on this vba code.. Thanks in advance..
  12. E

    Percentile.Inc (Quintile) Function with IF conditional statement

    Hi, I'm trying to calculate from a dataset a =Percentile.Inc function with a condition. For example, I want the 20th, 40th, 80th percentiles from the dataset for ONLY "Active" status in column B, using the values in column A. My formula for 80th percentile is...
  13. S

    Double Click/Filtering on another sheet

    Hi there, I would like to double click on a value within a sheet called Capacity, for it to be filtered out on another sheet, called Status. In Status, I have a table range already done called Details, and the column to be searched from is B4, any ideas? Thanks
  14. E

    Automatically move Rows of Data from one sheet to enough based on a status (Remove)

    Hi All I have a register in excel which gets reviewed every 3 months which has 10's of Thousands of lines. What I would like to be able to do in the status column (AH) is trigger a automation, When the status changes to "Remove"it moves it into a different tab called "Removed" in the same...
  15. C

    Macro to create multiple sheets from master sheet

    Newbie here! First time posting but I've used your forum for many years! Please be patient as I am not very well versed in code writing. I have the following: Master: Cells (a2:a201) are Client # (0001-0200) Cells (b2:b201) are Status ("active" & "inactive") Cells (c2:c201) are Names (Last...
  16. J

    Looking for VBA code OR formula to copy and paste from one sheet to another

    Thank you in advance for any help you all can offer! I’ll judt list out what I need to do below. Sheet 1 (this is my master log/source table) contains a table in which I manually input data Daily under the following headers A B. C. D. E 1 DATE...
  17. G

    Multiple Criteria

    HI, <colgroup><col><col><col></colgroup><tbody> ID STATUS Confirmed Status 3333 Approved 4444 Approved 2222 Approved 3333 Approved 2222 Approved 3333 Approved 1111 Not Approved 4444 Approved 1111 Not Approved 3333 Approved 3333 Approved 3333...
  18. G

    Multiple Criteria

    Hi, <colgroup><col><col><col></colgroup><tbody> ID STATUS Confirmed Status 3333 Approved 4444 Approved 2222 Approved 3333 Approved 2222 Approved 3333 Approved 1111 Not Approved 4444 Approved 1111 Not Approved 3333 Approved 3333 Approved 3333...
  19. 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...
  20. G

    custom ribbon how to access checkbox

    Hi I made a custom tab on the ribbon. There is a way to get the status of the checkbox ? Can i acces the checkbox by it's name ?

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