excel 365

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

Hello all, Hoping somebody may be able to help with this as I've tried many different solution with no luck! My issue is that I get addresses exported into a spreadsheet with all the address information put into one column. These addresses have no commas, and follow different structures to...

Hi, I just started a new job and my manager has asked me to look into an existing spreadsheet we have. It contains quarterly data from the company's call centre, compiled for a previous project that looked into assessing how call agents performed and achieved KPIs on a quarterly basis. I've...

Hello all! I am working on a very large spreadsheet and need to calculate the mean and standard deviation for each month of 2021. I've figured out the formula for the mean but the standard deviation isn't giving me the correct information. Cell References $D$1 is the year (2021) $D$2 is the...

{=SUM(INDIRECT("'sheet1'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$2,INDIRECT("'sheet1'!A1:"&SUBSTITUTE(ADDRESS(1,O1+16,4),"1","")&ROWS($M$1:$M$1)),0),4),"1","")&XMATCH($B3,INDIRECT("'sheet1'!$m$1:$m"&M1),0)):INDIRECT("'sheet1'!"&SUBSTITUTE(ADDRESS(1,XMATCH(C$2,INDIRECT("'sheet1'!A1:"&SUBSTITUTE(ADDRESS(1...

Dear best regards I am trying to get the values that are located in column B, to be reproduced in column C in the same order as they appear. The problem is that I have entered some formulas that do not allow me to obtain the values I require, and instead they always reproduce the same one...

Hi, me again as you guys are really helpful. My next question that I can't seem to figure out is there a way to auto populate a sheet every time you add a new entry to a different sheet. This is the scenario: 5 sheets that I enter information into based on their filters. These sheets will have...