common

All- My goal is to get code that will send common filtered data to its own tab within the same workbook while keeping the formatting the same in all tabs: The common data within the column to have its own tab is all the items in column "G" The title row is A1:T1 and is to be formatted the same...

Hello, I'm looking for a way (excel formula) to compare two text strings and return what's in common between the two. All the information is in one column so i will apply the formula in the column next to it and copy the formula down to the other rows. <colgroup><col width="237"...

Hi All, I'm using Excel 2016 and need some help highlighting. I've added a link to a picture of the worksheet I'm working on. https://drive.google.com/open?id=121zcWYWY9W_6wqLiTiJaQCNdnAT2Jl2s I want to highlight all rows that have the word "Complete" in column J I've tried using conditional...

Hello everyone, Need assistance on syntax to write a common value to different text boxes. My Userform has 25 text boxes, renamed "TB1", "TB2,...,"TB25". Each box has an extra box on the side where users will be entering serial numbers. The macro process fills a varying number of "TB" boxes...

Dear all, SOS please... I am trying to get the most common WORD from my "sold Fish" list but since sometimes I have blank cells the formula keeps giving me n/a Can anyone help me a provide me with a proper formula? <tbody> cod cod cod monkfish cod cod #n/a </tbody>

Hoping someone can help, I'm pretty sure there must be an easy way to do this! I've got 2 sheets with a crossover in data I need to consolidate: sheet 1 has 2000 contacts, email and order ID's sheet 2 has 5000 contacts (original 2000 contained within the 5k) and email (no order ID's) I want to...

Hi guys, I need to calculate the common area between 2 products I have multiple of product that are made on series ofequipment. Each equipment has a surface area. I need to calculate the shared area between 2 selected products. Some products may have more than more than one surface area...

Can any help me correct the below program Sub Serpentine() Dim N As Long, i As Long, j As Long Dim sh5 As Worksheet K = 1 Set sh5 = Sheets("Common") N = sh5.Cells(Rows.Count, "A").End(xlUp).Row For i = 1 To N For j = 1 To Columns.Count If...

Good Afternoon All, This might seem easy to some, I just cant figure it out and I am not sure what keywords to enter if this was answered already. I am the manager of an appliance retail store and I have a lot of new employees who are making simple errors. I was hoping there was a function I...

All- My goal is to get code that will send common filtered data to its own tab within the same workbook while keeping the formatting the same in all worksheets: The common data within the column to have its own tab is all the items in column "W" The title row is A1:Y1 and is to be formatted...

I have a List where users will be inputting the province they are from where each province has a different rate associated to it. What I am trying to do as of now, I need my customers to manually input the Provinces twice. Once in a Column on one page, and another time on another. I'd like to...

Hi everyone, I am finding myself in this problem I can't solve. I have 150 sets, each of which has multiple element inside i.e. Set A -1 -2 -3 -4 Set B -1 -3 -10 -20 etc. Now, I would like to create a matrix with the sets in rows and colum and for each intersecation I woudl like to count...

I have a list of numbers and I want to get the common prefix between them. I've been able to make this array formula that gives me correct output but comparing only 2 numbers (stored as text). A1=23702000000 B1=23702999999...

Hi all as i want to ignore the word "undelivered" when searching for the most common word what i have is - =MODE(IF(A6:A1000<>unknown,A6:A1000)) (array formula) it says #Name as a result TIA

I’ve created a template file for us to use that we copy & paste a CSV for every job. Most of it is locked (per boss’ request). In this template file I have a table that looks at the most common lengths in one column of the CSV. The formula’s you guys gave work great, but there’s a snag that I...

Array 1 = {"DX";"DZ";"WX";"TX";0;0;0;0;0} Array 2 = {"BX";"CX";"DS";"EX";"FX";"HX";"IX";"KX";"LK";"N";"NX";"OP";"SK";"SX";"TX";"WX";"ZX";0;0;0} How do I make an array that combines elements common to both arrays that aren't 0? I'd expect {"WX";"TX"} as a result.

Hi I found this earlier post about finding the most common combinations of 3 in a worksheet: https://www.mrexcel.com/forum/excel-questions/898307-find-most-common-combination-3-a.html I have a similar problem, but instead of 6 coloums and combinations of 3, I have 20 coloums and want to find...

I have a 'Summary' Excel file that is to read information from numerous other workbooks. These other workbooks are all set up identical. They are basically forms filled out by each employee (Name, address, education, experience, etc.) and saved in the same common folder. The 'Summary' file...

Not sure if this is possible..... I have a column of data between P2:P100, each cell has various words in it, each on it's own line. I'm trying to find the most common value in that column but only if the cell in column B = "Destination". I thought perhaps a MAXIF but I have no idea where to...

I have two worksheets that contain a common number along with accompanying data rows on each sheet, what I would like to accomplish is matching those common numbers from both sheets and bringing each set of accompanying data and merge it into one row. I am sure I will need to write a macro for...