How to count the repeated word as one in serial number using Excel?  For example:  Below are subject code  BC02551 BC02551 BC02551 BC02552 BC02552 TQ22 TQ123 TQ123   Now I want to count the code which are similar as one. Like below:  Sr. No.    1       BC02551           BC02551           BC02551   2       BC02552           BC02552   3       TQ22   4       TQ123           TQ123
65725
I have a list of items that looks like this:  A B C A A B D E A   Now I want to count the number of occurrences of each item. The result should look like this:  A 4 B 2 C 1 D 1 E 1   How can I do that? It is important to note that this should be flexible. That means if I add item F to the list, that item should also be considered in the result.
95680
How many bit string of lenght 28   having at least one consecutive 000? without consecutive 000?   I'm using ti nspire, can i do it with nCr function.  I tried to do it but i did not found a way.  thank you.  i saw this post :    and this one :   but it did not help me.
26980
Suppose I have a table with a numeric column (lets call it "score").  I'd like to generate a table of counts, that shows how many times scores appeared in each range.  For example:   score range  | number of occurrences -------------------------------------    0-9       |        11   10-19      |        14   20-29      |         3    ...       |       ...   In this example there were 11 rows with scores in the range of 0 to 9, 14 rows with scores in the range of 10 to 19, and 3 rows with scores in the range 20-29.  Is there an easy way to set this up?  What do you recommend?
82806
I'm writing a paper where I have a lot of acronyms. Some are mentioned all the time whereas others only a few. I read that it is possible to create a new glossary and to place all the acronyms that I don't want to show in that list.  I was wondering, though, if there is a way to automate the addition or exclusion of acronyms to the list that is shown based on how often they're used. For example let's say I define  \newacronym{am}{AM}{Additive Manufacturing} \newacronym{osrx}{OSIRIS-REx}{Origins, Spectral Interpretation, Resource Identification, Security, Regolith Explorer}   and two lists, shown_acronyms and hidden_acronyms. In my text I use \gls{am} 10 times whereas \gls{osrx} only twice. Is there a way to make Latex check how many times each one is used and add them to the appropriate list when compiling the document?
110365
I have a file contains around million number of lines. In the lines I have a field called transactionid, which has repetitive values. What I need to do is to count them distinctly.  No matter of how many times a value is repeated, it should be counted only once.
19276
Repeated union is written as: $$\bigcup_{i=0}^na_i$$ Repeated logical conjunction is: $$\bigwedge_{i=0}^na_i$$ Etc.  So why isn't repeated addition: $$\operatorname{\huge+}\limits_{i=0}^n{}^{\Large a_i}$$ Why use Sigma and Pi for sums and products? Everything else is just a bigger version of the symbol.
99462
Ten different letters of alphabet are given, words with $5$ letters are formed from these given letters. Then, what is the number of words which have at least one letter repeated?    Well I do understand some part of the question. The only confusing thing is that if we had chosen different letters of alphabet, how can we form words which have the letters repeated.  For the record, I am new to permutation and combination, so please put the explanation to the most basic level.
116616
I was curious (even though this is a very amateur question)... what would the multiplication equivalent of sigma (the summation symbol) be? $$\sum$$ I want to do a series of multiplication of terms.... instead of addition...
74090
Is there a formula or method to find the number of 6-letter words from the English alphabet if repetition is allowed, but they must appear in alphabetical order?   Type what you know about how many words there'd be if they didn't also need to be in alphabetical order...  Limitless repetition however ordering wasn't specified. I'm so confused as to how to combine the formula for repetition and ordering.  I know the number six letter words that do not have to appear in alphabetical order would be $26^6$.  But when I try to count only those words that are alphabetically ordered, I get stuck.
14218
$n+k-1 \choose k$  ${{n+k-1}\choose{k-1}}$  ${{n+k-1}\choose{n}}$  So I've been using $n+k-1 \choose k$ to r pick k objects from n objects allowing repetitions. In the following question though   How many ways are there to pick r objects from n objects when  repetitions are allowed and either both the first and the second  objects appear exactly once or both do not appear?   I was told that     If you want to select r objects from n and the order doesn't matter   and each object can be reapeted than the general formula is: ${{n+k-1}\choose{k-1}}$ or ${{n+k-1}\choose{n}}$   and now I'm just a bit confused on the difference between them, and the usage  cases. I am a beginner so a simple explanation would be appreciated!
120061
Shouldn't be repeated in any case; if the numbers appeared is exactly the same as another but different orders, that doesn't count as a new set. For example: $11,13,18,19,19,20$ is the same as $13, 18, 19,11,19,20$.
24633
I would like to count the number of unique selections from a column that contains multiple selections from a drop down list.  For example, column B3 contains,     Monday, Tuesday, Wednesday   The count function returns a value of 1 instead of 3 - is there any way to count the three days distinctly? Thank you!  Multiple selections from a drop down list was made possible using the VBA code from:
121044
I searched for a similar question but couldn't find one..  I want to generate 10 groups out of numbers ranging from 1-60 (including both), with each and every group containing random and non-repeating numbers. How can I do this in excel?
93203
How many bit strings containing exactly eight $0$s and twelve $1$s have either all the $0$s consecutive, or all the $1$s consecutive?  My working :  There are $20$ positions $(8 + 12)$   Since there are $2$ possibilities for each position   Thus $2^{20}$
88965
To concatenate a certain four cells, I'd use:  =CONCATENATE(A2,",",C2",",D2,",",F2)   This would make it so that...   A2 = "Matthew" C2 = "Mark" D2 = "Luke" F2 = "John"   would result in Matthew,Mark,Luke,John.  But we run into problems with something like...   A2 = "Jesus" C2 = "" D2 = "Mary" F2 = "Joseph"   which would result in Jesus,,Mary,Joseph.  Here, the extra comma is undesired. Is there a way to gracefully handle this so that all non-blank cells are included in the comma-separated list, while avoiding the addition of unnecessary commas when some cells are blank?  Certainly, this can be done with a fair number of nested IFs, but I really want to avoid that if possible. Can it be done with native Excel functions, or perhaps an array formula? Or would one have to resort to VB Script for something like this?
76162
In a long, long, long writing. I have a piece of text that repeats in several places/sections/chapters. When I'm editing, I change 2 or 3 words in that piece of text. The changes have to be applied to all its repetitions in the document. The question is, how can I automate this?  The solution I'm looking for would be something like:  Lorem ipsum \textthatrepeatselsehwhere{This text will be shown in several places}\label{textrep1} lorem ipsum.  Lorem ipsum \displaytextoflabel{textrep1} lorem lorem.   The output should look like:     Lorem ipsum This text will be shown in several places lorem ipsum.      Lorem ipsum This text will be shown in several places lorem lorem.   The solution might be obvious but I don't know how to do it. Thanks, any help will be appreciated.
22851
Suppose I have an Excel sheet with below data    CODE (COL A) | VALUE (COL B) ==============================   A01         | 10   A01         | 20   A01         | 30   A01         | 10   B01         | 30   B01         | 30   Is there an Excel function working like ..    SELECT CODE, count (Distinct *) FROM TABLE GROUP BY CODE    CODE    | Distinct Count of Value ===================================   A01    | 3   B01    | 1   or, better yet, can I have an Excel formula pasted in column C to get something like this:     CODE (COL A) | VALUE (COL B) | DISTINCT VALUE COUNT WITH MATCHING CODE (COL C) ===============================================================================   A01         | 10            | 3   A01         | 20            | 3   A01         | 30            | 3   A01         | 10            | 3   B01         | 30            | 1   B01         | 30            | 1   I know I can use pivot table to get this result easily. However due to reporting requirements I have to append the "distinct count" column to the Excel sheet, hence pivot table is not an option.  My last resort is to use Excel macros (which are fine), but before that I would like to learn whether Excel functions can accomplish this kind of task.