spreadsheet function

I am trying to get the index of each sheet in a workbook. For test purposes I have a work book with 5 worksheets named "test", "2019 Budget", "2020 Budget", "2021 Budget" and "2022 Budget". On "test" sheet the names of the the 4 budget sheets are listed in A1:A4 I want to calculate the SHEET...

Hello Everyone, I am new to excel and looking for some help in identifying ways to pull "Turn around time"between two dates. But that is not all it needs to fulfil multiple conditions on different column for example Year in Column A ,Month in Column B, Data Validation in Column C We dont have...

I have an excel which contain approx. 25 spread sheets. One sheet is for data entry and 5 sheets showing the result. On other sheets there are lot of calculations. So to track down the output value of particular cell, to find where it came from i have to go through various sheets to reach at its...

Hi, Im feeling really stupid since i can't figure this out. Ill explain and post some Pictures and hopefully itll be clear enough that some genius can help me. I have a workbook that i use for recording service jobs. So its pretty simple looking: i have a few colums with Customer, Typ of job...

Hello! I have a macro that asks the user through a message box to accept or reject the changes made by the macro. However, the excel sheet that needs to be reviewed to accept or reject those changes is fairly large and the user cannot see all the changes without scrolling though the page...

I have a spreadsheet with an Access query that returns data by date. The query returns an "x" in a column next to each date where a match is found in another table in the database. In Excel, I'd like to replace the x's with the result of this function: =percentile.inc("D:D", 0.90) I figure...