entered

I need some help please! Hopefully this is possible, I feel like with Excel anything is! I need a formula that if a DATE is entered in column C, then in column B it would populate 30 days from the date in column A. If there is NOTHING in column C, then column B would just be the 30 days from...

Hi everyone, I am trying to write a formula to check for discrepancies. I want the formula to return 'TRUE' if all the non-zero cells have equal values and 'FALSE' if one of the cells has a value which is zero or a number that is not consistent with the other numbers. I tried doing HLOOKUP...

Firstly thank you for taking the time to read. I am tryingto put together a spreadsheet that has simple maths questions, subtraction andaddition. So if I have in cell A1 the number 2 and in cell B1 the number 3 Iwant cell C1 to turn green when the number 5 is entered and similarly if...

Hi all, Do you know if there is any way (without using VBA) that I can get the graph to change depending on the value entered into cell E2. A4 will always be the starting cell data for the graph, but the graph will take more days into consideration the higher the value in E2. Thanks

I have the following formula entered in cell E7 =IF(OR(ISBLANK(C7),ISBLANK(D7)),"",IF(D7-C7<0, 1+D7-C7, D7-C7)) and have another formula in cell H7 =IF(OR(ISBLANK(F7),ISBLANK(G7)),"",IF(G7-F7<0, 1+G7-F7, G7-F7)) and also another formula in cell K7 =IF(OR(ISBLANK(I7),ISBLANK(J7)),"",IF(J7-I7<0...

Hello. I've hit a snag and need to be able to create an effect similar to an if while loop without using vba. (computers at my work just delete any vba code unless I was to sit at each computer and build it for a user personally). I know I can easily do this with an If While loop but that isn't...

Hi all, Would greatly appreciate some guidance on the below IF statements. I do not have an error values but the values that it generates is incorrect. Column A: Category 1 Category 2 Category 3 No Data Entered (I wanted to put this in for a blank....but perhaps I should just leave it blank)...

Hello - I need some help with my GoT pool Scorecard. In Cell F9 I have no value entered, so I want cell G9 to Show no value as well (not -1). Any suggestions? https://drive.google.com/drive/folders/1jddqmdHp2UcKkjdO2ss_FWOscWTHquFb

Hello everyone, I have a document that is a job tracker in which different people can go in to in order to add suggestions to the tracker. I would like to leave the initial A column blank until data is entered into any of the cells within the range of B:L. Currently I have added A1+1 within cell...

I am trying to dump yearly data into a sheet then on another tab pull the info based off a name and the date entered. Column A Date Column B Name Column C through M is data to pull

Afternoon. As per title. When i double click a cell within the range mentioned in my code it should enter todays date. The code below works fine apart from how the format date is entered. So today its entered as 3/25/2019 but i would like to to be formatted & entered as 25/03/ Private Sub...

Hi Everyone, The code below is on a button which opens a table when the password is entered. I need to mask the password as it is being typed in the dialog box if someone could help me with that please. Thank you! Private Sub Command58_Click() 'Attached to On Click event of...

Good Morning, I am trying to format cells to change color when a specific number of days have elapsed since the input date. Cell A1 =TODAY() Cell C4 - J4 = Date training completed Cells C4 - G4 needs to be Green once date is entered for initial training. When date entered is 90 past, cell...

A B C D E F G H I J 30 41 37 69 46 32 40 33 What formula could I use to average the last 3 values of row A1 through J1 while ignoring the blank cells? This would have new data entered daily, so the row with be ongoing, let's say A1:YA4. As new data is entered, I always want...

So, I have a guy that wants to populate a sheet, then wants another sheet that copies the info from the first sheet. In Sheet2 the user will fill a column that will use VLOOKUP to enter all data that was entered in Sheet1. My formula in Sheet2 =IFERROR(VLOOKUP(A5,TABLE,4,FALSE)," ") The...

Morning, I have a userform that opens when i open my worksheet. I am having difficulties with the code where i press the CommandButton2 to then transfer the data ive just entered in the TextBoxes on my form to my work sheet. Here is some info to help you. The information needs to be placed...

Hi guys, I have created a worksheet that is going to be great and save a lot of time. However, there will be other users and I know will mess up my formula and have poor data entry consistency. Therefore, I have columns that limit data entry though the use of drop down boxes, but also have a...

Hi all, I have 2 columns (A&B) by 8 rows. Values entered in column A can only contain a number between 1 & 8. Column B will show a 0 or 1 depending on a cell value based on column A. An empty cell or value of 1 in column A, will always show a value of 0 in the same row (ColB). A value of 2 in a...

Hi, My issue is this. I have a sheet where I would like the first few columns to permit any text entry, it is various serial codes. I would like coloumns D - P, be limited to what data can be entered. I have made drop down boxes and ticked the box to show error alert for invalid data entry...

Hi, Please help me to write a code for the below mentioned scenario. I want to put a time stamp using =now command in VB in a range of cells (example B2:C25) and cells will be locked once the data is entered with a password and apart from B2:C25 all the cells are editable and unlocked. Need an...