1. P

    Help highlighting rows based on cell contents

    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. I want to highlight all rows that have the word "Complete" in column J I've tried using conditional...
  2. ChuckDrago

    Addressing text boxes in Userforms

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

    Ignoring blank cells while locating common text value

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

    Consolidating 2 sheets with common field

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

    Calculate the common area between 2 products

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

    Unable to run program for Serpentine

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

    What function to find the most common values based off certain criteria?

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

    Sending Filtered Data to its own spreadsheet

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

    Find most common word in a column and Least common word.

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

    Solution to count how many elements many data sets have in common

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

    Array formula to get longest common prefix

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

    ignoring 1 word when looking for the most common word

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

    #VALUE! Error

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

    How do I find common elements in two different arrays<

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

    Most common combinations in a worksheet

    Hi I found this earlier post about finding the most common combinations of 3 in a worksheet: I have a similar problem, but instead of 6 coloums and combinations of 3, I have 20 coloums and want to find...
  16. C

    Link File to Multiple Workbooks

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

    Find the most common value if criteria met

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

    Combining two worksheets

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

    Align data of a group of columns

    <!--[if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings>...
  20. M

    Maintain common data across two or more workbooks

    I have two or more different workbooks / files that have common data which can change on a regular basis. For example names and addresses , contact details- email and phone, group numbers etc. what is the best way to manage this common data across each workbook/ file so that i change the common...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...