admin

Hi Team, I need one formula..Condition are like below.. In Col A, A2 Admin Project 1 A3 Admin Project 2 A4 Admin Project 1 A5 Admin Project 1 A6 Admin Project 2 A7 Admin Project 1 A8 Admin Project 3 A9 Admin Project 2 A10 Admin Project 3 A11 Admin Project 1 like this.. Against this I have in...

Hello all, I recently watched https://www.youtube.com/watch?v=Tq3B168qT5E and have a question regarding this. My list for example contains these 4 words that i need to use to search for a similar words in a column. admin List 1 unix hrms quality The cells that i am searching for any of...

I hope someone can help, I am trying to write a formula that looks at a date on one workbook(I4), then looks to see if the date falls between two dates on another workbook (Admin col A & B) and returns text showing on another cell if this is true (Admin col C), if false then look at the next row...

Hi, I'm trying to use conditional formatting to change the color of one cell say I3 based on certain text criteria in M3. Basically I want I3 to turn blue when M3 says (admin) for example. I understand conditional formatting but have never used it on 2 different cells. Would this be an IF...

I have 2 linked tables and wish to create a pivot table showing employee ID, Name and the person's related Role. The tables are linked on Employee ID but query displays what's shown below: Emp ID Name 123 John 456 Bill 789 Joe Empl ID Role 123 Admin 456...

Hi! I have a list of account numbers, if they match the list of $0 admin fee list on another sheet, I would like it to equal 0 but if not, 10. I have =IF(B2='$0 admin sheet'!$A$1:$A$1783,0,10). Thank you in advanced!!!!

Hi experts, I m back with another vague and cryptic problem, and I ll be honest and say this probably isnt even do able. Imagine an office with 106 staff , 6 admins responsible for organising the appointments of 100 staff. A random schedule needs to be designed on a weekly basis (daily if...

I'm currently working on a database we might use to manage funding proposals. We've got two groups of people working on the proposals: scientific staff mostly deal with individual proposals, doing eligibility checks, evaluations etc., while admin staff have more of a need to look at the entire...

I have a spreadsheet with a tab for each month. Each of these tabs contains the same 11 columns, except F and G contain the month name so those vary. I want to pivot on the Admin name, with the ability to expand and see the breakdown by RD under each Admin, by month. Admins are occasionally...

One of my clients has been using this for years and it stopped working some weeks ago (they couldn't give me a specific date or even a good guess about when exactly). It's Office Pro 2013, so Word/Excel/Outlook are all the same version. Here's what they do: 1) create a data source in Excel...

Hi all I have a simple line of code that doesnt work because I meed admin rights to place file there. Anyone able to help me to resolve please? File location to copy from:C:\Users\User1\Documents\Work\ Destination path: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup Code...

I want to build admin worksheet that contain one big table crated from many other tables in other excels files. How should I go about it? How to link many tables into one without blanks and lost of data? Info: - All tables have the same headings. - All tables contain different number of rows...

Is there is any method to easily select data from excel drop down list? as an example if drop down box contain 100 selected options and i want to go quickly options started from letter "U" .now i have to scroll down each and every select time. my requirement is very similar to option available...

I've been wrestling with the best way to do this for awhile. Requirements: 1) I have a single spreadsheet with existing data (one row per person) that needs to be updated regularly. 2) There are 4 different types of users: Group A, Group B, Group C, and Admin. 3) Column C in each row identifies...

Hey I'm trying to set up a spreadsheet which will let me track sickness for members of staff over a rolling 12 month period. So far I have: First day of sickness, Last Day of Sickness, Number of Days I would like to add a column that gives me the total number of days over the last 12 months...