b11

Dear Sir and Madam, Need your suggestion on how to shorten this formula ? The data range is from B11 to B21, at the moment I had to manually add in one by one...

hi all I haven't found anything yet that can help me do what i need. Hoping someone may have the answer. I have B11 setup with a drop down list of peoples names. In range D11:IS11 are those same names. i would like a macro that searches D11:IS11 for the name in B11 and if it is found, hide...

Hi All, Can someone help me please. Below is what i'm trying to do. 'When user inputs value into B10 on the "Calc" sheet, the system will find the same value (or similar value If it doesn't exist) from Column B on the "Data" sheet. Then the data of Column C will be displayed into B11 on the...

Having in A11 digit 1909 and entering in B11 formula "=SUM(VALUE(MID(A11,ROW($I$1:OFFSET($I$1,LEN(A11)-1,0)),1)))" with enter and shift, display in B11 digit 19 then entering in,C11 formula "=SUM(VALUE(MID(B11,ROW($I$1:OFFSET($I$1,LEN(B11)-1,0)),1)))" with enter and shift, display in C11...

This one seems simple but gets hairy as it goes on: I have 2 columns of 182 rows of data (A + B) I need to copy 2 rows of existing data (b10 & b11) ahead of each B cell containing current data. I need to insert 2 blank rows below each A cell with current data. This is what I have (Ignore...

I'm struggling to come up with a formula to do this. Can anyone help? OLD SHEET: B9: Contact 1 B10: Contact 2 B11: Contact 3 NEW SHEET: C5:9 are merged and I need B9 to populate from the old sheet C10:14 are merged and I need B10 to populate from the old sheet C15:19 are merged and I need...

I have data at 200 cells in column A starting from cell A11 ending at cell A210. At column B there are data at 30 cells starting from B11 ending at B40. The cells of column B have a connection with cells of row A. Cells B11:B30 should be every 10 cells in column A, this means B11 should be one...

I am looking for something within a VLOOKUP formula. I have the VLOOKUP searching using the data in cell B11 and it works fine, but what if cell B11 is empty and the data needed to search is in cell C11 or D11 or E11. Is there a way to tell VLOOKUP to check a range of cells if the original...

Hello Everyone I am pulling a blank and need help. I want my if statement to do the following - If cell A11 = TRUE Return "BLACK" If cell B11 = TRUE Return "WHITE" IF...

Hi Everyone, I'm looking for a macro that can add the name in column C of the active cell into Sheet "Projects" range "B11" So for example if i click on cell H27 it would use C27 but if I click on GU15 its still C15 please help if you can. Thanks Tony

Hello all, i need some help with a formula. In column B i'll enter a value, depending on that value, column D will give me a rate, either "Free, B, C, D or E" So what i want the formula to say is: If B11 is less than or equal to B9 then "Free". If B11 is between D9 and E9 then "B Rate"...

I'm looking for a formula that will provide the following result: If b9= selection "a","b",or "c" and b11 is populated then result would be "ok to save" If b9= selection "D", then look for B20 and if it is populated the result would be "ok to save" otherwise result would be "not ready to...

I'm using the following formula and getting a #value error, =IF(ISNUMBER(SEARCH("",B15)),ROUNDUP(B11/4,"")) I need the cell to reflect the number in cell B11 divided by 4 then rounded up

Hello, I am trying to add an extra condition into my formula but I can’t make it work. So far, what I have is this: =IF(C28=B11,1, IF(C28=B11-1,1, IF(C28=B11-2,1, IF(C28=B11-3,1, IF(C28=B11-4,1, IF(C28=B11-5,1,0)))))) Which is basically saying, if C28 is equal to or less than B11 by up...