1. S

    How to add a condition to a macro If the name does not exist, continue to Next.

    I have a Macro that converts the table back to Range. The problem occurs if there is no table name in Sheet3. I need the macro to skip this step then and continue Sub ConvertTableToRange5() Dim rList As Range Dim ws As Worksheet ' Source - delete table Name...
  2. M

    subtract a existing values with condition Final Cell-First Cell

    Hi, Required a formula help to subtract a values existing final cell value F3 & F4 with final cell C3 & C4 values like (F3-C3=Value & F4-C4=value). Condition here is C3 and C4 values are always same do not have any changes are moving forward but in final cell value F3 and F4 it is not fixed...
  3. M

    Need Help with Match/IF/ISNUMBER problem.

    I have a problem I'm trying to solve. hopefully I explain this right. I'm trying do find a formula to insert 3 missing columns of data from another data set that has those columns. the data with the missing columns has over 600 rows. and duplicate values.. the data that has the columns i need...
  4. W

    Removing Duplicates based on some criteria

    I have sheet with some data where B column has some ID's out of which few are duplicates. This data is from 3 sources which are S1, S2, S3. data source is present in "F" column. Can someone help me with a VBA code that finds the duplicates from column "B" and then out of the dupicates find if...
  5. P

    need cells combination of cells that will follow 2 conditions rules

    0 i have 10 cars that need to fit in a car transporter truck. I have a limit on the length of the truck, which can take 5 cars in upper level and the rest 5 in ground level. i need a formula that will take the 10 car lengths and give me all possible 5 car combinations that dont exceed the truck...
  6. M

    lookup with Condition of Allowable=Incurred values return a zero for particular Item ref Code.

    Hi, I required a help in formula where as a item code AI2 (Cell no 4 & 5)does not have any allowable rate , but in that item code has incurred value for Operatives and Equipment (Highlighted Cells). In this case i required a formula for AI2 should return as a Allowable value = Incurred value...
  7. F

    Check Multiple Columns For Condition And Duplicate Rows

    Hi All, I am very new to Power BI and need help in following... I am running a query based on answer in this thread to copy rows based on a condition... let CN = [#"Column4"] in if Text.Length(CN)=11 and Value.Is(Text.Start(CN,4),type text) and...
  8. K

    # Condition is - How to highlight Cell Value via other cell "TRUE" OR "FALSE" value (if "K1" = FALSE after change cell color to Red) (No VBA)

    @ How to change "H2" cell color change After "FALSE" ????????????????????????????????????????????????????????????????????????????????????? (No VBA only for condition formatting)
  9. R

    Command button to send/display email to corresponding email address if condition is met

    Hello VBA experts, I have a spreadsheet that I would like to add a command button to that would populate an email to the corresponding email address, but only if a condition is met (an upcoming due date). I have tried several versions of code, but none have worked so far and I'm also a beginner...
  10. I

    Looping vba code until all relevant data ends?

    Hello. I have this VBA code that identifies route codes in one sheet in a workbook (pickorder). Then in another workbook (CX) it identifies those same route codes and gets the value (times) in 1 row below and pastes it into column A in the first workbook (pickorder). The code works really well...
  11. V

    Unique ID between two date ranges

    Hello, Would like assistance to run a query in Access for the table below, where the ID is a text format. Date ID Value 4/15/2020 ABA 2.00 4/15/2020 NHB 1.00 4/19/2020 BBB 0.222 4/20/2020 RRRf 1.55 5/1/2020 NNN 9.55 5/2/2020 JUY 2.22 5/2/2020 YYY 2.22...
  12. M

    Vlook up between two workbook and display message

    Workbook A,sheet 1 Supplier Amount Owner status Date AVT 500 John 4/22/2020 ABC 1000 Peter 4/21/2020 NAC 600 John 4/22/2020 BAT 10001 Andrea 4/23/2020 Workbook B, sheet 1 Condition should match Supplier, Amount, Date, If all matches in sheet 1 of workbook B with Workbook A...
  13. Z

    Macro to adjust line break in a text box

    Hi, I have below macro, what it does: It count the characters of concerned text and then add a line break whenever the text exceeds the text box size, then add this sentence "[more detail available in System]" in the last line of the text box. What I'm facing right now is: the text in text box...
  14. M

    Concaténer des cellules avec une condition

    Good morning all, I wanted to concatenate colors (in range B) with respect to each value which is in row A. (see image) . The result is in Range C. I used concatenation with condition like this: = IF (A2 <> 0; CONCATENATE (B2; ","; B3; ","; B4; ","; B5; ","; B6); "" ) because sometimes there...
  15. S

    Referencing a big number of ToggleButtons

    I have a table which has a ToggleButton next to each line. I would like to write a script that does something for each line of the table, but only if the ToggleButton on that line is pressed. Is there a way to define the if condition in an elegant way? I would imagine something like: For i =...
  16. S

    Sum only up to a certain point, then reset

    I have a list of staff with the hours they have worked on a weekly basis. I want to be able to put in a week's column when a payment has been made (this can be done sporadically and so isn't every week). When I put this in a column I then need a row below to reset for the following week to only...
  17. C

    IF statement issues

    I need to adjust the below to say if what is in orange is >=12 then return a value of "monthly"...right now it works how it is and brings back a value of 12, instead of 12 i'd like it to say monthly. I have tried adding another if statement but i keep getting 0 or errors. It's probably something...
  18. S

    Text Limt in a cell

    Hey, I have a query regarding the text limit on a cell. I have a cell that contains more than 100 characters. I have given the reference of that cell to other sheets now what I want is that on the sheet the cell will only have 100 characters the rest will move to the next cell. Exp. A cell has...
  19. G

    VBA - Delete all rows except rows which contain certain text

    Hi All, I have a excel workbook with 2 worksheets. Worksheet A has a very badly formatted data dump from our timesheet tool. Worksheet B has a list of project names. I am looking for a vba code which when run will delete all rows in Worksheet A expect for rows which have dates in them and rows...
  20. G

    VBA Copy data to another work book based on CONDITIONS

    Hi Team, I would like to copy data from one work book to another. The data has to be copied from BookA to BookB. However, the issue is that I am not allowed to edit the vba in BookB. Book A has a list of names and their forecasts. Book B also has a list of names and forecast but it also has a...

Watch MrExcel Video

This Week's Hot Topics

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