assigned

Hello - I've searched the forum, but not found anything that specifically addresses my issue. I have a task list workbook that contains 4 sheets: Master, Today, Assigned and Done. All tasks are entered in Master, and I want to have the row deleted from Master and moved to the next available...

Hello all. Here is the scenario. I am using Excel to track the inventory of desk phones(among other things) This screenshot is row 8. Here is what I currently have for the H Column =IF(G8<>"",INDEX(AD_Username,MATCH(G8,AD_Locations,0)),"") The phones are assigned to a particular seat or...

I have some data where i need to use a vlookup to get from one column to another, i attach a screen shot of the data and i need to get the following; I have data in column c which i need to match the main list in column F, the data that needs to be assigned where there is a match is the data...

I have 1 excel problem. • I have 9 different numbers or letters (from "1 to 9" or "a to i"). • For each number I need to assign 1 number from remaining not assigned numbers (same number can not be assigned to itself for example 1 can not be assigned to 1). • Second requirement is that each...

Hi, It’s time I cleaned up some of my Macro names from when I first started to record them. Example. You see a suggested macro name of say Macro12 so I just kept it. I assigned the Macro to a button and works well. Some time down the road I now want to clean up / rename these odd Macros...

I'm looking for a function that would return a value which has a binary characteristic assigned to it. More specifically, a function that would only return the values with 1 assigned to them (i.e. male employees) into the male employee list but disregard any female (i.e. 0) employees <tbody>...

Hello everyone, Im a first time poster here although I have found a few solutions Ive needed from this site so I thought I'd sign up to see if anyone can help me this issue. I have a spreadsheet that gets more data added to it daily, it has a lot of nity little feateures but as the size of it...

Hi I have 10 Form control buttons in a sheet and each one is assigned to different vba Sub. Lets say I forgot which sub assigned to Button1. How can I find out? Right click on the Button1, wont tell me which sub is assigned to that button. Thank you.

Can worksheets be protected to view only that have VBA code assigned to them that are linked to other worksheets? I have one work sheet that is for data entry and another work sheet link that I want to be viewed only. The view only worksheet has cell's linked to the first with charts...

Hi I want program for below formula =SUM(COUNTIFS(Data!A:A,{"Assigned","Pending","Pending - Not Assigned"},S:S,"="&TODAY()))

Hi all, Need some help with SLA generation as I've expanded all my resources to find the answers and this is why this is my first post. I'll try to be as thorough as possible. The SLA computation in my customer's account has a 3 days SLA to complete tickets. Example: - Supported hours - 7am...

Hi all - thanks for your time and expertise. I'm considering using Excel to update the way my team provides monthly updates to the boss. I imagine having a shared workbook with a worksheet for each month of the year. Each row will refer to a task assigned to the ten staff in my work area...

I am trying to track when an outside contractor performs work on my job site using two metrics: date assigned and date completed. What I want is to find all occurrences of "OCD" in a worksheet, then have Excel look to the left and see if there is a date in the "Date Assigned" column and if...

Hi all If I’m trying to find out a percentage of a total where number of people to start were 0 - how do u show it for example An agent was assigned 2 tasks but he completed 4 would be 4/2 = 200% An Agent was assigned 2 tasks but he completed 1 would be 1/2 = 50% what if the agent was...

I have 1 column with names, each name repeated 20-50 times. Every row has assigned number ascending randomly 1-99. Must assign in filtered list (eg. 6000/30000 rows) counting numbers from lowest assigned to highest and start counting from scratch when reaches next alphabetical different name...

Hello I have a list of suppliers and sales reps that are assigned by Alphabet. For example; any supplier that begins with letters A-C are assigned to JAMIE, in addition to that any suppliers that begin with letters D-F are assigned to DONNA and suppliers that begin with letters G-I are...

So I have another spreadsheet that computes the total manpower for specific sections and assigns a "mission" for each day. To fulfill the "mission" we have to breakdown the total manpower and assign each section a set amount of days based off of how many people they have/can support. Each day...

Hi, I am doing a filter using the below code: filterRange.AutoFilter Field:=11, Criteria1:="<>" However I do not want to filter as mentioning field as 11 Using Find I found a text "reversed" and assigned it to a variable called "celladdress" Now cell address shows as K1 So I want to filter...

is it possible to use a formula that will return the below from a large amount of data when given a date range? i need to know what Assigned ID performed the best over the date period, what was their total volume for that date period and the location. i have been looking for formuals that use...

I have 10 tasks that can each be assigned to 1 of ten sequence numbers. If there is more than 1 task assigned to a sequence number those tasks are run in parallel. So there can be anywhere from 1 to 10 tasks assigned to a sequence number but each task can only be assigned once. The tasks are...