# activity

1. ### Can you do an IF(AND array

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...
2. ### Shortening the Countifs formula.

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...
3. ### Copy data from one sheet to another if criteria met

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...
4. ### combining 2 formulas i.e. =Right and =Left to save time

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)"...
5. ### Need to Extract Text

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...
6. ### Countifs based on current week

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...
7. ### Calculation with multiple numbers in single cell

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...
8. ### IF Function with multiple criteria

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...
9. ### Help with stacked bar chart showing annual call activity?

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...
10. ### Excel Powerpivot vs. Access

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...
11. ### Linking a gantt schedule to a budget

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...
12. ### Enter data into a calendar from one column when data in another column falls in a date range

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...
13. ### Data Set with multiple dates - needs calendar pivot table

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...
14. ### Matrix Equation Match(Frequency( not stopping after specified number

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...
15. ### Index Match with one criterium in multiple columns

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...
16. ### Vlookup #NA Error

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...
17. ### Automatically generating duplicate workbooks renamed with incremental dates

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...
18. ### how to merge multi If with Vlookup ?

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...
19. ### Copying data from a cell if two other cells match specific criteria

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)...
20. ### get the cell content in an array which is nth row below that cell

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