c11

Hi, I'm looking for a formula that will create all possible set combinations of 5 numbers, with number from row 4, 5, 6, 7 and 8 and letter C:J. The numbers will be from row 4 in cells C4:J4 then for row 5 in cells C5:J5 and so on, last row 8 in C8:J8. Not all cells from each rows will have...

Hello, I would like a way to create a hyperlink to a specific value in a cell instead of the cell itself. As an example, Cell C11 might say RFP-WM-010 but when new rows are inserted C11 might not always correspond with RFP-WM-010. I want a way to link to specific value instead of the cell...

Excel 2007. Col A11 to A40 contain names. Col B11 to B40 contain date of birth (dd-mm-yyyy) In Col A1 I enter a date, say 10-08-2018 (dd-mm-yyyy) or =today(). My request: Col C11 to C40 to show next occurrence of birthday anniversary based on the date entered in A1. To illustrate, if...

Hello Everyone, I am looking for some help on how to write a specific sheet code and I am having a difficult time finding the right coding. What I am trying to accomplish is if a particular option is chosen from a drop down field that I have built, then the contents of cell B6 and C6 will be...

Hello guys, I've been trying to combine some codes to make a mandatory cell input before one can save the workbook. the thing is some colleagues have to input values into a cell which is normally blank or 0 before they can close the workbook as this is often forgotten.. The workbook contains...

I have tried so many combinations of IFERROR, ISERROR and not having any luck. Please help. In cell C11 contains the following formula.. =(C6/C8)/(8.91*C21) Problem is I have a 0 in the cell C21. Thanks kindly!

Hi guys, I am finding this site very useful but fully admit I have set myself a challenge that is way beyond my knowledge! I hope I can explain sufficiently. I have generic data i.e. customer, order numbers, references (total 16 entries) (Cells, C2, C3, C4, C5, C6, C7, C8, C11, O4, O5, O6...

Hello All, after your wonderfull help with another thread, I'd like to ask another question: I have a sheet where I calculate the total price of some products, but some products qualify for discount, others do not, but the total price determines the percentage of discount of the product that...

I have the following IF statements in a spreadsheet for tracking observations. Cell C11 is the date of the observation. The nested IF statement is intended to go in a "next observation due" column. =IF(ISNUMBER(SEARCH("walkthrough",D11)),WORKDAY(C11,10),WORKDAY(C11,40))...

Hi everyone First off I have to say thank you for all the help I have received so far. I could not have got this project this far without your generous help. I have a request (due to available space on A4 sheet) to be able to free type into a cell that has a formula. 1. User selects a (job)...