common

https://www.mrexcel.com/board/threads/find-the-1st-2nd-3rd-common-text-w-criteria.1146002/ https://www.mrexcel.com/board/threads/top-10-most-common-text.1145758/ I don't think this is possible with just formulas but let's say I have 10 cells, and I want to find the top 5 most common words...

Hi all i want to be able to find the 10 top most common cells. I can find the top most common with this =INDEX($D$3:$D$35,MODE(IF($D$3:$D$35<>"",MATCH($D$3:$D$35,$D$3:$D$35,0)))) Second most common with this...

So Index/Match is a great tool but I'm having a hard time wrapping my brain around this... I want to return a field called "Date" to "Table1" from "Table2" using a common field of "Ticket" but i keep breaking things.. Kind of like a Vlookup but without the first column restriction... Thanks in...

I'm looking to highlight/identify duplicates in a row based on a common title (same) and am not sure of the direction to proceed. Simple example: There are two helpdesk title's and both are part of similar groups. I would like to identify all groups that "helpdesk" have in common. Then...

Hi Community, Been trying to figure this out all morning. I have a range of data, with column headers. I have computed values based on certain criteria in a range of cells Similar to the following: Lets call it clothing items. Mon 400 Tue 300 Wed 6 Thur 7 Fri 50 I...

Hello, I would like to set up a formula so that it returns random rows from the below table. I would need to return the corresponding columns as well, for example if it returns the value in A4 it would need to return the corresponding value in B4, C4 and D4 as well. <tbody> Card Code Rarity...

I am looking for a recommendation on a formula or other option to best complete the following task. I have two data sheets that have different data but have a common identifier between the two, so my ask is to take the common identifier and to essentially merge the data from both sheets onto...

I currently have the following formula to capture the 3rd most common text value from a range. I cant seem to change this in order to capture the 4th most common text value...

I have a table of data that I need to use a start and end date range, then the chart would update for that range. The challenge here is that I'm using Month names and year, i.e. January 2019 so the common offset tutorials aren't working since those use dates and add/subtract methods. How do I...

Hello! im just newbie in excel my question is what formula do I need to get just subjects of all Basic and Common type. My sample dataset; <tbody> Type Subject Basic Subject 1 Basic Subject 3 Common Subject 2 Core Subject 1 Common Subject 3 Core Subject 1 </tbody>...

Hi, I would like to find the top 3 most common numbers within column D using Marco and display the result on the side. Start counting from D6 all the way till the bottom. (There could be 1000+ rows). Thank you. Display the following on the side 1st most common : XX 2nd most common: XX 3rd most...

Hi guys, I was wondering if you could help. I am try to create a formula which would pull the most common letter from a string. For example, cell A1 contains MMMWW, I would like the formula to return M Thanks!

I have been lurking for a while, reading a lot of great questions and answers! I could use some help that is a little above my excel pay grade: I am looking to compare two or more college wrestlers against common opponents. Results are posted in a dual-meet format so: 125 lbs wrestler 1 dec...

Hello everybody, Back again after sooo long I am facing a problem with the weekday function that after a bit of googling I saw that is a common question but I couldn't find an answer. Say in cell A1 there is the date 10-01-2019 which is a Thursday =weekday(A1,1) gives a 5 (correct). Applying...

Hi Any ideas how I can get the second most commonly occurring text value based on an if. The data I have is as follows: <tbody> A B C Class Teacher Subject 10x/Ar1 AOW Art 11x/Ar1 AOW Art 11z/Ar1 AOW Art 7L10/Ar AOW Art 7L3/Ar EBE Art 7L8/Ar EBE Art 10y/Ci1 RAM Citizenship...

Hello, I hope someone out there may assist. I am trying to merge alot of data atm. I have one workbook with extensive data and column headings. I am attempting to merge data from other worksheets where the common denominators are two columns. So basically, I want the main document to accept...

I'm trying to compare two columns of numbers and extract the numbers that are common to both. Cell A2 contains the number of filled cells in column 'A'. Column 'B' has list 2. I can use the following to extract the numbers but it leaves blank cells in the resultant column 'C'...

hi in cell g9 I want to put together the rows of each of the common names together(without helper column)

Hi, I have a list of 60,000 rows of data and in column A i have 23,000 different values. In column J i have multiple different codes, how can i find out what is the most common against different value of coulmn A. So for example i would want the answer for 1 in column A to be Yellow <tbody>...

Hi all - new here but have been searching out answers for a grading program I'm using at school. For this program, we calculate the most common number but also the 2nd most common number. If those are equal, it typically spits out the first number in the sequence - when I'd like it to spit out...