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
