activity

dear experts, what formula can i use for an array like from a month calendar (boxes) in which I can have the list (type) of schedules within every dates of the month. <tbody> 1 2 3 4 5 activity A activity B activity C activity D activity E activity V activity W activity X activity Y...

Hi, Everyday I receive an open call list. My macro works great if I run ccleaner before hand. If I run the macro on different days it errors. I know it is hanging up on the title CRM Activity Report. Is there a way to compensate for the title changing to multiple copies? IE CRM Activity...

Hello. I have a timetable on Excel. The first worksheet is organized into blocks of different activities. For each activity there are staff members and participants listed. On the second worksheet, I use formulae like this one...

Hi All, I wondered if anyone can help me with a simple formula to automatically input activity cost data on the basis of frequency intervals. Below is a simple example the cells in green are input by the user, the yellow ones I would like to be calculated by a formula. <tbody> A B C D E...

I've tried using a pivot table for the following but I can't seem to get it to work. Basically my raw data has 500 names (I've just shown a sample below), a year group against each name and an activity against 3 different sessions. I want to be able to summarise the data as shown below (so...

I have some data I want to present as a horisontal stacked bar Its a time serie. Hours in decimal as first column, time elapsed in second and activity in third. I want to present it as a horisontal stacked bar chart where each group of activity has its own colour (so the two talking categories...

Dear all, I need your help to add an incremental column A related to column B, where the index is always incremented by 1 each time the value of column B changes, PS: column B is merged each time we have new Activitiy This is the current excel: <tbody> <tbody> Step Activity 36...

my excel sheet contains a lot of tasks (rows), in one column the status is maintained like (dropdowlist): "", Open, Started, Closed etc... One activity consists of a lot of these tasks, so i want to determine the lowest status of the task and assign that to the task. For example task 1 Open...

I have two columns called "Job" and "Activity" - There can be multiple activities for one job (But they differ for each job) e.g. For Job X the Activity can be Certification, Assembly, Painting, etc. For EACH of the Numbered Items it can be Assembly, Inspection, Painting, etc. Is there a...

Hello to All, I'm writing from Italy; This is my first post on this forum, using Excel since long time but not expert on VBA..<o:p></o:p> This is my issue:<o:p></o:p> During follow up of my team activity job, I use one list of problem we are working on, day by day;<o:p></o:p> Each row contains...

Hi, I have a huge data with date and time between 1activity and the other. I am searching for a formula to find out the "hour, Minutes and Seconds" difference excluding weekends(Saturday and Sunday) <tbody> 1st Activity 2nd Activity Time Difference 09-30-17 22:54 10-01-17 08:21 09-23-17...

Every month, I import a fairly large csv file with records about a company that we provide ride services for, and the daily activity for that company. I need to get the day-of-the-week for each row. The "problem" is that each day's activity may have from 1 to x number of rows, and only the...

my first sheet is called database. column a is the serial number, column B is the activity name and column C to the end is what items are needed for a certain activity. my second sheet is called schedule. column a is the serial number, column B and c is the dates (beginning and end) column D...

Hello, I am looking for a clever way to rearrange data in order to be able to import to a financial system (unit 4 / Agresso). The input: <tbody> Activity 201701 201702 201703 201704 201705 201706 201707 201708 201709 201710 201711 201712 Activity 1 5000 5000 5000 5000 5000 5000 5000 5000...

Hi guy, i just need to summary their activity by most feq and date, already try index, mode, match but cat filter up by date, help me please. <colgroup><col width="88"><col width="77"><col width="64"><col width="83"><col width="167"><col width="64"><col width="64"></colgroup><tbody> John...

Background: Every week or so I need to adjust pricing on all of my vehicles. This is a cumbersome task so I have been trying to approve it. Current: I wrote a simple formula in Column E to determine if a stock # had activity with in a certain time frame...

Hello there, sorry if this has been asked before - I don't know the lingo yet ; ) I would like to match 3 to 4 columns of data in a row in sheet 1 to the same data and amount of columns in Sheet 2 a ie matching between Project ID & Activity Id & Activity Name and find differences in one or two...

Hi, Could you please help me with the following task: have a long list of activities and their start and end time. What I need is to split the duration of each activity by half an hour intervals as my example below. The blue intervals show beginning of each interval, for example interval...

I have transformed my data as far as I can get and probably as inefficiently as possible but I am so close to what I want. In column 1 (Address) I have a list of all address' in column 2 (Activity) I have a list of all activities that happened at that address and column 3 (Count.1) I just added...

Hello, I tried to search for this but had no luck. Could be just an issue with knowing what to search for. If so I apologise, can you point me to the correct place. I am trying to produce a (dynamic) list of the Top 5 Categories with their Top 5 Sub-categories and the remainder...