1. P

    Lookup and Find

    I feel like I should know this but am drawing a blank. I have a table of 3 columns and 10 rows and two values to locate. In column 1, I want to find the number 29850 and I want to locate in column 2 the term "report" and return the value in column 10. So an idea is as below: <tbody> Sequence...
  2. H

    VBA - User Form show at start of macro & hide at the end

    Hi, I have a user form(UserForm1) which I want to show at the start of the maro & hide at the end i.e. when the macro/code is completed. The purpose for this is that some codes do take few seconds to complete so I would want a user form (stating some text like the macro is ruuning - pls wait...
  3. A

    Formula to Return Training Status with Multiple Outputs

    I a table with 6 different input scenarios and need to return 4 different outputs depending on the input. The table data is all dates and I would like to fill the Status column with one of the following outputs. No-Value Complete On-Time Past-Due An example of the scenarios in the table...
  4. V

    Conditional formatting colour scales on different cell

    Hi, I have used colour scale to format the % complete cell but I need the format to be the same in column a so I can hide column b. Is there an easy way of doing this I want to keep the colour scale? Thanks <tbody> <colgroup><col><col></colgroup><tbody> Status percent complete Complete 100%...
  5. F

    Complete web data from Excel

    Hello All. I need to complete a price of different articles on a website and they give me the data in Excel. I explain: Every week they send me an Excel with different article prices and I have to update those on the web. The Excel are two columns, one with the ID field and the other with...
  6. V

    Date formula with multiple conditions and nested ifs

    Hi, I need a formula that tells me 4 options based on a date in C3: Overdue= the date has passed Approaching= date is 5 days away Pending= normal status Complete: if A1 is = Yes then Complete What I currently have is this : =If(TODAY()-C3<=5, "Aproaching","Pending") I'd be really grateful...
  7. TAPS_MikeDion

    # of labels limitation?

    Is there a maximum number of labels you can use on a form? Suddenly I cannot put any more labels on my form. I'm at around 35. Every time I either try to copy and paste a label or create one from scratch from the Toolbox I get the following errors: From the Toolbox: "Could not complete the...
  8. H

    Increase OR Decrease the complete value

    Column B is updated with RTD Output required in Column C as: If 3rd decimal place >=5, then INCREASE the 2nd decimal place by 1 value & COMPLETE VALUE to nearest .05 multiple ELSE DECREASE the 2nd decimal place by 1 value & COMPLETE VALUE to nearest .05 multiple Thanx in adv I am using...
  9. T

    Macro to apply formula to a range of cell

    Hi, I have written a macro to apply a formula to a range of cell the following is working just fine 'Worksheets("TRANSPORT").Range("N15:N34").Formula = "=MIN(K15,MAX(D15*I15,J15))*INDEX(ROE,MATCH(G15,DEVISE,0),3) but this formula is not the complete version that does not work Here the...
  10. J

    Toggle Button 3 options

    I need a macro to assign to an object button (Shape) when pressed it will toggle a specific cell value to change between PLANNED, IN-BUILD and COMPLETE. I have this code but it only gives me two options Any Help would be appreciated. Regards Jason Bing Private Sub CommandButton1_Click() With...
  11. L

    Shape macro

    Hi all, I am after a macro that when a button is clicked it changes the colour of a shape to say if the statement is complete, working towards or incomplete. I then need a cell to be linked to the cell so that if it is complete the cell shows 3, working towards 2, incomplete 1. I have a macro...
  12. S

    Selecting one Cell highlights all others with the same data

    Morning all I have a worksheet that contains a list of courses for 2 of my departments, Column C pertain to courses "Department A" have completed and Column G pertain to courses "Department B" have complete. There are over 450 courses detailed in each of these columns, with multiple courses of...
  13. D

    Filter data on multiple criteria

    I need help filtering on multiple criteria. Consider the sample data below that provides a greatly simplified data set. I need to show all data for the current date and any data from previous dates with a status of "Complete Pending Verification. I am not sure if it will matter, this table...
  14. S

    Userform Listbox Refresh

    HI Not a programmer but hopefully doing a good job of finding and playing around with code to get what I want. I've created a spreadsheet that has raw data on a worksheet. I have one macro that scans through the data and the last column (J:J) is changed to REVIEW DUE, FOLLOW-UP or COMPLETE if...
  15. S

    Schedule forecasting to maximize throughput

    I am trying to setup an automated scheduling spreadsheet in Excel but have hit a road block. The actual problem I'm working on is quite complex so as an example imagine a new delivery business (Acme Shipping) that is purchasing trucks and starting delivery routes. As Acme wants to maximize the...
  16. M

    Automatically move a row to another sheet based on cell value

    Hi there. Complete VBA and Macro novice here and I have trawled the internet trying to find a solution. I have a basic spreadsheet with 2 sheets, titled 'Active' and 'Complete'. In Sheet 1 (Active) I have data in columns A - I. Column I shows a status as either Active or Complete. I want...
  17. E

    Extract Data to Email Body (from a VBA newbie)

    Hi all, I have a form that staff complete. Cells A1:B6 contains information. I need VBA writing to complete the following: Send to designated email address Subject line to be B1 and B2 (example "Mr Smith 12 May 2019") Copy information from A1:B6 into the body of the email The user should...
  18. D

    formula to enter a % based on a word that appears in a cell

    Hi all I can't even begin to determine how to approach what I would like to happen. Can I use a formula or should I use code? I have an Inv # in col "A" and a Description in col "I". I also have a table ("wordpercent") on a sheet "Info" with a list of words - Col "N" and a corresponding % -...
  19. L

    Calculating the average handling time to complete a task

    Hi, I'm stuck with a particular kind of formula in excel. I'm looking to calculate the average amount of days it takes for a transaction to be completed for each month. I have a sheet listing when all the expressions of interest and the date/time that this occurred and another listing when the...
  20. P

    Distinct Count Formula

    Hi All, Is there a formula to find distinct count in a column without using COUNIF function. Currently I'm using the below formula, but it takes more time to complete 9000 rows of data i have. Can someone assist me on this pls. IFERROR(1/COUNTIFS(A:A,A2),"")

Some videos you may like

This Week's Hot Topics

  • Use Filter function with 2 criteria to return a specific value
    I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
  • Loop stopping at row 10
    Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
  • Numerical Order Code for Macro
    I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
  • Calculate time in excel
    I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
  • VBA
    Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
  • Help with formula to sum numbers prior to date
    Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

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