Search results

This sort of thing might be interesting to the likes of credit card companies, or those paying off debt/credit. People don't always pay the entire outstanding every month and the credit card companies charge different rates of interest at different times for various outstanding amounts...

looks like @Deepak_S lost interest…

ws.Range("A1:A" & lastRow).AutoFilter Field:=1, _ Criteria1:=">=" & CLng(DateSerial(recentYear, recentMonth, 1)), _ Criteria2:="<" & CLng(DateSerial(recentYear, recentMonth + 1, 1))

It might depend on how you want the scale to read: If like the blue line, one of AliGW's formulae [or =ABS(C6:C366/6-30)-15 ], if like the orange line then in D6: =COS(C6:C366*PI()/180)*15 or in older versions of Excel: =COS(C6*PI()/180)*15 copied down.

Try: To replace current formula in H9 (=C9): =SEQUENCE(,16,C9,(D9-C9)/15) and delete the formula =D9 in cell W9 You can copy this formula down one cell to get the percentages. In cell X9: =SEQUENCE(,15,D9+(E9-D9)/15,(E9-D9)/15) copy down. Delete the formulae in column AL I do not understand...

=TAKE(DROP(TEXTSPLIT(A1,","),,-1),,-1) or =LET(a,TEXTSPLIT(A1,","),INDEX(a,COUNTA(a)-1))

I'm having great difficulty understanding how you reach your Table-2 figures. So the following is a guess: I'm taking your invoices in date order, earliest first, then I'm looking for payments made after that invoice date and using them to pay that invoice, using as many payments as is needed to...

Is this correct?: Date Invoice Amount Payment received Amount Balance 21/03/2022 90,098.00 90,098.00 03/11/2022 -106,376.00 -16,278.00 14/11/2022 1,467,993.00 1,451,715.00 16/06/2023 -56,872.00 1,394,843.00 11/07/2023 -1,595.00 1,393,248.00 25/09/2023 50,951,006.00...

In D2 of Details sheet (also in D1 add the header, whatever you want (Flag?)): =IF(ISNUMBER(MATCH(A2,Students!$A$2:$A$4,0)),1,"") copy down.

Try =MATCH(A1-0.00001,{-0.00001,0.2,0.4,0.6,0.8,1},1)

=XMATCH(A1-0.00001,{-0.00001,0.2,0.4,0.6,0.8,1},-1)

See attached. Click on cell F2 and choose a Month/Year, refresh the results table. If you choose a month/year in the future and there is no data for the month-to-date or for that quarter those columns will not show in the results table. If you want to see those columns with 0 values you need to...

In the attached, results table at cell Q5. Change the company table at cell B1 by say adding companies, changing company names, changing percentages then: right-click somewhere in the results table and choose Refresh to see the table update itself. The month/quarter/year to date are the current...

In the linked-to workbook below: Only your DATA sheet A results table at cell E1 A copy of your 'desired result in the "END" tab, between columns "E" and "G" ' at cell I1 (values only so that I could sort it and the results table in the same way to demonstrate similarity). This is a Power...

Also =(D2-C2+(D2<C2))*24

In the attached: 1. Your source Table1 minus its calculated columns. 2. A new results table at cell K1 which is the same as your table plus 4 columns: Call duration Count - the count of other incident numbers overlapping this one total overlap - the sum of all overlaps with other incident...

On Sheet3 of the attached workbook, a Power Query solution. It uses only the 3 columns of data in columna A,B & C (calculating the duration for itself). The result table at cell I1 has the column Overlap which is the sum of all overlaps for that row with all table's rows for that Unit. The...

Difficult to say, best attach your actual workbook with code so that we know where all this code is. At first glance, and a big guess, there's a line: lastRow = ws.Cells(ws.Rows.Count, "C").End(xlUp).Row which might well cause such an error since ws hasn't been set at the point it's being used...

Power Query solution in the attached. Note only raw data in the source table on the left. Play with adjusting the numbers in that table (I played with the red highlighted ones) then right-click somewhere on the right hand table and chose Refresh to get an updated, sorted snfd rsnked results...

Not a vba solution in the attached but… A formula in cell AC2: =LET(res,C2:AA2,seq,SEQUENCE(,COLUMNS(res)/2),LARGE(res,seq)+SMALL(res,seq))which can be copied down. This formula spills to the right. I've added headers in row 1 to give an idea o what each column represents: H+L_1 is the 1st...

H1: The first part of that question is Time wasters, so based on duration of calls the 4 worst (in order) are C0010 C0014 C0008 C0003 The second part of H1 is which customers call most, so based on the number of calls the 4 worst (in order) are C0008 C0010 C0002 C0014...

Not sure if you already have your answer but try in cell D6:=SUMPRODUCT(($E$4:$BI$4<>"")/COUNTIF($E$4:$BI$4,$E$4:$BI$4&"")*($E6:$BI6="Y"))and copy down. Test thoroughly; I haven't.

=GROUPBY(HSTACK('Sales Data'!$K$2:$K$163,'Sales Data'!$A$2:$A$163,'Sales Data'!$J$2:$J$163,'Sales Data'!$L$2:$L$163),'Sales Data'!$G$2:$H$163,SUM,3,0)

Pivot: