closed

  1. F

    IF, AND, OR conditions in the same formula

    Column A = "Status". Values: Unassigned, In Progress, Rejected, Not Proceeding and Complete Column B = "Date Closed". Values: Date I need a statement where I get a 1 value when all the following conditions are met: 1. Date Closed is not blank AND 2. Status = "In Progress" OR "Unassigned"
  2. K

    Stop aging when status changes

    Hi! I am seeking for a help on how to stop aging when status changes Assumption: A32 - DATE ACQUIRED G32 - AGING (# of days) I32 - STATUS (with drop down: Successfully Closed On Hold Inactive...
  3. B

    Conditional Formatting on Row using Count function

    Hello my fellow colleagues, I for the life of me cannot figure out how how to get this done. I have a Row where the cells in column A will contain Words such as Open, In Transit, Received, Scheduled, Delivered, Closed. That row will stretch with columns from A - W. When the Word Closed...
  4. G

    Finding "CL" or "CLOSED" in one clumn and changing to 99% in Another

    For i = 9 To LastRow If UCase(Cells(i, "F")) <> "CL" Or UCase(Cells(i, "F")) <> "CLOSED" _ And Cells(i, "B").Value = 100 Then Cells(i, "B").Value = 99 _ And Cells(i, "E").Formula = "=(E-.3)" End If Next i Hello All... I have a little problem here. What I'm trying to accomplish, is for the...
  5. Jaafar Tribak

    Workbook BeforeClose Cancel button

    Hi dear members, Let's assume there is a workbook project where an API timer (SetTimer) is started in the workbook open event... This timer is supposed to be running thoughout the life of the workbook until it is closed. In the workbook before_close event, the timer is cancelled by calling the...
  6. SandsB

    % of 2 cells in a pivot table

    I'm doing a pivot table. There are rows for each person on my team. Column B is "Total Tickets", Column C is number of those tickets per person that are closed - field name is "Status". I need column D to show each person's % of closed tickets. I can manually enter =C10/B10, etc but I want...
  7. R

    If / Vlookup statement

    Hi, Ref Excel 2016. I've been trying to use an IF statement to reference the data in column C, which in turn will change the text in column E. So, if column C shows the word "Closed", then the text in column E needs to then display the word "Blue". The difficulty I'm finding in using an IF or...
  8. mayday1

    Pivot table showing a total and a percentage

    I have accounts which have sub accounts and each sub account is a separate row in my data. I need the "closed" percentage of each department in a Pivot Table. ACCOUNT and STATUS are the column headings in my data ACCOUNT, STATUS acct#1, closed acct#1, open acct#1, closed acct#1, open acct#1...
  9. D

    3 posible tabs in closed workbook to place in one tab in curent workbook for search and edit

    I have a rather convoluted question. We are now running Excel 16 (365). I am building from a VBA driven workbook, a new twist. A beginning GUI will provide 3 buttons to represent 3 Tabs(worksheets) in a closed workbook on the network. I want to draw a copy of certain rows from the chosen tab to...
  10. M

    Access to Excel

    How can I tell when an excel file was opened and closed and the session time?
  11. K

    Is there a way of copying data from one worksheet to another automatically?

    Hi Guys. I have a worksheet on which I keep my sales accounts. It looks something like this:- <tbody> A B C D E F G H I J K Name Created Project Type Date for Action Current Action Status Status Changed Value Commission Turnaround Smith 4 April 2018 ******* Retail 4 April 2018 Call Active...
  12. sharky12345

    Get properties from closed file

    Is there a way I can get the BuiltinDocumentProperties of a closed file? The path to the file itself is stored in a Textbox...
  13. K

    SUMIFS to SUMPRODUCT

    Hi, I'm having a problem using the SUMIFS function with ranges from closed workbooks. I have read in internet that the #REF ! problem is caused because this function can't work while the referenced workbook is closed and found that it can be done using the SUMPRODUCT function or with SUM and IF...
  14. A

    Multiple cells contain same TEXT

    [/IMG] Kindly help me, I'm looking for a formula if multiple cells (D54 to D61) contain the same text (Closed) D53 should show as Closed if one of the columns (D54 to 61) has a value other than Closed (Such as pending or in progress) D53 should show "pending"
  15. N

    copy cells based on cell value

    Hello All, Hoping someone can help me, I have tried several codes and searching the internet and I feel my request is not complicated but I cant seem to figure it out. I want a worksheet_change macro that checks column H on my worksheet("Tracker") for values. If column H equals...
  16. B

    Pivot Table Calculation Field (Countif)

    Hi All, I have a pivot table with data, one column captures text (Open, Closed) entries. I want to create a calculated field that will do a count of closed. I know I could just drop the field into Column as well as rows to filter this way but my pivot tables contains a number of other columns...
  17. George J

    Closed workbook is not nothing

    I have a workbook that creates another workbook on opening using Set Freshwkbk = Workbooks.Add I have this as a Public Variable. If I close the Freshwkbk workbook, when code is run on the original workbook I am unable to tell that the Freshwkbk has been closed. If I put ?Freshwkbk is nothing...
  18. H

    Hiding a row based on a drop down menu value

    Hello, I am new to the thread and relatively new to Excel. I have a job log spreadsheet and I have created a drop down menu to indicate whether the job is open or closed. As we have a fair amount of jobs, once the closed option has been selected I want to hide that row. I have researched it...
  19. T

    counting days and stopping

    i have two cells A1 can be selected for open or closed A2 is the days counter that counts how many days an item is open i want to be able to select close and make the days counter stop so that i can see once its closed how many days that item was open for before we closed it. is that...

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