Question about common values across columns

Question

I have a set of 20 column, each contains number value. I would like to have a function in excel or in r or somewhere else to extract the shared values among all the columns.

Several of the online Venn tools can visualize and list among up to 6 columns.

Any tool?

Thanks

Could you show us the data and an example of what you want to do to it? — Worm, Dec 19 '18 at 21:00

akrun · Answer 1 · 2018-12-19T21:01:50.017

1

in R, we can use intersect with Reduce to get the common values across all the columns

Reduce(intersect, dftest)

data

dftest <- data.frame(col1 = 1:5, col2 = 2:6, col3 = 3:7)

edited Dec 19 '18 at 21:01

answered Dec 19 '18 at 20:52

akrun

874,273
37
540
662

Question about common values across columns

1 Answers1

data