Help with some statistical operations on lists in Excel

T

titanbull2011-02-15 20:15:43

excel

titanbull, 2011-02-15 20:15:43

In general. There is a long list with various repeated nominal values.
1. Is it possible to somehow quickly display statistics on how many times each value is repeated?
2. Is it possible to somehow compare one list with others and display those values that match in them?
Thank you!

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

X

xSus, 2011-02-15
@xSus

for n1, you can consider the option =COUNTIF
only needed for each value of a single

A

Arman Toksimbaev, 2011-02-15
@toxicdream

1. Data - Sort
Data - Totals
2. See the MATCH function