Multiple Column Ranges

to search For values in the intersection of the row and column you want the table of a special type: in the header row and the leftmost column should be non-repeating values.

Combine the values located in multiple columns into a single column.

Sometimes, you need to combine three or more list of values into one.

Having two lists with the same type of repetitive values, we will create a list containing only distinct values.

Having two lists with the same type of duplicate values, create a list of them, containing only unique values.

Find the number of unique numeric values in the specified multi-column range.

Find the number of non-repeating numeric values in the specified multi-column range.