Forum Widgets
Latest Discussions
Stop Autofill from Incrementing Certain Cells
I am going to try to explain this the best I can. Please, be patient with me. It might take a few attempts when it comes to properly describing things. Thanks! I am making a spreadsheet that keeps track of the ages for characters in a series I am writing. There are MANY characters, each one with a different birthday. Each story takes place for a different date and year. Right now, there are about 40 periods of time, and those are at the top of the spreadsheet. So, I basically have a character name, their date of birth, and then the subsequent cells calculate how old the character is for that period. When I try to use the auto fill, it increments the cell so that it no longer uses the correct cell. In essence, it tries to use the cell next to the date of birth cell. It does the same thing when I try with the column as well. So, how do I get the autofill to use a static cell horizontally while incrementing the cell vertically? Or the other way around?Macro for overdue expense card reports
Hi. I am trying to figure out a macro that will allow me to use data provided to create a system that allows me to see people who are late submitting their expense card reports. I would like to break it down so that I can see those who are 30, 60, and 90 days past due on submitting their reports. If there is anyone out there that can help me to automate this system rather than manually entering it I would greatly appreciate it. Thank you and have a nice day.
Match/Index referencing incorrect row
I have a spreadsheet that I am working on in MS365. On sheet "A" I am drawing the following information: AGE (=G63) into cell S65 Weight Lifted (=F68) into cell S66 From sheet "B" (Reference data) Row 2 are the age categories (17 - 21, 22 - 26, 27 - 31, 32 - 36, 37 - 41, 42 - 46, 47 - 51, 52 - 56, 57 - 61, 62 Over. These are grouped as MDLAGE. Column A are the scores - 100 - 0 descending order. these are grouped as MDLPOINTS In cells B3:K49 are the weights lifted. The values vary by age and there are cells that are blank or have a "---" in them. These are grouped as MDL. The formula I am using is: Cell S67 - =MATCH(S65,--LEFT(MDLAGE,2),1) This formula is returning the correct column. Cell S68 - =MATCH(S66,INDEX(MDL,0,S67),1) This formula is referencing the INCORRECT row. It is returning row 40 instead of row 31 which is where the correct weight is listed. If I change the 1 to a 0 or -1 the return is N/A. I have tried multiple formulas to "skip" the blank or --- cells but nothing has worked. Any help would be greatly appreciated!
liste deroulante pas d extrait des donnees
Bonjour j ai bien ma une liste derourante (227 articles) dans ma cellule mais lorsque je rentre un nom dans cette cellule j ai le message cette valeur ne correspond pas aux restrictions de validation des données pour cette cellule. Le pb c est que je n ai pas de restriction. Quelqu un pour m aider SVP. Merci
