1. ### Complex formula..

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...
2. ### Unique List When Adjacent Cell Contains a list of Words

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...
3. ### Look for a date between two date ranges and return text (IF AND statment?)

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...
4. ### IF Function?

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...
5. ### Power Pivot: 2 small linked tables returning too many results

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...
6. ### IF Lookup match combined function?

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!!!!
7. ### 6 admins, 100 staff

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...
8. ### Linking an Access database and an Excel worksheet

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...
9. ### Pivot multiple ranges or combine in Data Model

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...
10. ### Mail Merge to Outlook (email) stopped working / Excel data source

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...
11. ### VBA Copyfile with admin rights

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...
12. ### Merge tables from many worksheets into one admin worksheet

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...
13. ### Drop down list search options

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...
14. ### Lock/Unlock Cells Based on User Type

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...
15. ### Sickness Monitoring

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

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...