row above

Hi I am trying to apply a formula where I need to refer to a few cells to the left of the formula cell and a few cells to the up and apply the formula down the column for quite a few rows. I am trying to achieve the result by using offset function, but I am not getting the desired result...

Hello, Im not great at vba so im looking for some help. Im looking say if in column A, Delete the row above if date value in A1 does not match the date value in A2 <tbody> a 1 <tbody> 8/1/2019 9:16 </tbody> 2 <tbody> 7/22/2019 21:04 </tbody> 3 <tbody> 7/22/2019 20:55...

Hello, I have a table of Visit information for various customers. I need to identify what we consider as our customer, which means that if the customer visited our store (Store1) In the Table below I need to get the column OurCustomer <tbody> Customer ID Store Visit Date Store1 OurCustomer...

Hello, I am trying to find the top row value that matches the criteria from three left hand columns and a value in the table. There is a value, an annualized number value, that is used to find the value in the table. The value in the table is to be the closest less than value to that annualized...

hey guys!, so i was having trouble figuring out a formula in vba which copies a whole row to a different sheet. for example, I have a list of names and data in a sheet called "data" what I want it to do is 1.) check the names in column 4 against data in column 4 of a different sheet called...

Hi guys I use this code but I still dont get the first cell in the same column and row 1 see code below: Sub Langauge_Combination() For Each sht In ActiveWorkbook.Worksheets Set Rng = sht.UsedRange Set MyRange = Rng For Each MyCol In MyRange.Columns For Each MyCell In...

<acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> to insert images from file path Basically I have an Excel...

I have a dilemma and can't think of a simple solution, although I am sure there is one that I just can't see. If C5 refers to the value in cell C100, C6 refers to the value in C110 ten rows below. C7 refers to C120, ten rows below that and so on. Is there a formula that you use within excel...

Help is needed and suggestions will be appreciated! Working in 2010. I have about 500 rows of data which group into 136 subsets. Each time I use subtotals, it groups correctly, but it does not retain the name of the subgroup in the total row, thus I have to "copy" down (directionally) the row...

Hi all, hope someone can help me - it's quite urgent and i'd really appreciate some help. I am using a VLOOKUP and MATCH formula for a survey: =VLOOKUP((MATCH(100,'2. Upwelling-downwelling'!H26:H38, 0)),'2. Upwelling-downwelling'!C26:K38, 3, FALSE) It is designed to look in the worksheet...