help

Hi all, I have this formula: =IFERROR(SUM(IF(FREQUENCY(IF($A$2:$A$101=A2;IF($D$2:$D$101=D2;IF($H$2:$H$101=H2;MATCH($I$2:$I$101;$I$2:$I$101;0))));ROW($A$2:$A$101)-ROW($A$2)+1);1));"0") It checks the following sheet (please note that A2, A3 and A4 have the same value): ' I want the formula to...

Hello, I have the below assigned to filter buttons which automatically filter a list, based on the criterial. For "office" I also need it to filter "call centre" in addition. So when the "office" button is pressed, it also filters call centre with office. Sub Office() ' ' Office Macro ' '...

Hello, Sub Reset_Filters() ' ' Reset_Filters Macro ' Resets all filters ' ' ActiveSheet.ShowAllData End Sub If there are no filters applied, I am getting the below error message when the macro is run (it's assigned to a button): And when I debug Kind Regards

Sub COOutlookReminder() Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim myRequiredAttendee As Variant Dim Address As Variant Set OutApp = CreateObject("Outlook.Application") Set OutMail =...

Hi everyone! I have been asked to lead a presentation for my company. I have a shortened list of some of our sales staff and a longer list with all staff. Is there a way to transpose a list of quarterly performance from the shorter list onto the longer one whilst keep any gaps? I am fully a...

Hi, I am a teacher and I have been given a list of students who's grades I need to have a closer look at in excel. I have a curated list of students in one column and the raw listing of the students in the next column with the associated grades after that. I want to remove all the students from...

Hi Everyone, Struggling with three different scenarios; scenario one: if Column Row says "New" return "new", scenario two: if scenario one is true, but date is less than 2/1/2023 return "transfer", scenario three: if scenario one and two are true, if balance is greater than (>) past month...

Im stuck at getting a macro to filter through some data. I have this data set; This continues for 1000s of rows, i need a macro to: Go through date/time col check for any overlaps where there are overlaps compare to ocular hazard col if both dates have ocular hazard 1 then only paste one of...

I'm trying to create a visualisation that goes back 12 months from the selected date in a slicer. Using this video - I have this code: TRI P12M = VAR ReferenceDate = MAX ( 'Date'[Date] ) VAR PreviousDates = DATESINPERIOD ( 'Previous Date'[Date], ReferenceDate...

Hello, I have a running monthly total of sales. I type the value in Column L. I have a formula which finds and returns the most recent entry. That formula is LOOKUP(2,1/(L2:L13<>””),L2:L13). In column K is the corresponding month, Jan-Dec. What I would like is for excel to find the most...

So I have PowerQuery cleaning some data and splitting it into different work groups. Works a treat, saves me mucho time and effort. But I am now getting greedy and want to push it further. Can I get PQ to: Split this into different workbooks instead of worksheets. That is rather than, say, 10...

Hi all, Relatively new to formulas in Excel and trying to figure out how to match 2 values and then check their corresponding price in the next column. In the example table below: - Col A contains Unique ID 1, while Col B contains the corresponding price for Unique ID 1 - Col C contains...

I've got some VBA code in a macro to auto-create a workbook and create a Pivot table (below). The whole thing works like a dream, and throws no errors, creates everything but I can't get it to add the row field to the pivot table. I found the script a while ago and saved it for later use, but...

I often find myself sifting through large amounts of data to identify relevant keywords, and as many of you may know, this can be a time-consuming and sometimes frustrating process, particularly when it comes to spelling errors. To address this issue, I came up with the idea of using PowerBI to...

Good Afternoon, I am trying my best to create a golf spreadsheet for a league. I am curious if anyone has a current golf league spreadsheet that contains any of these. I would love the quota spreadsheet, but would take any. I am struggling on excel creating formulas although I have had a great...

Good Afternoon, I am in dire need of help. I am not to savvy with Excel. I have been struggling and seem to find no answers on how to convert someones score to par, to points in the row below. For example in quota point system, its a lot like Stableford, but ones handicap is subtracted from 36...

Hello, So I have summed values based on week in this configuration 202301, 202302, 202303, 202304...... it is in a row. Below I have summed values based on this headers from pretty big data sheet I used sum product. My question is, I would like to have a formula which will work like that : I...

Building an excel formula that if a store is required to be open til 1am and their sales from midnight to 1am is greater than 100 then "yes" if not true then "no"

I have been getting a type mismatch error with the following code. I believe it is happening within the 'if' statement. Sub Hold() Dim c As Range Set c = Range("C2000:C2050") Dim r1 As Long Dim r2 As Long Dim x As Long Dim i As Long For x = 2 To c.Cells.Count...

I have created an excel spreadsheet showing a list of inventory. I wanted to be able to put an X in the final column to provide an easy move to the out page. This will let me know when thing are taken out of the warehouse. I have created both worksheets. I even got the code and them up and...