ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can Excel tell me what groups i have? (https://www.excelbanter.com/excel-discussion-misc-queries/215331-can-excel-tell-me-what-groups-i-have.html)

Mark

Can Excel tell me what groups i have?
 
I'm sure i've asked this before, but i'm affraid i can#t track it down.

I've got data for around 1500 individuals with 15 columns of data in
TRUE/FALSE format

I want to see what groups i have and how many individuals are in each based
on which of their characteristics are true and whichare false.

Can i do this? if so how!

Thanks

Max

Can Excel tell me what groups i have?
 
"mark" wrote:
I'm sure i've asked this before, but i'm afraid i can#t track it down.


You can check it out he
http://tinyurl.com/9wtzf9

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

Pecoflyer[_65_]

Can Excel tell me what groups i have?
 

Without more details about "groups", I think Pivot Tables will be what
you need


--
Pecoflyer

Cheers -
*_Membership_is_free_* & allows file upload -faster and better answers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46528



All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com