excel formula 2010

so I have a spreadsheet that has 8 columns. In the first column is a date of 1st payment, the next column is amount of 1st payment, the third column is date of 2nd payment, four column is amount of 2nd payment, The fifth column is date of 3rd payment, six column is amount of 3rd payment, seven...

I have a large set of data where there is a blank row after each unique cell value in column N - sample showing below: I am after a formula or VBA which will fill each of those blank cells in column N with the same value as the cell above it, but marked in bold. e.g. Is someone able to help?

I have a pattern of 25 cells (in column B) that I need to repeat many times over in the same column. The pattern is showing below: So essentially it will look as follows (ignore the colours please - just for ease of seeing the pattern): Thank you in advance for any help that can be provided.

I am in need of assigning a re-occurring number sequence to a large data set, based on cell value. A small sample of the data set shows below, in column A: I need to generate a re-occurring number sequence in column B, like showing below: So in column A, for every entry of AX1002, the...

Hi, I have a question to find the staff value of the latest production date for the same product. I know how to find the latest production data by using max and if formula. But I would like to ask how to write the formula to get the staff name of the latest production date with the same product...

hi Friends, i am trying creating a formula where IF and AND functions matched then vlook up however not getting the desired results . I want IF Cell A4="First",And (B4="Track 1", then look up value populate the scores unfortunately when i am running the formula it says A4= First and B4 =...

I am looking for a formula in Excel that will always show 4 days from the original due date and is always in the future from today's date. Let's assume in this example that today's date is 4/4/2018. I would want the formula to let me know that I need to send a letter on the 6th. <code...

<tbody> =INDIRECT(ADDRESS(65,20,1,1,VLOOKUP(C$4,FILELOCATION,2,FALSE)&C$4&$B$2&".XLS")) I created the formula above to pull info from a source workbook(dynamic name) into a summary workbook. Source file name will be dynamic plus I will have 10 source files to pull into the summary workbook...