help excel formula

Hi, I have a date which I will need to increment the date by a day, month or year from the actual date. This is based of a list of fields below and is different per the input. Also each resultant date has to be a business day i.e not a weekend day or a bank holiday. I will forgo the Bank...

Hello, I am trying to sum up a column with some budget-numbers, and if there has been a revised budget, use that cell instead of the original. Basically two colums: A - Budget B - Revised 1 3 2 3 1 4 Is it...

Hello, I'm Looking for an excel Formula or VBA code to color (highlight or background fill) columns based on the count series of max frequency consecutive positive numbers. It should be left open ended for more data to be added after column P and Lower than row 5. Rows described: 1. max...

Columns- count a consecutive series of positive or negative numbers and then get a sum of the max frequency Example: <tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;"> A B C D E F G H I...

I have 3 columns, column A, B, and C. Column A has names while column B and C have numbers. There are 10 rows in total. I wish to find the highest sum of a row to see which employee did the best for what i am doing. Once the highest sum is found i wish for the employees name, that is linked with...

Hey guys! So I wanted to use a INDEX-MATCH-MAX statement in order to find the highest number within a row then use INDEX to place the name linked to that number within that row. This worked well, but now I want to merge it with a IF statement and dont know how to. This is why I come to you, the...

Hello, I apologize if a similar question was already posted but I couldn't find one. Sample table shown below, the real table is much larger but same general format. I am reading in a given value off a different sheet that corresponds to a labeled name in column A. Based on this, I am trying to...

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?

Hi all First time posting and hope we have an Excel guru. I am trying to use a running list of names (below is dummy data), and then count the times the name appears: Source Name John Sally John Dave Dave John Sally Mick Resulting in something like below in a new Spreadsheet page Result...

Hi I'm trying to find a formula that where row# in Col C =1 AND same row Col A=Q1 I sum the cells in Col B from those rows <tbody> Col A Col B Col C Row A Q1 5 1 Row B Q1 2 Row C Q2 1 1 Row D Q1 6 1 Row E Q4 3 </tbody> In my spreadsheet I have to repeat...

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?

Hello All, I am fairly new to an administrative roll and am currently trying to finish an attendance track I have have started and I am stumped right now (excel novice). So basically our the two attendance rules at work are as follows; 1. You have 6 Sick occurrences to spend in a rolling...

Hello Everyone, First post here and I could use some help. Days360(7/1/2017,6/30/2018) gives me 359 days when Days360(1/1/2017,12/31/2017) gives me 360. How do I get the former to give me 360 or is there something inherently true with the former formula that will always give me 359? I have also...

Hi all, I'm working on a spreadsheet that requires me to look up payment schedules based on a property's geocode between two sheets. The tricky part, however, is that I must match three different types of payment (tax, operating expenses, and rent) for each geo code. To make things more...

Long story short for you all : There has been an update in my system at work and the beautiful data tracker that I was given to take over is not able to accurately display information anymore due to word modifications. I'm a newbie to excel too. Logic: <tbody> If column J (full of dates)...

Hi, So I am new here, and also interested in learning how to code formulas in excel. I am using excel 2016. Would you be so kind to share a formula for "Finding the third Thursday date of every month for the year 2017" Example: A1: Formula A2: input Year A3: 1/19/2017 A4: 2/16/2017 ...

Hi All, I was wondering if you could help me. I have a value in cell B2 I would like cell C2 to give a score of either 1,2 or 3 depending on cell B2 So, If B2 score was >4.9, C2 = 3 If B2 was Between 4.8 - 4.4, C2 = 2 If B2 was <4.4, C2 = 1 I'm not very good at this so I was wondering if...

Hello I'm looking to count how many times the word "forced release" appears when associated with a certain name within a date range. Name range is in column "A" Date range is in column "B" The Status name is in column "D" The date range i want to set is in column M1 and N1 please help...

Morning All I want to create a button so when I press it, it creates a pop-up window. In this pop-up, you can type a value, which will then transfer to a specific cell. In my spreadsheet, I want to change a UK Postcode, but as others will be using the spreadsheet, I need the cell to be...

Hi I was wondering if there is possible to make a TEXTJOIN formula to only pick up the name one time? Ex; A1=Mark A2=Robert A3=Robert. Then the cell with the TEXTJOIN formula should only have Mark, Robert. I have made this formula but need help with my problem :-) =TEXTJOIN(",",TRUE,O76:O81)