$$Excel-Macros$$ stuck with a password protected excel file
Dear All: You guys and gals have been so helpful to all my previous queries and I highly appreciate that... I am stuck again with Excel. This time with a Excel file which was password protected by my ex colleague. He somehow has forgotten the password and it seems there is no way to retrieve the information in it.. I have tried some tips that I found online like opening in google docs, but that does not work. I am too worried to use some online software to crack the password because the file contains sensitive contact information of our clients Is there any solution? Many many thanks 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) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ adding adjacent (contagious) cells only
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
$$Excel-Macros$$ excel query
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
Re: $$Excel-Macros$$ excel query
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...@gmail.com 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