essentially

Hello. This forum is absolutely wonderful and I have learned so much- so Thank You All. I have one last code to finish a spreadsheet I have been working on. I am attempting to write a code that checks column B (which contains dates) and if all dates in that column do not match then it should...

Hiya guys Im after a formula that essentially does a sumproduct but instead of multiplying i want to take away ie im after =sum(B2-A2,B3-A3,B4-A4,B5-A5) etc

Hi Everyone, I'm sort of a VBA n00b, so please bear with me. I'll even just take a nudge in the right direction. Essentially i'm trying to automate changing a slicer value based on a cell value. I'll do this by initiating macro1 as follows: Sub Macro1()...

Hi Team, I'm having a (what I think) very simple SUM issue, but it's a Monday and I can't work it out! Effectively, I am trying to do a COUNTIF and SUM in one. My COUNTIF is as follows (and works, no issues there): =SUM(COUNTIF(INDEX(Data!$F:$AO,,A2),"Strongly...

Hello, I pulled a lot of data, and I need to mark which one is the most current. Is there a formula I can use to do this? Someone told me I might need to use an array formula. Essentially I am trying to get a formula that will print the text in yellow in the picture. https://imgur.com/a/RDJYrSO

I am trying to write a statement that essentially says if cells N14-N19 = either Y or NA count it as Y.

Veyr very new to BI and need to learn quickly... I am using the visual: 'card' (So it is populated with a specific number D6) and I would like to click on this visual and to be sent to a different page (Also titled D6) with in the report. Is this possible? Essentially I have 4 different...

I have two sheets: sheet 1 contains a list of orders in ascending order. Sheet 2 is supposed to extract the last order number in sheet 1 and increment it by one. This is what I have come up with: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit...

Hey all, Sort of a novice to excel here... I'm having a huge amount of difficulty getting excel to understand what I'd like. Essentially, I want to take data I input into three separate columns and have it inputted into an equation. The equation is 0.5(4/3*(pi*a*b*c)). Four-thirds multiplied...

I need help writing an IF statement and I'm sure it should be pretty easy, I just cant seem to make sense of it at the moment. Essentially it needs to say if any cell F2 - O2 = N then make cell P2 N if not make P2 Y.

I'm using the below code to delete blank rows in a range, but it is producing an error if there are no blank rows to delete. I already have an error routine built into the macro which sends me an email on an error, so I don't think I can use On Error GoTo 0 aswell can I? Essentially I would...

Hi Guys, I've been using excel to allocate work equally. Up until now this works ok but the formula i am using essentially looks at a list of work, looks at the staff members in the list called Blue Team Names and allocates out evenly. There are 2 tables below. To give you an idea the below...

Hi all, new to here but I need some help and was told that you guys may be able to help me. Essentially I am trying to move data from one sheet to another in the same work book, but in a particular way and my coding skills are little to non existent. Essentially I have a drop down with weeks...

Is it possible to write a function for conditional formatting that addresses numeric data in one column (H) and alpha data in another (G) and then format the adjacent cells accordingly? Essentially what I am trying to do is look at column G for the term "Overscheduled" and then column H that it...

Hey everyone. Just wanted to started saying off by thanks! This forum has been invaluable whenever I am looking for solutions to problems. This time though, I'm having trouble finding a good solution. I have some poorly formatted data that I would like to be able to index, so I am trying to...

The formula in DN2 is: =LEFT($B2,7)&"-"&$C2) The formula in BV2 is: =IF($B2="","",VLOOKUP($DN2,Specs!$A$2:$K$500,9,FALSE)) What I am trying to do is combine them so that I can get rid of column DN altogether. Essentially trying to make a formula that operates, similar to this attempt...

I'm playing around with different systems which haven't been mapped properly. Essentially I'm trying to see if data in one system exists in the other, and if so what the fields would be called. Once I get all the data into Excel, is there a way to see if data in group A exists anywhere in group...

Good morning, I'm looking to have a macro stop my copy to word macro if a certain amount of cells are not filled in. Essentially, people need to fill out mandatory cells, so I implemented a simple =IF(COUNTA(E4,E5,E9,E10,E13,E14,E19,E32,E33,E35)<10,"Mandatory Cells Incomplete!","Mandatory Cells...

Hi. I'm wanting to copy a formula down a column following a pattern, but obviously just by dragging the formula down the cells underneath doesn't work. Ive seen a few examples but I'm struggling to understand them. Essentially I want the sequence to be as follows: ='Sheet1'!A1 ='Sheet1'!A3...

Hi, I have a rather sizable table w/ data (~60 columns, ~5000 rows) each w/ 1s and 0s. I would like to count the number of 1s that occur concurrently in each column. So each column is a unique variable, and each row is a day in a time series, and I'd essentially like to be able to count the...