begin

  1. B

    vlookup with repeat and length

    Hello, I'm using a vlookup to pull the last four digits of a credit card number, but some of the numbers begin with a zero. here is my current formula =VLOOKUP(G2,Billing!$A:$P,14,FALSE)
  2. B

    Need help with a delete macro

    Hi Everyone, I have a worksheet with close to 1000 rows. I want to delete ALL rows where the VALUE in Column A DOES NOT BEGIN with ZERO with a macro. Any help would be appreciated! Thank you!
  3. C

    Haven't used Mr. Excel for many years now LOST!

    I'm essentially new to Mr. Excel and am trying to post a question about an error I'm getting In what should be a simple line of code. Not sure where to begin -seems I am unable to post net threads in most forums. If you could please let me know where to begin.... Thanks in advance
  4. J

    Unique incremental numbering formula

    I have a spreadsheet that has a tab with sections and within each section there will be tasks added – each task item requires a unique number and must increment to the next available number within a specified number range based on a Work type. The first 2 parts of the number are based on two...
  5. S

    Pivot calculation from one Column to the Next

    Hi all, I can't find the answer to this so hoping someone can tell me how. In a nutshell, I need to use the result from one column (month) as the starting point of the next column's (month's) calculation. As in, a rolling subtotal of activity from one month to the next. I cant find how to...
  6. J

    How to find and sort and copy A through J, K through M, etc. from fixed range

    I am looking for a way using VBA or macro to search a range and find all of the last names that begin with A through J, K through M and so on and copy those names to another range so I can print it out. Thanks
  7. N

    Vlookup mathing

    <tbody> dos id dep? id begin end dept 3/22/2018 1234 1234 4/13/2018 12/31/9999 205 4/6/2018 1234 1234 3/1/2018 4/12/2018 105 4/25/2018 1222 1222 1/31/2018 7/31/2017 106 </tbody> I have the following. I'm trying to get the dept? a member was in on the dos...
  8. S

    Problem with VBA Machine Code vs Binary...Maybe?

    I have a bit of code that is returning dates values inaccurately. The search values that are generating the problem all begin with 2 as in February. Dates that begin with 2 are being found as December dates. Its as if the find function is adding a "1" before the two somehow. Not sure what to...
  9. P

    Count Unique Numerical Values that begin with

    Hi, I'm making a database right now that need a formula for counting unique numerical values that begin with a certain number, because of the amount of duplicates. All the formula I tried doing myself have resulted in errors :(
  10. D

    Macro Statement To Select Cell in a Column that Begin with a Letter

    Just like the title states, I need to select all of the cells in Range("Table1[[#Headers],[PO'#]]") that begin with a letter, there is both numbers and letters in the table and it is sorted "A-Z" already. Thanks in Advance!
  11. N

    Formula Fill to Begin at the False Statement

    Hello All,I am trying to solve the following problem. in Cell D1 I enter this =if($A1=0,B1,B100) When I will fill the Formula down it changes to b2,B101 & b3,c102 ... What I am trying to accomplish is the false fill down to begin when it encounters the first fall situation. Assume cell A5 is the...
  12. C

    Sumifs with dates

    Hi All I am trying to us the sumifs function to total data between two dates. Below I have a begin week and week end date all I am attempting to do is sum an amount from a string of data where the transaction date is equal or greater than the begin week but less than or equal to the week end...
  13. S

    combining 2 excel sheets into 1

    I want to combine my weekly reports into one master file. After I copy paste them into one sheet, I have to go through them manually to match all the rows. There can be 7000 plus rows and it takes all day to manually fix them. What can I do to automate it? V lookup only work on one column. I...
  14. B

    Macro to Find Names that Appear across 8 Columns in same worksheet

    I have a worksheet in my excel workbook that contains a column of names, followed by 5 columns of data for each name, followed by another column of names with 5 proceeding columns of data for each name (and so on until 8 "sets" have been established. I want to be able to run a macro that finds...
  15. T

    INDEX / MATCH Function In VBA Code

    Hi All; First of all, thanks a lot in advance for your time and help. Here is my question; I'm trying to use Excel's Index and Match functions within VBA code to retrieve data from another workbook, based on a criteria in a cell. The formula below works without any problem and brings me the...
  16. P

    Filtering by items that begin with a number

    Good afternoon all, I'm look to automate the filtering of a large Excel database. I want to include in my code a bit that will be able to filter a particular column so that only the items that begin with a number (0-9) in that column are visible. I'm very comfortable with VBA and have been...
  17. C

    VLOOKUP where the the Lookup Value is longer than the value it searches

    Hey Everyone! So here is the thing. We get a report that we have to use and every row contains a 6 digit code and there is random gibberish before and after it and it is never the same. We have a list of these codes with what they mean and I want to create a VLOOKUP macro for it. The problem is...
  18. E

    Time duration calculation

    Any help on this would be MUCH appreciated! What I am trying to accomplish is basically, determining the time duration between a start and end time value relevant to a given Record id and Source entry. The formula would need to identify matching Record ID's, then determine if the Record ID...
  19. J

    Input box VBOKCancel problem

    I'm having an issue with an application.inputbox in a macro. It keeps popping up with a "1" in the user input section when the message box initially appears. Why is this happening? Dim BeginDate As Variant ShowInputBox: BeginDate = Application.InputBox("What is the first day of the next month's...
  20. J

    Remove Cells That Don't Begin with One of A List of Inputs

    Hi all, I'm looking for a macro, that when executed, would remove all cells that don't begin with one of 3 different For example, if I had these cells in column A: AA AB BC CD EA FA And I wanted to remove anything that didn't start with "A" OR "B" OR "C" I would be left with just these...

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