$$Excel-Macros$$ adding adjacent (contagious) cells only

2011-07-20 Thread Azeema Faizunnisa 
Dear Experts:
Let me see if I can explain this to you.

I am working on a research project which relates to time use from 6am to 12
pm, by different activities. (see attached data for a selected no of
respondents for Unpaid Work only). I would like to calculate "segments of
time" or unbroken chain of time spent on an activity. For example, if
someone reported yes (for unpaid work) at 7 am then another yes at 12 pm and
then at 3 pm, that is obviously 3 segments of time reported for Unpaid work.
But if someone reports unpaid work at 7 am and it goes on till 10 am it is
the same number of hours but only 1 segment! While I can calculate the
amount of total time a person has spent on an activity, I cannot come up
with the formula to calculate the number of segments for each row
(respondent). Can someone help me count the SEGEMENTS of time?


Many thanks in advance.

Azeema

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


UnpaidWork.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ excel query

2011-06-15 Thread Azeema Faizunnisa 
thanks everyone for offer of help. Here is the sample data.

On Wed, Jun 15, 2011 at 1:31 AM, Venkatesan c  wrote:
> Hi Azeema,
> Send the sample data and some one will assist the query..
> Best Regards,
> Venkat..
>
>
> On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa  wrote:
>>
>> I have a table in excel of # of employees by age, sex and category of
>> employment. The ROWs have three diff categories by sex and the COLUMNS
>> have age (5 10-year age groups). Each cell provides the number
>> (frequency) of employee for a particular age group and job category
>> and sex!! I would like to convert the this TABLE to a data format, ie,
>> I want to have age categories, sex, employment category all in columns
>> and also break down the frequency to a single case, ie each row for
>> each employee...  Is there any way to do it in excel?
>>
>> thanks.
>>
>> azeema
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>
>
>
> --
> Best Regards,
> Venkat
> ) 91 99414 31925
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


CampusEmployees.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ excel query

2011-06-15 Thread Azeema Faizunnisa 
I have a table in excel of # of employees by age, sex and category of
employment. The ROWs have three diff categories by sex and the COLUMNS
have age (5 10-year age groups). Each cell provides the number
(frequency) of employee for a particular age group and job category
and sex!! I would like to convert the this TABLE to a data format, ie,
I want to have age categories, sex, employment category all in columns
and also break down the frequency to a single case, ie each row for
each employee...  Is there any way to do it in excel?

thanks.

azeema

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel