$$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

$$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

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 venkat1@gmail.com 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 aze