| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto extend formula down a column
I have data in columnB which is automatically inserted from an input sheet
by a macro running via a button.. In column A I have the following formula which inserts a unique number to that column should a unique item be found in column B "=IF(COUNTIF(B$1:B70,B70)=1,MAX(A$1:A69)+1,"") ". How can I have the formula automatically inserted into row 71 with the formula updated for that row, ie "=IF(COUNTIF(B$1:B71,B71)=1,MAX(A$1:A70)+1,"") ". Sandy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extend Formula | Excel Discussion (Misc queries) | |||
| extend on an index formula I already have | Excel Worksheet Functions | |||
| Auto Extend Formulas doesn't work for a particular formula | Excel Discussion (Misc queries) | |||
| how do i extend the series of a portion of a formula? | Excel Worksheet Functions | |||
| Excel - option to extend function in cell to column | Excel Worksheet Functions | |||
Threaded Mode
