Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-263397%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-263397%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20twelve%20monitors%2C%20four%20computers%2C%20two%20mass%20spectrometers%20I%20analyze%20for%20twelve%20hours%20a%20day%20but%20I%20can%20not%20figure%20out%20excel.%26nbsp%3B%20All%20I%20am%20trying%20to%20do%20is%20find%20the%20mode%20function%20to%20take%20six%20columns%20of%20data%201%202%203%204%205%206%26nbsp%3B%20mode.%20that%20is%20it.%20%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EData%201%3C%2FTD%3E%3CTD%3EData2%3C%2FTD%3E%3CTD%3EData3%3C%2FTD%3E%3CTD%3Edata4%3C%2FTD%3E%3CTD%3EData5%3C%2FTD%3E%3CTD%3EData%206%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EMode%3F%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20and%20yes%20I%20will%20put%20a%20shoe%20on%20my%20head.%20I%20am%20using%20windows%2010%20and%20my%20function%20is%20in%20excel.%26nbsp%3B%20It%20should%20be%20a%2C%20b%2C%20c%2C%20d%2C%20e%2C%20f%2C%20g%20which%20one%20occurs%20most%20frequently%20%3D%20mode.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have twelve monitors, four computers, two mass spectrometers I analyze for twelve hours a day but I can not figure out excel.  All I am trying to do is find the mode function to take six columns of data 1 2 3 4 5 6  mode. that is it.  

Data 1Data2Data3data4Data5Data 6 Mode?

 

Thank you and yes I will put a shoe on my head. I am using windows 10 and my function is in excel.  It should be a, b, c, d, e, f, g which one occurs most frequently = mode.

1 Reply
Highlighted