Excel find which group of nunbers repeating in multiple columnes
 

I have 4 columnes with simple values. 31,42,44 appears in every columne. But this is a small sample of data . I need to work with much bigger data.
Is there any formula to find which numbers appears simultaneously on all columnes?

Answer: Excel find which group of nunbers repeating in multiple columnes
 

Yes, there is a formula you can use to find which numbers appear simultaneously in all columns. You can use the [countif] function to count the number of times a value appears in each column, and then use an [if] statement to check if the count is equal to the number of columns. Here's an example formula:

In this formula, [A:A], [B:B], [C:C], and [D:D] are the ranges of your four columns, and [B1] is the first value you want to check. The [countif] function counts the number of times [B1] appears in each column, and the [if] statement checks if the product of those counts is greater than 0 (i.e. if [B1] appears in all columns). If it does, the formula returns [B1], otherwise it returns an empty string.

You can copy this formula down to check all the values in your data set. Note that this formula assumes that each value appears only once in each column. If a value can appear multiple times in a column, you may need to modify the formula to use a different counting method.