identical

I have a table in columns C - N. There are over 14000 rows of data. I need to have data where, in column K, there is data that is identical in consecutive rows. If I could have it highlighted then great, if I could have it automatically filtered out then even better! If filtering out is possible...

I am not a VBA coder, and have looked at a lot of different potential solutions, but apparently there is no Boolean code solution. I have a workbook with many identical worksheets (the data in each may be different, but the layout is identical) what VBA coding would take data from a cell (of...

I have a spreadsheet with more than 600 columns. Unfortunately several of the headers are identical. I would like to rename these headers so that they become unique. Lets say that part of the headers looks like this: <tbody> a b c d d d d e f f f f </tbody> I would...

Good afternoon all, For more than 3 years I have been happily entering data into an Excel based database and everything works rather well. However, I need a little advice on a problem I have not got a solution for. All data is entered by way of a multi-tabbed userform, I would also like the data...

I am using this formula to sum between dates for a particular code number. The four sheets are identical in structure (with different table dimensions). I was wondering if there is a better option of doing this, as I believe this formula slows down my spreadsheet significantly...

Hi everyone, if it possible id like a macro that does this Compares Sheet("Data1") Column J to Sheet("data2") column D if both columns are identical put then Sheet("Data1") cell M1 = Yes, if not = No can this be done? please help if you can Thanks Tony

Hi all,The code below sorts the figures out in each block of rows then places the position of that figure in the adjacent column,like this where the smallest number is 1 second smallest 2 and so on. CI CJ 1 24 2 26 3 29 4 34 5 35 6 37 <code>Sub rankandSort()...

Good morning everybody. I have a spreadsheet which is made up of six identical, adjacent blocks of data, each of twenty columns or so. The structure of each block of data is identical. Within those six blocks of data, I need to be able to find a value (which can only appear once), and look up...

Hello! These two functions seem identical to me: =IF(D46<$J8,IF(D29=0,IF(D30=0,0,"BOTTLENECK"),D29/($J8-COLUMNS($D49:D49))),0) =IF(D46<$J9,IF(D32=0,IF(D33=0,0,"BOTTLENECK"),D32/($J9-COLUMNS($D50:D50))),0) The input cells are exactly the same, D29=0 and D30=431 with the only difference being...

Is it possible to create a pivot table from 2 different tables when each table has different columns? They both have 4 columns that are identical but table A has 7 columns of data and table B has 6. Both tables have store #, date, market, & franchisee but Table A has item number, sales, cost...

Hi I understand I can replace worksheets(1) with thisworkbook in the code below. I checked both Workbook and Thisworkbook and I found they are not identical 100%. So how can I replace one with another if they are not identical. Is it technically ok to replace one with another or I should put in...

Hi, Can any one help e out, i am trying to create Macro file which can compare two identical excel reports (Workbook) and generate difference report with same layout and formatting. Thanks Satyartha

In the same workbook: I have one worksheet named pc1 , another named pc I want to compare both - if identical (exactly the same) - then exit the sub routine the syntax below is not working - pls help in the correction (I have search the net but couldn't find the right one) inside a sub...

I ran into an issue, that may or may not be resolvable. My client has a "Bill to:" and a "Ship to:" in their raw data. However the address data is always combined on the same line. For example, here is some raw data from the sheet. Bear in mind this is all converted from .txt to .xls, and...

I have 7 columns that contain data. In column A, there can be identical descriptions for each input. In column K, there is a total cost for that row entry. In column N, I have quantities (if applicable) for each entry. I have the sort vba code figured out as such... Sub UnMerge4Sort()...

I'm trying to use a VBA script that will compare two tables and notify the user whether or not they are identical. Specifically, the two tables are identical when they contain the exact same number of rows and data within those rows - the number of columns will not vary. I think I know how I...

Hi, I have two identical workbooks; in one of them the following formula works but in another it returns the #N/A error and I can't figure out why. I appreciate this is probably a difficult one to answer without seeing the files but they conatin sensitive info so I can't share them. I have...

Hello all I'm a basic MS Excel user. I'm having some issues with the below array formula. I have a sheet called 4a where the formula is located. The formula works well in sheet 4a...

Hi folks, I have i list that shows in column A the title and in column B the topic. This list is generated by an external system and unfortunately that system generates a new row in case a title has multiple topics. I want generate list that has no duplicate titles and shows the topics...

Good day, I have data in two columns - first is just date/time data, second is the variable in question. Normally I just set my ChartData (having declared variables earlier) in the following way. But a lot of the data in column two is sequentially identical. So you might get data in column B...