activity

  1. N

    Dynamic Reporting Calendar in Excel

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col...
  2. D

    What would be the best way to do this?

    I am making a spreadsheet that allows you to enter an activity, press a button, then it stores the activity. A list of activities are compiled over time and there is another button that selects a random activity from the list. You can't use variables for this as they only last until the...
  3. D

    Excel formula to add a minimum amount and add an extra hour

    I have a spreadsheet with data entered into cells A5:E11 in a matrix. This is a named range with the name Service_Types. Along the top, starting at B5 I have Mon-Fri, Sat, Sun and Public Holiday. In column A, starting at A6, I have a list of activities. The cells contain hourly cost of certain...
  4. C

    Assigning work to people by day

    Good afternoon, I download a spreadsheet once a month that contains workorders for a given department. The workorders are divided up by responsibility and by the activity code. We then assign the correct employee and shift to the workorder (manually right now). In Power query I have the table...
  5. T

    Help Countinting the number of sheets that have a value in a cell

    Hello, I have a workbook with 25 sheets (tabs), each representing a different project with data reporting the number of people reached by that project for a range of different activities. Not all projects did all activities. I have a consolidated sheet in which I need to count the total number...
  6. R

    Activity Log - Excel

    Hi Everyone, I have an excel contains value and embed objects. I Want since open, all activity should be track in excel (Edit, Add, add/delete embed docs etc) log should be password protected on excel. is it ppossible? let me know for further questions
  7. A

    Advanced Filter

    Dear all, i have a table as follows Activity Code Date 0101 3/14/2019 0201 1/13/2019 0203 3/1/2019 0203 1-1-2019 0203 1-4-2018 0340 2/3/2018 0344 1/1/2017...
  8. E

    Excel formula to 'append' information together?

    Hi all - I am attempting to use Excel to find information from one table and assign it to other tables....which is normally easy....but there is a conundrum I have run across. For example: <tbody> I currently have this information: Standard Section Activity 200.01-14 627 200.15-17...
  9. D

    Graph Activity by time of day

    Hi all, I've managed to stump myself on what should be a fairly simple task. I have a data file with activity by time for employees. Each action has a time next to it. I'd like to create a chart that visualizes the breaks between actions so that one can see for example that someone took a...
  10. F

    Macro for Running a Series of Formulas for Multiple Categories

    Hello, I have a report that breaks down various scores for a number of different activities by employee. I want to run some statistical analysis per activity by employee to look for and delete outliers. I need the code to first run the average for each activity, then STDEV.P, and then finally...
  11. J

    VBA: fill cell with colors in another workbook

    Hello there, In workbook1 I have the following: ...................Name 1.......Name 2 2019-04-16 2019-04-17 2019-04-18 2019-04-19 2019-04-20 2019-04-21 2019-04-22 In workbook2, I have data as such: Name 1...........Activity 1.........Activity 2 Start...
  12. M

    List of time data using start and end times and presenting duration as an hourly table

    Hi all, I have a list of activities that include the start and end time - I need to sum the duration of these activities into a table with hourly intervals. It would be easy enough if all the activity was only an hour in duration :laugh:, however there are activities that are an hour and 30...
  13. S

    If time matches list of time within 5 minutes

    Hi All, I currently have the below formula: =IF(AND(R2="c",MATCH(D2,'Activity Report'!$A$3:$A$8),MATCH(B2,'Activity Report'!$C$3:$C$8)),"Confirmed","False") The Cell B2 and the column of C in the Activity Report are time and dates, formatted as (dd/mm/yyyy hh:mm:ss). Effectively, when I am...
  14. M

    IF Statement to return Value

    My excel workbook was built by a previous employee and I am not having any luck updating the excel formula to return the value needed. The formula is used to scan bank transaction descriptions and identify store activity. The formula below currently determines if the activity is cash or...
  15. P

    "What If" slicer in a pivot table with actuals How?

    I have a simple pivot table that categorizes checkingaccount activity like this: Paycheck 100 100% Grocery -10 10% Rent -5 .05% Gas -5 .05% Etc… Total 80 80% A power...
  16. S

    Please Help me with VBA on this large file

    Hi All I have 2 sheets with almost 300k rows of data.. The columns are from A to Q the dates, agent name and start times and times are sorted to sort each agent schedule that day I need to have a macro that loops through every day and checks to see if an agent had any activity that say...
  17. L

    index match, multiple columns/array with date, strings and blank cells

    Hi, I have a problem regarding a structure for project management and specifically deadlines. On the rows I have different customers/projects which each have columns with different activities, e.g.: <tbody> Project/Customer Deadline activity 1 Deadline activity 2 Deadline activity 3...
  18. U

    How to update all Cell References Each month automatically rather than Manually

    Good morning, I have Excel 2010 and I should have asked this question years ago, but better late than never I suppose. I am just hoping there is a more efficient way to do what I have been doing for years. I report every month some of my staffs activity from the previous month. I have on the...
  19. I

    Help with DATEDIF function dependent on if today's date appears in last row of column

    Hi I have the following formula in Cell A10: =(DATEDIF(TODAY(),DATE(YEAR(TODAY()),12,31),"d"))+1 This calculates the number of potential activity days left in the year. However, as it's only based on the calendar, the result is incorrect when the current day's activity has taken place. What...
  20. H

    Return month from GANTT table

    I have a Gantt Table based on activities (vertical axis) and and month (horizontal axis). In this Gantt table, cells are colored if there is activity in the month I need a formula to show me in which months that business is doing. For example, if an activity takes place in month 1, the...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top