excel 365

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...

Hello All, I am trying to get a Index Match formula to work on my sheet Currently I am trying to use the following but its not working. =INDEX(NewDemand!$A$1:$CA$55,MATCH($C$1,NewDemand!$A$1:$A$55,0),MATCH($E18,NewDemand!$A$1:$CA$1,0),MATCH($O$1,NewDemand!$Q$1:$Q$55,0)) First Sheet...

i have two cells, which should contain same value but one in text format another in fraction format. Only then excel sheet works, otherwise part of the excel sheet doesn't work. I want only one cell to be drop down in among those two. Please help

Dear All, I really need help, I have checked on internet but can't seems to find an answer for my problem. Basically I am looking for formulas where new Expense category will be added (not that frequently) in rows and in the columns new months will be added and a graphs will be linked to the...

I have an Excel sheet where columns A and B need to be visible always. I have some range C to O Q to AC AE to AQ AS TO BE BG TO BS BU TO CG CI TO CU CW TO DI DK TO DW DY TO EK EM TO EY FA TO FM FO TO GA GC TO GO GQ TO HC HE TO HQ HS TO IE IG TO IS IU TO JG JI TO JU i need When I will select...

Hello, Recently I came across the post by @Jaafar Tribak and was able to implement a FormToTaskBar in Excel. However, it was not possible in MS-Word 365. Would anyone know if that code was supposed to work in Word too? If the code doesn’t work for Word, would anyone have that adaptation made...

So, I have been tasked with a reconciliation project in which I have to reconcile the Financial Managers from Screenshot 2 to update the Managers from Screenshot 1, in order to add the corresponding fund category (shown in screenshot 1). The current list (Screenshot 1) will have additional funds...

I was basically working with XLOOKUP functions and I need to be able to pull data from two separate tabs. My goal is to automate this process as much as possible to avoid the need for all those manual adjustments with each XLOOKUP and reference cell change. I have got: In Row 1, I'm using the...

Is there a way to make an PivotTable filter permanent? I.e., prevent or discourage users from removing a filter from a PivotTable, since bringing in that intentionally excluded data would cause confusion. The data source is a Microsoft Query Connection to an Oracle database. So in theory, I...

I have a rather complex Excel workbook with many complicated array formulas, pivot tables and charts, and macros that I share on Teams using the Excel co-authoring capability. Of course, since the workbook contains macros, my concurrent users are opening it in the desktop app. The workbook...

Hi Guys, Pretty new to excel so hoping there's a simple answer to this that I'm not aware of. I work in marketing insight and part of my role is selecting the best customers to send each of our direct mail campaigns to, and I want to create a workbook in where I can walk through our monthly...

Hello all, I have a wide range of employees data, I have been using normal Xlookup to get the Person Number by looking up the Employee name. However I came across case similar to the example below, there is a two idfferent employees with two different Person Number, but have the same exact...

Hi all, Would like to get your support to solve below issue. Thank you in advance :) Condition As long as the date in row 1 less than today => fill in grey If the date in row 1 = today => fill in blue If the date in row 1 > today & data is not blank => fill in Green Result by myself I've...

Hello dear friends The following code I put together using Excel 365 and it runs fine on my computer (windows 10). When I try on a different windows 10 machine having excel Office, it gives the following error message Application.Goto Reference:="Info"...

Hi All Using MS Excel 365. Making VBA code to work on a table of data. Code has applied a filter to the data and now want it to fill all cells in a column "E" with a text flag value "Y" I can have my code go to the column header but cannot then activate the first filtered cell below in order to...