entries

Board, I tried to search function, but it keep telling me there wasn't any results so I am posting here for help. I have two sheets, each has a list of mailing addresses (first name - column A, last night - column B, address - column C, city - column D, state - column E, and zip - column F). I...

Currently, a spreadsheet is filled out on a weekly basis to update ongoing monthly costs (invoices etc). The spreadsheet has 6 tabs, relating to different types of cost. What I want to do, is create a spreadsheet (or copy the data to an existing spreadsheet, either/or) and have all the copied...

I need to add C11701103 between the two dots, between 2016 . . BIL. (there is no space between 2016..bil. <tbody> 31-Aug-2016..BIL </tbody> I have over 5000 entries in the column with different dates. So I need the formula to insert C1171103. Please advise, Thanks

I need to create a macro for deleting entries falling on Weekends. I have a conditional formatting formula that colors the cells falling on Weekends "=WEEKDAY(L2:AP2,2)>5. So, I would need the macro to be able to delete entries from coloumn 3 to 799 if L2:AP2 is a Weekend day. Thank you in...

if column 1 has the names column 2 has the departments (either a or b) remaining column has the hours worked weekly how do you identify those with multiple entries (i.e worked in the 2 departments for a total number of hours overall in a week) ?

Hi, hoping someone can help. Searched everywhere but can't find a solution. I want to be able to count number of entries matching multiple criteria. In example below, I would want to count number of non zero entries in Q1 1718 for Director AB and Manager A (so return a value of 2). Actual...

Hi all, In need of some major help for a report due tonight. The below calculations fill my table with values based on distinct customer numbers (customer numbers are in column A) I created column C, because it counts the number of actual entries (that is, a customer number found in in...

I'm looking for two different counts. First, would like to count number of entries in-between the word Major Task and then a count to exclude the "No" between the word Major Task. Results are in column C & D respectively. Data Range <tbody> A B C D 1 Hdr1 Hdr2 Hdr3 Hdr4...

Thanks to anyone who may be able to help. I have two columns in a worksheet that require alphanumeric entries. The columns in which the alphanumeric data are entered are column A and column B. Would it be possible to write a VBA code that would change the lowercase alpha characters to...

I am wondering how I can go about using VBA to compare new entries in one file to an existing file? I have a ticketing system that I manipulate the raw data to give me a usable file. Rather than take everything from the new file, I just want to copy over the differences (newly added tickets).

Hi all, I'm hoping someone can help me! I'm working with some data where each cell contains multiple entries (which are unique references). Essentially I want to compare A2 and B2 to show how many entries should still be live. I can get a numerical view of this in C2 by using...

Hi All I am trying to create a macro but i am stuck with what i am assuming is a line or 2 of code. I have tried to google this but cant find exactly what i am looking for. I am having a problem where i need to select and copy the data from cell A3 to the last row, in this case to A8...

Hi all I need to copy a list of 100k entries like the one below. =-ad-vehicles. Problem is when i paste, i get #NAME ? in the cell. I know it's doing this because excel thinks this is a formula function but how do i work around this considering that i have to deal with 100K entries?

I have been searching for some way to operate on the 1st 10 number entries in a row. The row may contain blanks or numbers. 10 number entries could be in the 1st 10 cells or it may take 50 or more cells to find the 1st 10 numbers. I want to use the result in a formula, specifically to find...

See picture.. pretty self-explanatory (I hope at least) Columns D & E show the result I am trying to do. So I need to: provide a count all the unique entries, and a count for all the duplicate values too that are listed in column A, display the results somewhere on the same sheet.... then...

Hi there, So I just got an excel doc with several columns. I added a new column, & I need to label each of the entries of the existing columns in my new column. I know I can search for all of the cells with that one specific word (find all), but then I need to add my data (which is the...

Hi I have Multiple Entries of Same Bulk Code in Excel Sheet I'm looking for VBA Code with the following Condition If one entry of bulk code contains Intermediate against it in Material Type, for all entries where that bulk code appears, display bulk received as YES(See Screenshot)...

Hello all, I have an odd inquiry. I have a spreadsheet that contains cells that have multiple data points in them. Most of them look like this 120+120+60+50. This gives me a great total, but I am wondering if there is a way to find out how many entries there are in each cell. For instance...

Hi, I'm new to macro and trying to create a macro which copy the adjacent cells values of an item and paste the values to other sheet. Ex. In a Worksheet A, I have values in Column A-D. Column D has all month entries and Column C has sales data associated with those months. There is multiple...

in columnA I have a name and in columnB I have a value there would be multiple entries for the same name but different values in columnB i need to get rid of the duplicate entry but the values in columnB to be added together thinkng im gonna need to run a loop in vba