fill series

  1. C

    Auto incrementing a network path

    Hi Need help with auto incrementing a network path in excel 2010... for example: column B contains a random list of numbers starting at cell B2 and going upto B101: A B C D E 1 2 234 3 239 4 111 5 553 6 312 7 876 8...
  2. S

    Cell contents separated by dash"-"

    Hi, I have cell which contains C45-C90, I want it to split into multiple rows and fill in the form C45, C46,C47...C90 For example: <tbody> colA ColB C45-C50 0.6 C99-C101 0.5 </tbody> Expected Result <tbody> Col A Col B Col C C45 C45-C50 0.6 C46 0.6 C47 0.6 C48 0.6...
  3. T

    Advanced Fill Series

    I am trying to auto-fill down same formula with only reference changing to cell T3. However, all other references increment +1. How can I keep all references constant while only incrementing T3 cell +1? (T4, T5, T6...). <style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font...
  4. C

    Can't work out how to drag fill formula series.

    I have a spreadsheet where the headers in each column are increments of todays date as below - <tbody> =today() =today()+1 =today()+2 =today()+3 </tbody> To extend this series across the worksheet I selected the last two cells and used the drag handle in the bottom right hand corner...
  5. K

    INDIRECT and horizontal reference to vertical fill

    I have a large spreadsheet with several sheets. Sheet1-Sheet5, have data running across horizontally on every other column (a1, c1, e1, etc.). On Sheet6, cell A1, I need to calculate the sum of A1 on all previous sheets. However, I need to drag the formula down so that A2 calculates the sum...
  6. M

    Conditional Fill Series?

    Hello everyone, I am new to the forum and would like to thank anyone in advance for their help. Firstly, I was able to get this formula working ;) yay!! =IFERROR(VLOOKUP(C2,'Etilize_ProductRichContent (ALL'!C2:C3171:'Etilize_ProductRichContent (ALL'!E2:E3171,3,0),"") Now I need to fill the...
  7. E

    Weird or custom auto fill series problem?

    I have been racking my brain on this for weeks and got precisely no where so I wonder if any of you guys may be able to suggest something. I have a complected spreadsheet using multiple pages with various formulas pulling all the data together. I have simplified my problem here but on one page...
  8. Prevost

    Custom Date format increments by 1 hour and 59 minutes

    Hi There, I have a custom date format cell in the form of DD/MM/YYYY hh:mm . When I fill the series, it increments the hour value by one each time, which is what I want to happen. However, after a bunch of cells, instead of incrementing by 1 hour, it increments by 59 minutes. So it goes 01:00...
  9. M

    Fill Series - Column with Multiple Values

    I am feeling sheepish - like this should be simple but nothing is working. I have a column: LABEL COUNT 1 of 2 empty cell 1 of 2 empty cell 1 of 2 empty cell 1 of 2 empty cell 1 of 2 empty cell 1 of 16 15 empty cells I need to fill the empty cell with the "series" (2 of 2, 2 of 16, 3 of 16)...
  10. J

    Custom Fill Series in a column help

    I want to create a custom fill series for a column that goes like this: 101-B 101-R 101-G 102-B 102-R 102-G 103-B 103-R 103-G and so on. That way instead of typing manually all the way to 240 each with B, R and G following after each number. Can someone help with this?
  11. T

    Fill series - very urgent

    Hi I want to fill series in this format in excel 2007 <table style="border-collapse: collapse; width: 48pt;" border="0" cellpadding="0" cellspacing="0" width="64"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;"...
  12. D

    Paste series

    I'm struggling with something that may either be really simple or horrendously complicated... I want to be able to use fill series, but instead of filling a range, I fill a selection. For example, in cell a10 of a sheet, I have the value: 1.1.1.1 Using the fill handle, I can drag a...

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 MrExcel.com.
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 "mrexcel.com".
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
Top