activity

  1. S

    Macro issue

    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...
  2. R

    #DIV/0! error when cells are blank

    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...
  3. E

    activity frequency - formula

    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...
  4. M

    Can I do this in a Pivot Table

    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...
  5. A

    Timeline bar with same colour for same activity

    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...
  6. B

    Increment column based on the change of another column

    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...
  7. B

    Determine the lowest value in a range of cells where the order is termined by an second range of cells

    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...
  8. M

    How to return multiple match values from Selected Criteria

    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...
  9. R

    Count time spent by making each step activity?

    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...
  10. S

    time difference excluding weekend

    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...
  11. J

    Get a value from an unknown number of cells awy

    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...
  12. E

    macro to compile what to bring on certain days

    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...
  13. U

    Rearranging data for import

    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...
  14. D

    How to extract feq text by date, from huge data.

    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...
  15. E

    Formula needed to determine true activity within duplicates

    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...
  16. A

    Matching and Comparing data from sheet1 to sheet2

    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...
  17. R

    Splitting activity duration by half an hour intervals

    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...
  18. C

    Unique Values from Column 1 convert Column 2 into Rows

    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...
  19. A

    Top 3 of Top 3 with sum of remaining categories

    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...
  20. N

    Linking of multiple excel workbooks using VBA

    Would appreciate your immediate help pls. I have 3 excel files. First excel has values in cells E2,E3,E4 etc. (For example customer no: say AA12, BB122, etc...) Second excel has 5-6 sheets, corresponding to work centers, where day to day data & operation details corresponding to all customer...

Some videos you may like

This Week's Hot Topics

Top