begin

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)

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!

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

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

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

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

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

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

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 :(

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!

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

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

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

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

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

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

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

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

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

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