Good-morning, I hope you're having a fabulous day. My mind has turned to mush trying to think this through and I need some help from those of you with more brainpower and experience than I have. I haven't found a concatenate formula solution for this, so your kind assistance would be very appreciated!!!
I have attached an example file which shows multiple client names in Column A, along with a header row of generic Client Kits (CK) numbered 1-19 in this example, but in reality sometimes going to something as high as CK45.
Cells V9 and V10 show the result I would want to see from the concatenate function. It would:
--- Result in a consecutive "1) ", "2) ", "3) "... number for each of the result components (the latter will be in varying cells across that row)
--- Ignore any blank cell where no Client Kit identifier is showing
--- Have a carriage return (I presume CHAR(10) would accomplish that) after each individual numbered item in the aforementioned 1,2,3,4... etc. sequence
Bookmarks