| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill range/series help required please
I am trying to auto fill a series, the problem I have is the wrong values are
amended through the series and I cannot see how to correct this. . . My series to fill is: =COUNTIF('[2007.xls]Mar 07'!B2:W2,"U") I want to see: =COUNTIF('[2007.xls]Mar 07'!B3:W3,"U") =COUNTIF('[2007.xls]Mar 07'!B4:W4,"U") What I actually get is: =COUNTIF('[2007.xls]Mar 07'!C3:X3,"U") =COUNTIF('[2007.xls]Mar 07'!D3:Y3,"U") I really want the cell letter to remain the same but the row identifier to change, however I get the opposite of what I want/need. . . . anyone got any ideas please??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fill series | Excel Discussion (Misc queries) | |||
| fill series | New Users to Excel | |||
| How can I fill in the required fields on my spreadsheet? | Excel Discussion (Misc queries) | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| make a cell required to fill-in on form template | Excel Worksheet Functions | |||
Threaded Mode
