activity

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

Hi, I am trying to create a calendar from a list of activities where if the cell is between a certain time frame it will output the name of the activity during that time frame. The name of cells are within three cells A5, B5 and C5 which the text will be combined into the one cell. However i...

Hello friends, Hope all is well! Is there a shorter version to make the below formula? it suppose to give a 1, if any result showed up in a certain month, and provided that the amount related is above 4999. 1. Basically, the point is to show the number of months that had any activity or...

Hi, I have aset of data on one sheet, with multiple site ID's but each ID will have adifferent set of data as below, once this data has all met a certaincriteria I want to move it onto a new tab the data set is below as an example: <colgroup><col width="64" style="width: 48pt;"> <col...

Hi Everybody, Can someone join Formula #1 and formula #2 into one: Eg of text string in A1: "Line 1884: 10:28:24.817 00000015 I Activity Duration: 00:00:25.3812446 - activity" Formula #1 in cell B1 "=RIGHT(A1,LEN(A1)-FIND("n: ",A1)-2)" Formula #2 in cell C1 "=LEFT(D1,FIND(".",D1)-1)"...

Hi I want to extract the Text after PO mentioned in below text Note: All PO number are 14 Digit Alphanumaric <tbody> 1 BEING BILL NO JG/18-19/251 AGAINST HERO'S PO NO-CHN:18-19:1517, PO DATE-6-8-2018,ACTIVITY TOWARDS -LOAN MELA (DOWN PAYMENT RS./-1) BARNALA, DURATION-22/06/2018 TO...

Hello, I need a formula to return the countif based on the current work week (starting on a Monday). My data looks like this: <tbody> <tbody> Weekly Activity </tbody> <tbody> Total Activity </tbody> <tbody> Date </tbody> <tbody> 03.08.2018 23:00:00 </tbody> <tbody> 03.08.2018...

Morning everyone, I have a test for you all. I have a schedule of activities that people take part in every day. It is broken up into half an hour slots. e.g. 08:00 - 0830 people do 1,2,3,4 1,2,3 & 4 being 4 different activities, which equates to 7.5 minutes per activity. I'm looking...

Hello, I am trying to perform an IF function with multiple criteria. I'll explain what I'm trying to do first and then my formula is at the end. There are 3 columns: Check Mark, Formula, Activity (in A, B & C) In my example, imagine the "1" to be a check mark to do the activity in column C. If...

Working on a project to show text and voice call activity between sales reps and customers. Here is a small sample of what the data looks like: The goal is to display call activity for each day of the year to show trends and volume of activity. The horizontal axis will be day of the year...

I’m not an advanced excel user and my Access skills are non-existent, so I am looking for a simple approach. I need a project management solution for a large team of consultants to track i) client meetings and activity, ii) assignments and progress, iii) new prospects & contacts that they have...

Hi I need some help. I have a gantt chart created in excel for a project, I also have a budget associated to each task in the gantt chart. The budget is monthly. Is it possible to link the gantt chart to the budget, and more specifically, if the timeframe for an activity changes (i.e. becomes...

I am trying to build a calendar that auto populates from various sheets - it is to show marketing activity from different teams in one view. Each team will have a sheet that they update which will show the name of the activity in one column and the date of the activity in the next column (this...

Hi, I've got a data set that looks like the below Listing <tbody> Company Listing 1 Listing 2 Activity a (1) Activity b (1) Activity a (2) Activity b (2) Dan Dan's CDS Dan's Books Jan 30 Feb 12 April 9 Jan 20 Bob Bob's DVDs Bob's Plates Jan 2 March 8 Jan 2 Jan 30 </tbody> I would...

Hey all I've got an equation that is working but has an issue. Objective: to find the amount of time it takes to switch from one activity to the next. In order to say the switch is complete 5 activities must be complete in a certain amount of time. Attempted Solution: I used a...

Hello together, unfortunately I have to work with databases like below. People work on days 1 - 5 and do different activities I would be glad to be able to have the data like written in column "J" without workarounds. In this case people who worked on day 3 with activity "c". Thanks very much...

Can someone help shed some light on an #NA error I am receiving with a Vlookup formula? I am trying to help users interpret account codes. I have a 10 digit accounting string and the 10th number tells the user what type of activity the funds will be used for. -I used =MID(B3,10,1) to...

Hi, I'm used to basic Excel usuage but I'm trying to do nothing which I know is possible but I just can't work out how to do it. Please can someone help.....:confused: I have a Master Copy Template Workbook with a date in A1 I want to automatically generate identical sequential editable...

Dears, kindly I want to fill Column sub Category 1 & 2 from another sheet with the Following Condition Sub Category 1 will be : if (Activity coloumn = 211 or 212) : COGS if (Activity coloumn= 111 or 231) : G&A if (Activity coloumn= 111 or 231 & Cost center = 312 & 341 ) : S&M i think i need...

Hi all, I am trying to get my spreadsheet to copy data from a specific cell if two other cells match a specific criteria. Could anyone assist? <tbody> Surname First Name Date First Activity Last Activity Log In Log Out Total Minutes Addis Neil Wednesday 03-Jan 08:41 (Access Granted)...