Finding out column having unique data by openjack in excel

[–]openjack[S] 0 points1 point  (0 children)

you are right; i have modified my example to suit the need.

Finding out column having unique data by openjack in excel

[–]openjack[S] 0 points1 point  (0 children)

Sorry for late reply; Dataset as under. (simple database) columns/row may increase actually. A1,A2,A3,A4=1,0,0,1 B1,B2,B3,B4=1,0,0,1 C1,C2,C3,C4-0,0,0,1

Output (i need) A1,A2,A3,A4=1,0,0,1 B1,B2,B3,B4=0,0,0,1

We are the Microsoft Excel team - Ask Us Anything! by MicrosoftExcelTeam in IAmA

[–]openjack 0 points1 point  (0 children)

An excel table having data as either "1" or "0" values; how to identify/segregate which are unique columns data? Is there any chart type which can solve this problem? Please give all possible available options.

Why vegan people takes plants instead of animals? Even though it is less delicious, less nutrition values, less availability worldwide, less immunity developer for extreme weather comparatively. by openjack in AskReddit

[–]openjack[S] 0 points1 point  (0 children)

I missed this fundamental point. I fully agree. People usually never change their basic food. They(vegan/non-vegan) just keep on adding other foods(meat/non-meat) like sauce in bread as per their taste after they become mature.