and Mahalo for your help.
Azeema
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2
Thanks a lot everyone for your quick help. This is one of the best
forums for Advance Excel.
Azeema
On Jul 20, 2:42 pm, Haseeb Avarakkan
wrote:
> Hello Azeema,
>
> Use this formula, say in V2 & copy down.
>
> =COUNTIFS(A2:S2,"Yes",B2:T2,"<>Yes") Th
r 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 advanc
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
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