l11

I am using Excel 2013 In cell L11 I have this formula Address (K11,7) This returns the address in the cell as $G$45 but the row number will change each time I loop the macro In my code I want to go to that address and continue running the code. to do this, I am using this code Application.Goto...

Need some help changing the following formula to only grab unique values: {=TEXTJOIN(",",TRUE,IF($A$2:$A$20000=A2,$C$2:$C$20000,""))} Here's an example of the data (the last column is where this formula goes for each row: <colgroup><col><col><col><col></colgroup><tbody> Part Number Project...

MS Excel 2007. Columns G and J are "date" formatted, "dd/mm/yyyy. In Column K the input is either 1 or 2. For example, if column K11 is "1", L11 should display the date as in G11. If K11 is "2", L11 should display the date in J11. G J K...

hi all. is there a way to perform the following? in range sheet 2 H22:H39 look for value Sheet3 B3 and if that value is between sheet 3 L11 and M11 return 1, otherwise return 0. also, the values in these ranges are times formatted as h:mm any help would be great. thank you. EDIT..... now I...

Hello. I have the following table: Column B is a merged cell, ( 4 rows merged into once cell) I am trying to get the value 2 from column A by and value 4 from column A by offsetting the merged cell of column B x = Range("M8").MergeArea.Offset(1, -1) M8 = my merged cell so I would need to...

Hi, would anyone be able to tell me how to do the following: If cell L11 is more than or equal to 20, I'd like cell G8 to be green. If L11 is not more than or equal to 20, I'd like G8 to be grey. I can use the '=if' function to change text in G8 if L11's condition is met, but cannot figure out...