Forum Widgets
Latest Discussions
Rename Cell to Various Different Sheet Titles
Hi, I am trying to create a formula that allows me to have cells equal to the names of different sheets. I have read several interesting posts that created solutions for having a cell automatically change to the name of whatever its sheet is, however, I am trying to create a table that automatically fills out the rows as I add new tabs. For example: I add a new sheet and name it "March", the next column title in my table will be "March". Having to do it manually at the scale required would be quite difficult. I believe this may require the use of VBA, and my attempts to teach myself were not very fruit-full. Is this possible? Thanks in advance.
Calculate Due Dates, excluding Holidays and Weekends
Hello all! I would like to calculate a due date, excluding holidays and weekends. This is my data: The "COH Due" column is being manually entered, but I want it to be automatic. So, starting from whatever day is in the "Date Accepted" column, I want to add 7 business days to it. I'm not sure what formula I would need for that. Any help would be greatly appreciated. Thank you!
Non-linear interpolation formula
I have been trying to do this for a while but without success. There is a formula somewhere (using a power law relationship or something) but I have not been able to do it. I basically need to find a corresponding value (column B) based on an input in column A. A B 10 5 20 2.5 If the inputted value (in column A) is 15, then the output in column B would be 3.75. Any way of creating such a formula in Excel? Columns A & B hold a non-linear relationship. Any assistance would be hugely appreciated. Thanks.
How to correct "#N/A" when using Rank function and Index function
I am trying to create somewhat of a scoreboard that eliminates the lowest ranking player per level. The problem is, sometimes the players have the same score and my formulas end up showing the them as #N/A. I have enclosed an image to better demonstrate my issue. You will see in column E & F, because three players have a 0 score, the two at the bottom show up as #N/A. The same applies to the two players in Level2 that have a score of 10. I have enclosed the formulas I have been using to the right. Is there a way to correct this so that the names and their score, even though they are the same, show up? Or perhaps is there a better way to do this? Thank you so much. Any assistance will be very much appreciated.Excel Formulas not Working
The formula (J679) I have in the first image should return a value of 1 if the conditions in B573 and B638 is greater than or = to 1, which should sum the H cells. With nothing in either cell (other than the formulas in the next 2 images), the content in the J679 cell is the sum of the H cells. This can't be correct since there is no 1 being displayed. If I remove the formulas and manually insert 0's or 1's into B573 and B638 the formula in J679 works perfectly. I typed this into AI and it gave me several solutions to try. The format for those cells is General. The font and background colors are different colors (so I would know if there was a 1 in the cell by accident). Any thoughts or suggestions?Excel opens copy of file every time i click on the file and when i try to save..
I will start from the beginning to make sure you understand: I right click on the file which is protected Dialog box for password opens, but this dialog box is for the "copy file" If I enter the password for the "copy file" it opens a grey blank excel file (print screen below) After this I close the "copy" grey excel file Dialog box for the original file opens I enter the password and is all good... If I don't enter the password for the copy file, then every time I push "save" I get this dialog box for the copy fie to introduce the password.
numerar a entrada de dados de uma coluna
Tenho uma coluna (coluna A) onde tenho diferentes dados e esses mesmos dados podem-se repetir em diversas linhas, quero que na coluna B seja colocado a numeração de entrada dos diversos numeros e que quando se repetem seja atribuido o mesmo numero pelo qual entrou a primeira vez. e não estou a conseguir por a formula na coluna B. Exemplo: Coluna A Coluna B 1030 1 2350 2 1100 3 50 4 1030 1 3584 5 50 4
Table tennis tournament
I want to organize a table tennis tournament. With ChatGPT I have made the following Excel document. There will be 8 groups of 4 players. The top two players of the groups will advance to the next round, after which a knockout round will follow. I want to have an Excel file, in which I can fill in the scores of the sets. By filling in the scores, the ranking in a group will automatically be changed. After that, the Excel file should automatically indicate the qualified players in the knockout round after three matches per group. When I fill in the scores in the knockout, the Excel file should automatically name the winner for the next round. Problems: 1) With the Excel document I have some problems with ranking the players. There is no ranking. 2) In the groups the numbers 2 and 3 are going through. Not number 1 and 2. 3) There is no graphical picture of the knockout tournament. Hopefully somebody can help me. If there is already this kind of Excel file on the internet please refer it to me. I can’t upload the file in the message, so I made a link to it. https://limewire.com/d/qgcOB#ADUZcX13iV. After 7 days it will be deleted.
