dear all
please see my attached file with sample that i want to do like automatic
when i enter value in cell like 10
in other column that have formula wrote the following
1
2
3
4
5
6
7
8
9
10
and if i wrote any other value it directly fill automatic cell
With your set up...
In B1:
=IF(ROW()<=A$1,ROW(),"")
Copy down.
Copy to G1 and copy down.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
In B1 enter this formula and drag down
Please Login or Register to view this content.
many thanks dear Robert its wrok very good
i have anthoer qestuion realted to this also
if i want to disrtibute this to 1 meaning if i enter 10
give me
1
1
1
1
1
1
1
1
1
1
and if i enter any value with decimal for example 5.75 give me like
1
1
1
1
1
0.75
In B1:
=IF(ROW()<=A$1,1,IF(ROW()-1<A$1,A$1-ROW()+1,""))
Copy down.
Dear CK76
its work but only when i start from first row but if i start from third row give me missed data
If starting from row other than the first. Just add cell reference within Row function.
I. E. Row(A1) in starting cell.
Or you can subtract the difference (in this case Row() - 2)
please i dont understand what you mean exactly
you mean like the folloiwng
=IF(ROW()<=A$1,1,IF(ROW()-2<A$1,A$1-ROW()+1,""))
or use this:
=IF(ROWS($1:1)<=A$1,1,IF(ROWS($1:1)-1<A$1,A$1-ROWS($1:1)+1,""))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
what about this
=IF(ROW()<=$A$1,ROW(),"")
how also do this
Did you test?
Row(A1) = 1
And since it's relative reference. As you move down you increment by 1.
So, if you enter following formula in C3 and copy down... you get the result you asked for.
=IF(ROW(A1)<=A$1,1,IF(ROW(A1)-1<A$1,A$1-ROW(A1)+1,""))
Or using 3rd row - 1st row = 2
=IF((ROW()-2)<=A$1,1,IF((ROW()-3)<A$1,A$1-ROW()+3,""))
what about this
=IF(ROW()<=$A$1,ROW(),"")
for first post t give me
1
2
3
4
5
6
7
8
9
and soon
.... same thing.
=IF(ROW(A1)<=$A$1,ROW(A1),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks