assigned

I have a large one year dataset (around 20,000 rows) where there are two main columns, one is the unique identifier (duplicated), the other is the employee assigned to that unique identifier (unique). I am trying to develop a formula to count the number of unique employees assigned to each...

How can I have Excel return a list of job assignments based on a particular location? Employees assigned to a particular airport in Texas have to do research in all the adjacent counties to that airport (there are over 250 counties in Texas). For example lets say Jack is assigned to do work...

For reasons that remain unclear some code I used to unprotect a sheet has stopped working I know it used to work before, oddly enough I can unprotect it in the manual way, by going to Review and Unprotect sheet, so I know there is nothing wrong with the password The code I have used is...

I’m using a Vlookup formula and the cell I’m using as the Look_Up value is a cell that has aVlookup formula already assigned to it. I keep getting Error and I’m wonderingif it is because the cell I’m referencing is not returning a true value? <o:p></o:p> This is the formula I’m using in F8...

Hi all, I have created a macro that runs over more than 50 worksheets. These worksheets are listed in a table in 'general' worksheet. I need to run the macro on the worksheets that have 'true' assigned to them, or exclude those having 'false'. So far, I wrote the macro by adding 'If ws.name <>...

Hi All, need you expertise on below case. This is breakdown of marks for task assigned. <tbody> Approve Reject Uncontactable 50% 30% 20% </tbody> if i assigned with 70 file/submission and result as below :- <tbody> Approved 15 ??% Rejected 16 ??% Contactable 39 ??% </tbody> how can...

Hi I have a ticket resolution data as shown below. I would need this data to monitor my SLA compliance. Excel 2007 32 bit <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>#F0E0E0[/URL] "] A B C D E F </thead><tbody> 2 Ticket Assigned Date Acknowledged...

I have searched a lot for an answer to this and am beginning to think there isn't one... I would like to create a list of all the currently assigned shortcut keys, I don't just mean those assigned to macros but the ones delivered with Excel and that may or may not have been amended. I think...

Yesterday I changed my OS from Win7 to Win10, although not sure if that has anything to do with this issue in Excel... I have a series of macros which reside in my personal.xlsb file, that I have keys assigned to in my toolbars, that no longer work. If i hit these buttons I get the following...

Hi, I have a sheet with about 600 shapes. One of them (just one) is assigned to a macro that opens a simple userform. When i click on it, it takes too much time to open the userform. When I delete all other shapes, it opens faster. I would really appreciate your help to solve this problem. Thank...

Ok, I have a large set of data and the values in the rows repeat themselves but they mean something different based on other factors. Here is a sample of what I am looking at: Loc Item 1 A 1 B 1 A 1 B 2 A 2 B 2 A 2 B 2 A So I want a different value assigned to the first row that has 1 and A...

I'm using Excel 2010. I have a string variable named strMaker that is assigned to another variable (to combine values with another variable) before being assigned to an outgoing email message using Outlook. The value contained in strMaker is an employee ID that gets assigned to the "Cc" field...

Hi I have a macro that is used to delete a player from a worksheet by clicking a button that the macro has been assigned. What I have found users are deleting players using the remove a player button by accident. Is it possible to include a message box that asks for confirmation "Yes" or "No"...

Hi There, Hope this is in the right place. Im trying to make an audit of data quick and easy to do in excel. I have a list of reference numbers in a column, the reference number could be in the column twice or three times. Depending on whether its in twice or three times I then want to check the...

Hi, I currently have a table consisting of several names, each name assigned to one company. One name can be assigned to more than one company, giving me a column where the same name appears several times, ex.: Jane Doe (4 rows) and John Doe (3 rows). What is the best way to project how many...

My workbook has nine sheets, each sheet has project names in column A. persons are responsible for their own assignment, sheet tab shows the person’s name the sheet assigned to. Some project are duplicate, meaning they were assigned to more than one persons. What is the best way to find out the...

I created a project task spreadsheet that has a GANTT chart as a part of it using formulas and conditional formatting. It works rather well for tracking tasks, their completion %, task owner, etc. There are several "sections" that list tasks which fall under that classification. Every Tuesday I...

In EXCEL I have created buttons which have macros assigned to them. I would like to know which button they clicked on, who clicked on that button and what time they clicked on the button. Is there a way to create a log file using VBA so that when they click the button, it writes out that...

I want to assign a macro to a keyboard shortcut, bit I don't want to clobber a key combination that is already assigned to something else. In Word, when I go to assign a keyboard shortcut, it tells me what that key combination is currently assigned to. Excel does not do that. Is there some way...

I have been sent an Excel file that generates random maths questions. I understand how this is happening and how it has been set up ... BUT It has a message that says "press delete for a new question" So pressing delete recalculates all the formulae over four worksheets I know I can do this by...