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: Using the fill handle, I can drag a...

Some videos you may like

This Week's Hot Topics