1. D

    How to copy over only new rows

    I have a report which I have to update from time to time. The combination (Concat) of the values from two columns is unique, so I have a "code" which identifies the row. So, for the example: Sheet 1 has 1000 rows, Sheet 2 has 1200 (The previous 1000 are included in this) I want to copy over to...
  2. N

    Subtracting if drop down box says "Yes"

    Hi all, I would like some help with an excel spreadsheet I am creating to keep track of my overtime at work. As seen in the attached file, Column D is the overtime that I worked on that day. Column E is a dropdown box (Yes,No) which identifies if I have used those overtime hours (Eg. On X...
  3. J

    Calculate Number of Days Overdue using either column, with one taking precedence over the other.

    Hello, my 2nd post here and I'm pulling hair on another stuck Excel sheet. I've got an Excel sheet prepared however just couldn't upload it here. Actually just one question however with several conditions so I'm putting them into bullet points numbered below: 1. For each document, how do I...
  4. D

    Converting data extract to individual line items

    Hi, I'm trying to build a macro with the following data... What I want to do is to transform the above into this: Basically, what I'm trying to accomplish is to take the data set and transform it into individual line items. Account numbers, names, and risk types repeat, but LOB and Net...
  5. K

    How to show selected menu in slicer to other cell ??? (Like a Refrence Indication)

    @ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference
  6. A

    Separating a part of the string from it's three first characters

    I am trying to separate a string from it's three initial characters. Example: 100345-123-2455 100 345-123-2455 345-123-544444 345 123-544444 I have figured out, with help, how to separate the three characters, using the function...
  7. A

    Taking first 3 characters from a cell A1 and comparing it to a range. If there's a match, the three characters from A1 go to B1.

    I am trying to compare the first three characters in A1 with a range from C1 to C100. If there is a match, the first three characters would copy to B1.
  8. M

    Resize Every Table Of my Powerpoint Document

    Guys I really need some help. I have tons of tables in a powerpoint document. Some are 2 in x 2 in and some are 3.5 x 3.5 in. I need to resize only the 3.5x3.5 tables to a size of 2.8x2.8 I know this can be done with some easy vba code, but I don't possess the knowledge for it. I know it has to...
  9. J

    Calculate cells edited in last 7 days

    Hello, To give a bit of background: I'm one of the editors on a website currently hiring writers. We're creating a spreadsheet to track the content the writers create and when they created it. I want to create a count for the number of blog posts they've written in the last 7 days, if that's...
  10. D

    Measure variance over week period

    Im having a lot of trouble working with this formula, what im trying to get is, if the week number is even, then get the difference compared with two weeks ago (current- twoweek), else (current 53-previous 52), the thing is with other measures works perfect, but with this particular measure is...
  11. A

    Insert Row based on Cell contents and copy data from Row above and paste data from another tab

    Bit of a complicated one here, i will try to explain best as i can Main Sheet Day Route Reference Shift Start Depot Name Customer ID Customer Name Customer Address Postcode Arrival Time Depart Time Product Name Call Type Order Details 1 Tue 100/011 08:19 PPARK DEPOT 08:51 09:21 C...
  12. D

    Macro inserts column in wrong place

    Hello, I usually code macro's in Excel but I need the process automated. I tried to record a macro but for some reason it goes horribly wrong. This is what I want it to do (and what I recorded): - Insert a column in a table - Do a VLOOKUP - Do this for all remaining rows When I recorded the...
  13. C

    Beginner Question - Sheets I'm editing become inactive until I click another sheet or workbook (Intermittent)

    Hi there, everyone! I just registered to the forum to ask about something that has been mildly inconvenient for a few months now. I'm a bit of a beginner, but I've committed to getting better at using Excel going forward (including starting a training course). So, here's what I've got: I...
  14. S

    Lookup query

    Hi. In Sheet0 I have columns A to O populated with travel data. E contains email address I contains departure date L contains country B has the formula =IF(COUNTIFS(TA!C:C,E2,TA!E:E,"*"&L2&"*",TA!D:D,"<="&I2+7,TA!D:D,">="&I2-7)>0,"yes","no") which looks to see if there is a corresponding value...
  15. D

    Inserting table column name into excel formula

    I got a question answered and then I posted another question in the same thread. I forgot I needed to post new questions in new threads. I get an error with trying to insert the following formula into a cell in vba. .Range("M11").Formula = "=IF([@[Wait Time/Hrs]]<3,3,[@[Wait Time/Hrs]])" The...
  16. M

    ComboBox List Selection Issue

    Hi I have a very annoying issue that i can;t get my head around, I have a ComboBox change event that refreshes a list as its typed and reduces the options in the drop down list. Works fine BUT Once I have selected a item from the list, running any other code/macros elsewhere in the document...
  17. T

    Posting Screen Prints to Questions

    I have a basic question that I haven't figured out. How do I post (paste) a screen print to a message I am posting? I see the Insert Image icon in the ribbon, but when selected it prompts for a URL. How do I post a picture stored locally on my computer to the question I am posting? Thank you...
  18. V

    Apply Formula to Entire Column that Already has Data

    Hi all, I have a spreadsheet with a column containing URL's. I'd like to apply a formula to the entire column so that, if a URL has a question mark, delete the question mark and everything right of it. I found this formula: =LEFT(A1, FIND("?", A1&"?")-1) Probably a basic question but, how...
  19. F

    Corrupt/Damaged File Won't Open

    One of my regular (almost daily) excel (.xls) files will not open today. I get this message: "Sorry, we couldn't find D:\Daves Data\....blah.xls. Is it possible it was moved, renamed or deleted? When I ran CHKDSK the result for the file in question says that "first allocation unit is not valid...
  20. M

    Advice on putting values in table

    Hiya I have a table where I have a simple sumif formula to calculate for each week Each week when I run an update, I need to paste the week I’m running as values so the table will have inconsistent table formula my question is that can I do that so the table formula can have cells in between...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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