1. S

    Excel repeat each element in a row x times in individual rows

    I consider as a simple MWE an Excel table that contains 7 (columns) and 3 rows. I try to repeat each element x times, so that the last column in this row runs to the last column in the entire table. The number of repetitions in each row is therefore determined by the last column in that row...
  2. moonsugar

    Could I have some help with this project? Repeat a set of cells down the length of a column

    Hi there! I've been using Google Sheets for some years, and have just come back to Excel for the first time since 2007. I've just spent perhaps the better part of an hour trying to search for what I'm trying to accomplish, with no luck. Somehow I've managed to do it before a few times, but I...
  3. F

    Repeating macro without overwriting

    Hi Guys, i have a macro that inputs data from one sheet to another and have been trying to get it to repeat based on a cell value everything. as i want this to create multiple lines every time it loops it just overwrites the first line was input. Dim lRow As Long Dim ws As Worksheet...
  4. A

    Repeating macro for each cell in A (with offset)

    Hi everyone! Right now I'm having troubles with how to repeat my macro for each cell in A. I have some offsets so it becomes very confusing. Here is my code. I recorded the macro while ticking 'Use Relative References' on. Hopefully someone can help me. Thank you very much in advance :) Sub...
  5. D

    Data Validation VBA Input Message

    Hello, I have a large batch of data. There are 5 different types of data. Every 5 rows, there is a new set of data. I am trying to implement Data Validation Input Messages so that when a user is on a certain cell, they will know what type of data is being referenced. Not sure if that makes...
  6. G

    Systematically add 150 more rows every 51 cells down

    I have a sheet that has groups of 50 rows with a row to separate each group from the next. I would like to increase the amount of rows in each group by 150 (a total of 200). So starting on cell ("D55") add 150 rows above D55:AA55, then go down 51 rows and repeat for cell ("D106") [add 150 rows...
  7. S

    Compare each cell of a row with another row from another excel file

    So, hey people. Thank you for reading this and for putting some thought into it. I have a long line in an excel file, let's call it X, that I need to compare it with another line from another excel file, we'll call it Y. The thing is that the Y line has the same first 6 cells as the X one...
  8. V

    Difference in date

    I have this records below If the “PROJECT_NUMBER” is repeated AND “INCIDENT_CREATION_DATE” between the two incidents is less than 31 days then mark it as a "repeat" I am confused as how shall I do it, as did countif as well to find the duplicate and then the diff in date but the records can be...
  9. A

    How do I use this to repeat Column n times based on number in table?

    I hope this is possible, but I want to be able to repeat column headers n times depending on the table below. I would just put the formula on the far right on the same row, but hoping it would come out like the bottom picture. Thank you if you know how to do this! Example of output:
  10. P

    Repeat Macro

    Hi All, Been looking all over the place and cant find an answer to the following I have this simple macro and want it just to repeat constantly with it never stopping Sub refresh() ' ' refresh Macro ' ' Calculate End Sub So wondered if someone could assist at all please???
  11. M

    Shorten Formula =IF(D8=5,L8,0)+IF(D9=5,L9,0) repeat unto row 209 +IF(D209=5,L209,0)

  12. L

    Develop a loop based on a tables characteristics

    I need assistance to develop a loop based on these 2 tables below. The first row contains the values that will repeat along the table. For the first table each value will repeat 04 times. For The second table the values will repeat 05 times. Table01 <tbody> A B C D E F G H I J K L M N O A...
  13. M

    vlookup help, can this be done? (cells in J&K filled with info from G&I if data in C is a repeat)

    ok, I am sure I was doing something stupidly simple wrong. but I need to get results based on an entered data point. example in the spreadsheet: enter data in C16 search column C for the first repeat of data starting at current entry(C16) if found(C9) pulls data from column G(G9) and enters...
  14. G

    VBA Repeat cells

    How would I turn: A1 A2 A3 Into: A1 A2 A3 A1 A2 A3 as many times as I want into a different sheet?
  15. R

    IF Function ignoring NA

    Hello guys, I am currently processing a huge dataset. My question is that how can I ignore NA when I want to run and repeat this function in excel. =IF(AND(RankLN!D45>0.3,RankLN!D45<=0.7),"M",IF(RankLN!D45>0.7,"W","L")) In detail, for example, I have a column, we say column D. In this column...
  16. P

    Indent text

    I have a spreadsheet where text in column D may repeat several times. The repetitions will always be grouped together. I need to look at the entries in column D and when they repeat I want to indent them five spaces. So the first occurrence of a text value will be left justified with no...
  17. A

    Analysis, Functions and Formulas.

    Lets say I have a table of three or more columns and rows with a number in each cell ranging from 1-25. I want to find every row that has two numbers that repeat in other rows. I'm not sure which to use, Match? Lookup? Offset?
  18. A

    Excel Formulas and data analysis

    I want to find row in which three numbers repeat in other rows. How do I do this? Thank You In Advance.
  19. S

    Tring to get VB code to automatically scroll through a table.

    Hi. I have VB code that looks at a table connected to a form and runs a macro ("ApdTabtoTotalTest"). I have it set up to go to the next record. It works, but the issue is that I have to manually run the code for each record. There are around 150 records. So I click a button and it runs. I then...
  20. B

    Repeat a value or number in a sequence multiple times.

    I have a list say: A,B,C,D,F (IN COLUMN A) I want the user to select a member of the above list in column B1 and say how many times it must be repeated in column C1. The extracted list can now follow in any other column (a multiple of times say 2) Example. User selected A Repeat 3 List 2 times...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back