Can anyone help me with programming a range of cells so that they decrease by a set amount.
If I start with the top cell reading 200, then want the next cell down to read 195, then 190 etc can I do this without having to manual enter the numbers?
Can this be done with dates as well?
Enter 200 in A1
Select range to populate, A1:A10
Edit > Fill > Series
Step value -5
Just notice you are using Mac version. Not sure if the menu is in exactly the same place.
try =200-5*ROWS($A$1:A1)
Nice Andy! I always forget that you can do nice little things like that ! ... I can't give you rep though unfortunately... apparently I have to share the love firstOriginally Posted by AP
(zbor, either 205 or ROWS(A$1:A1)-1 else first number would be 195)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
as an alternative to zbor's formula
enter 200 in cell A1
enter this formula in A2
=A1-5
copy down
I often feel we're too keen on providing a VBA or formula solution rather than using built-in Excel features.Nice Andy! I always forget that you can do nice little things like that !
Correct... Also can define starting value (A1) and step (A2)
=$A$1-$A$2*(ROWS($A$1:A1)-1)
You can also populate the first 2 values and then select and drag
A1: =200
A2: =195
Select A1:A2 and drag when cursor changes to bold cross over bottom right corner of cell.
@zbor..............
Wow!
Thanks for the speedy responses and the number of replies!
Some forums take days to answer!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks