Formular Starting from J2, the four conditions are B1, D1, F1, H1
J2 cell how to write the formula down
B1 is starting first number
D1 is Ending number
F1 increase a nnumbers
H1 increase each time
Can someone please help me ? It would be much appreciated. Thanks in advance
Last edited by metrostar; 10-03-2020 at 07:51 AM.
Hi,
K2 =$B$1
K3 =IF(COUNTIF($K$2:K2,K2)>=$F$1,K2+$H$1,K2)
Please try at J2
=IF(ROWS(J$2:J2)>$D$1*$F$1,"",INT((ROWS(J$2:J2)-1)/$F$1)*$H$1+$B$1)
TQ
Excel Expert, it doesn't seem to work
I want the blue color answer
Please see my new file
Bo_Ry is what I want, you are too goodOriginally Posted by Bo_Ry
Excellent solution. Thank you both, thank you very much for the solution.
K2 =$b$1
k3 =if(countif($k$2:k2,k2)>=$f$1,k2+$h$1,k2)
Right this time, it's what I want, thank you
There is another small problem. My question is not clear. If the data is greater than or equal to D1 and it becomes blank, how to modify the formula?
For example, D1 is 10, more than 10, the following are all blank
Last edited by metrostar; 10-03-2020 at 08:24 AM.
Please try at J2
better one for text
=TEXT(INT((ROWS(J$2:J2)-1)/$F$1)*$H$1+$B$1,"[<="&$D$1&"];")
or Number
=IFERROR(--TEXT(INT((ROWS(J$2:J2)-1)/$F$1)*$H$1+$B$1,"[<="&$D$1&"];"),"")
Last edited by Bo_Ry; 10-03-2020 at 08:46 AM.
Here is mine with a correction
K2 =B1
K3 =IF(IF(K2>$D$1,"",IF(COUNTIF($K$2:K2,K2)>=$F$1,K2+$H$1,K2))>$D$1,"",IF(K2>$D$1,"",IF(COUNTIF($K$2:K2,K2)>=$F$1,K2+$H$1,K2)))
Last edited by Limor_OP; 10-03-2020 at 08:59 AM.
awesome! Very grateful! Both of You ,solved my problem perfectly, Much appreciated!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks