Can someone help with this?
I have attached a book in case I haven't explained well enough.
I want to continue the number sequence in column A so that it matches the results in column D.
In range A1:A8 are the numbers 1 to 8, then there are 4 blanks and then 1 in A13.
I have thousands of rows of blanks to do manually so was hoping for some formula that I could drag down in column B.
The numbers are always consecutive and all the blanks are above he value of 1.
Thanks
If I understand correctly .....
ry
in B1
=IF(MATCH(1,D2:$D$10000,0)<5,"",D1)
drag down
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks for your reply JT.
I see your formula refers to column D.
Column D in the attached book just gives an example of what I want to see in column B.
B1=1
in B2
IF(MATCH(1,$A2:$A$1000,0)=1,$A2,IF(MATCH(1,$A2:$A$1000,0)<=5,$B1+1,$A2))
copy down
Last edited by JohnTopley; 11-04-2021 at 12:24 PM.
Magic.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks