Hello,
I have this IDs with empty rows and I need to fill in series, it only works when you drag the value and I have around ten thousand lines.
Formula or function to fill in empty rows are highly appreciated.
Capture.PNG
Thanks a lot!
Hello,
I have this IDs with empty rows and I need to fill in series, it only works when you drag the value and I have around ten thousand lines.
Formula or function to fill in empty rows are highly appreciated.
Capture.PNG
Thanks a lot!
Last edited by spishowtime; 09-05-2018 at 05:15 AM. Reason: add photo so you dont need to download
Will the ID's always consist of 2 letters and 3 numbers?
BSB
Here is one way of achieving this, using two helper columns (which can be hidden, or even be on another sheet).
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
Hi,
Here's another formula to consider, without helper columns, in B2 copied down:
Formula:Please Login or Register to view this content.
See attached.
You're welcome, thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks