excel 365

Hello, I am currently experimenting with the combination GROUPBY + Slicer, as Mike Thomas shows in the video on YouTube, but my combination is not working as desired. Maybe I just have tunnel vision and don't see the ‘problem’. Hence my request for help. Below is the screenshot with the slicer...

Hi all So I'm sure this is possible and I've tried a few things but for the life of me I cannot get it to work. I need to insert a locally stored image file (C:\Users\My Name\Documents\My Database\Scans) which will change depending on the value of a cell (B3). The image will always end in...

Hi everyone 😊 I still have a lot to learn about DAX and have become stuck trying to develop a measure that will filter down my source table to a single row by using values in two columns and return the (text) value from a different, specified column. I have two measures that filter a table and...

Dear All, I am looking for a DAX code in Power Pivot (Pivot Table) to calculate Run Rate dynamically based in the months selected. The Run rate calculation should always exclude the latest month. There are many (100) Account codes, so the Run Rate calculation is required for each account code...

Dear All, I am trying to do a Vlookup with if statement in Power Query but unable to. in Excel I have done in this way --> =IF(P3="Recruited",VLOOKUP(AA3,'Sheet1'!A:B,2,0),) Please if you could help me on how to do this in Power Query? Many Thanks.

Hi, Need to count any numbers from a 2D array if it is standalone in a horizontal row - formula needs to work for whatever column its in Ex: COLUMN A COLUMN B COLUMN C COLUMN D 25 94 83 92 78 32 56...

Hi, I have an array full of prices and 1 date column. I need to display the most recent value of each row's array that are all equal to today's date. I plan to sum all the numbers eventually. Ex: TODAY'S DATE: July 4th 2024 04-Jul $14.00 $45.00 78.00 18-May $63.00 $86.00 $92.00...

I am trying to Copy from 1 workbook (S.xls) and pasting into (PD.xlsm). However I also get the same error 1004- Application-defined or object-defined error at this line "lastCol = sh1.Cells(1, Columns.Count).End(xlToLeft).Column" Sub Rectangle1_Click() Dim sh1 As Worksheet, sh2 As Worksheet...

Dear All, I have a workbook (Transactions) in a folder which is connected to another source file using power query. The original source file has 200 columns, so the power query is used to do some transformation on the "Transactions file" to get rid of most of the columns and for other...

Dear All, I need your help to come up with a formula where it should pick the Total sales based on two criteria. 1) Month and 2) Customer Name. The total sales row is after every two products within their respective tables. If a new product is added, then in each customer table will have all...

Dear All, I am pulling data from 3 different sources using power query. I need to do reconciliation whether the hours worked are matching from these sources. Below are the headings of each source. Table 1: A/C Code - Employee No - Month - Hours Worked Table 2: A/C Code - Employee No - Month -...

Dear All, I have a table1 in sheet 1, on which I paste data from a table2 in sheet 2. Sheet 3 is the summary sheet, which have formulas referencing to table1 in sheet 1. The problem is, if I paste data in table1, the formula does not work on Summary sheet. But if I manually type in table1 then...

Dear All, I have a 3 sheets in a workbook with many slicers and it is pain to clear them one by one and then reselect every time to do various analysis. There is only one/two slicers that will have fixed values. I am looking for a VBA code, which will be assigned to a button. on clicking it...

Dear All, I have a workbook with many sheets with multiple slicers in each sheet. I am looking for a vba code that is assigned to a button, on clicking it it should hide all the slicers and again clicking it it should unhide. The button text should change based on slicers current status...

Can anyone help me with this issue? I have a HUGE report and in most cells in the description column, there are repeated words that I would like to remove. I have been digging through the web trying to find a way to accomplish this through either VBA or a function and have had no luck. Here...

Hi all, I have a range of cells that contain negative and positive values plus 0. I am trying to return for each row the minimum value in the range including only those > 0 and excluding the current row. I have managed a solution by returning the minimum value before the current row and that...

I have a sheet with 6 check boxes, i have the below formula that will complete a Vlookup when the check box is ticked, what i now need to know how to do is adapt the formula to complete Vlookups when several check boxes are ticked, and then put the result of the vlookups into one cell. This...

I have a table set up like a check register. I have a date column names Date with full date ie 12/15/2023. I have a slicer set up for date, but want to limit it to only the month, not each individual date in the register. So, I set up another column with Month. The formula in that column is...

Long story, but was having problems with Excel Mac 365 (Big Sur) and Excel support said to dload Excel 16.77 which they say is the latest for Big Sur. All is OK EXCEPT for the fact that when opening a new Excel spreadsheet that opens by default to A1, I CANNOT type in A1 unless I click the cell...

I have two tables one in B1:G1 and the other in L1:T1, both go down hundreds of rows. If I only had one table I could delete a row, but it seems if I have two tables I can't delete one or more rows. I need to delete the row from BOTH tables, not just one of the tables. I saw some VBA to...