Hello guys.. Is there a neat formula where I could fill cells under the first unique number with its duplicates..My attached file makes everything clear..God bless you. and thanks in advance
Hello guys.. Is there a neat formula where I could fill cells under the first unique number with its duplicates..My attached file makes everything clear..God bless you. and thanks in advance
In B2
=IF($A2<>"",$A2,B1)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
thanks john..god bless you
https://www.ablebits.com/office-addi...-blanks-excel/
This is another solution that works excellent
Last edited by hasan mougharbel; 12-11-2021 at 04:03 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks