help formula excel

Hello, I'm going crazy trying to figure out a formula. Any assistance is greatly appreciated. On Sheet1 I have column A (Unique Identifier), column W (Authorization Date), column X (Start Date), and column Y (First Date Billed). On Sheet 2 I have column B (Unique Identifier) and column I...

I built a PTO calendar dashboard where it automatically updates the employees availability for the day based on the calendar's data. The options vary from U (unscheduled), holiday, jury duty, covering, or a value over 1 is added. This is what it looks like: =IF(OR(VLOOKUP(N28,table...

I am trying to sort column u (u1:u84) and My co-worker hooked me up with this formula: =INDEX($U$2:$U$88,MATCH(ROWS($U$2:U3),COUNTIF($U$2:$U$88,"<="&$U$2:$U$88),0)) It works great, except it left out 2 names. I messed around with it and can't seem to get it. Any ideas?

I am looking to count the number of times the event took place in January (1) or December (12). I custom displayed the month to just 'mm' and used the formula =countif('Driver Data'!AO:AO,"01") for January or =countif('Driver Data'!AO:AO,"12") for December Any ideas?

I am trying to get this code to loop through each worksheet...but it doesn't seem to want to! Sub BorderUsedCells() For Each ws In Worksheets For Each rngCell In Range("A5:E25") If rngCell.Value > "" Then r = rngCell.Row c = rngCell.Column Range(Cells(r, c)...

I have a data set with home listings, and I'm trying to answer the question, "For homes in inventory at the end of a given month, how many days have they been on the market on average?" Data specifics: Column A:Location Column W:List Date Column X: Close Date Column I need to average the days...

I have a list of ZIP codes a newspaper distributes to and potential markets a company may enter into. To advertise to these markets we must strategically distribute to specific ZIP codes. However, some markets overlap ZIP codes, so if multiple markets were entered into, there wouldn't be a...

I am going to start with saying that I really have minimal experience with Excel. What I am trying to blindly accomplish at this time is for the "IF's" in 2 cells to have one answer. Basically, if Cell L5 is > 365 AND cell N5 is < 1, then the answer is true, if both are not true, then I need...

I have been tasked with developing a spreadsheet to track employee vacation accrual. Employees begin accruing andare able to use vacation days once they have been with the company 90 days from their start date. After the calendar year of your hire date has been completed, your vacation...

Hi Folks, I' am struggling with the below formulas. Please can anyone help? I have column U and column V with values. If column U is the same as V, I need it to return text Ok. If both cells are 0, I also need my formula cell to return the text Ok. If cell U is greater than U, I need my formula...

Hi everyone, I'm new here and pretty much a noob with VBA, and am having some trouble which I really hope some kind souls can help me with! :confused: The problem that I have right now at work is unable to be recorded, and hence I would like to seek some help. For example, each time a user...

I'm having trouble inserting and extra if function at the beginning of my formula. I have a 'Job sheet' which informs my workshop of what to produce based on what has been quoted (information for the job sheet is gathered from another sheet in the same workbook). Currently, I have the...

Hi So for the code I need to come up with I have a list of dates in Column A are dates in column B are the given values in Column C are the the next days values minus one so the issue I'm having is getting excel to do this for a calendar year. It needs to skip weekends and holiday values and...

I have been asked to carry out the following: "HIGHLIGHT WHAT TARGETS HAVE BEENHIT and WHAT IS THE GAP TO HITTING A TARGET I have data of what the sales target was supposed to be and what peoples individual targets were. How can i: 1. Bess display this is a graph. What graph is...

Hello everyone! I hope that you can help me with a particular problem that I am having. Namely, I am working on an Excel sheet where I am trying to make a formula that creates a cumulative sum after a number reachest a maximum. For example, I have one component whose maximum Operating hours is...

Hey, Im wondering if there is a way to count the number of "status's" based on unique users. Like a pivot table would, and then place the value in the proper column. On the users sheet i'd like to count the number of times each status (Column F) occurs on the events sheet. See pictures on...

Good afternoon whizzy Excel people, I wonder if anyone can help me solve a problem that I'm trying to come up with a formula for, I'm usually pretty good at this sort of thing but this one is eluding me, no doubt someone out there has a simple answer using a function I haven't come across yet...

I want to generate date wise item wise quantitative summary report. But not able to judge the appropriate formula. Would appreciate if any one can help me out to sort out the same.Find below the table. <colgroup><col><col><col><col span="3"></colgroup><tbody> Date Buyer's Name Item Invoice No...

I need some serious help I need to create a date calculator but I need to exclude certain dates only if the end date falls on that date. For example, 1/2/15 and add 15 days... but here is where I am stuck... Only if the date falls on a weekend or federal holiday I need to skip to the next...

Hello, I have several countifs functions looking at the same data in order to pull totals. The first equation: =COUNTIFS(Data!$O:$O, "5 Pack",Data!$L:$L, "Plastic") Gives me the total of 1000. =COUNTIFS(Data!$O:$O, "5 Pack",Data!$L:$L, "Glass") Gives me the total of 43. The function...