advanced

I have the below array formula which filteres for uniques in column L where column P is within 7 days of the date in column R (and K = central and G = S16). It works perfectly ok but does not quite do what I now need. Column L will contain the same code multiple times, I only ever want it to...

Hi everyone, I am currently creating an employee scheduler using a Reversed Gantt Chart, one where the user plots the schedule in the chart then the START and END details are automatically updated (using formulas) while plotting. I used legends such as 0 - vacant hours, 1 - working hours, 2 -...

Hello all, I am working on creating a dashboard view that shows the number of defects assigned to each team member over time. What I have are daily tables for the past month. I've provided two example tables below: 08/01 File <tbody> Field Name BA Name Status order_name John Open...

Hi, Trying to work through an advanced Filter. How do I complete the filter between 2 dates and also filter if the name is there twice. I have an appointment booking database and want to create an alert if the person has been booked X amount of times in a week(lets say 3) Headings are...

Hi Guys, I have in my opinion a challenge with some VBA, but im sure there is a wizard in this forum who can help! I have three sheets that need to work in unison with each other. This is how I think they should work. Sheet1 (Entry Sheet) All the information will be entered here and...

Hi I am currently trying to set up two data filter criteria for my spreadsheet. I am using the format: =">=" &DATE(2017,1,1) on one side but it shows up as >=42736 which is the serial number. I tried formatting it but it won't budge. Is there a way around this where I can format the dates...

Hey Everyone I really hope someone can help me with this! I am doing a VLOOKUP match-up between company names in one column, and company names in another column. The company names have an inconsistent format (like HeroSwap, Inc. in one column and HeroSwap Incorporated in the other). I've...

Hi there, Hoping one of you geniuses can help me out here. What I need to find is "x" in the equation: .1 = [b + (x*c)]/[a+x] where "a", "b" & "c" are all numbers based on other formulas that happen in the sheet, so they are always changing but fixed at the time of finding "x". To put that...

Good morning all. I am new to this forum so hope that this makes sense to you! I am trying to work out a commission/bonus model and want Excel to provide me with how much commission we should pay based on certain criteria - which includes a capped amount. We have 2 potential models to work...

Hi, I'm filtering a set of data, and they all contain a similar identification such as "1A1P01" or "2XDP67", the common denominator in each name is the letter P. However when I filter "???P??" it comes up with anything containing the letter P not just IDs with the that specific amount of...

<colgroup><col span="15"><col></colgroup><tbody> I have a report data like the below in sheet 1 149502 149534 151229 151235 151267 151301 151337 155142 155351 165620 169847 278985 112121 And I would like to remove the...

Hello Everyone, I everyday get large (over 10,000 rows) data in one table that i want to consolidate patient by date Names in : patient Consolidated column : billed, approved, collected, adjusted Filtered or Summed by : servdate Like : Patient | servdate | billed | approved | collected |...

Hi board, I'm having trouble doing the following, and I haven't been able to come up with a good enough search term to find a solved version of my problem. I have about 7000 line items, but I'll simplify it to explain what I'm trying to do. Basically, I have a large table of item data that I...

Ok so here is the issue I'm having. Currently the TOTAL PROMOTION POINTS column (R) is a Sum of the specific cells in each row (E, H and Q) as shown below. I also want to add an additional BONUS of 25-points for those that make the Hall of Fame's TOP KILLS & TOP BUILT at the bottom (B29 &...

Hi guys, hope you doing well?:biggrin: I need help with the following data using an advanced filter. The spreadsheet is really heavy with data already so I'd rather avoid using formula if it's possible.... here is the example: <colgroup><col span="3"><col><col></colgroup><tbody> Created by...

Hello Community, I am seeking the advice of any advanced users in my attempt to create an efficient user input, data entry form for the creation of table metadata. Scenario I am looking to design my sheet/Macro with the top two rows as user inputs, which will then paste these into a table...

Hi, I am very new to this forum. I am new to VBA although I am quite experienced with Excel. I would really be appreciative of anyone who can help me with the following, or at least guide me to the resources/functions I should be looking at to achieve them: I have a master file from which I...

Hi all, I've used the site for help in the past, but this is my first post. I couldn't find a similar scenario and would appreciate any help here. I am having trouble determining which formulas I need to use to get the values I want. On my first sheet I have events and when they occurred by...