I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.
Excel©'s worksheet function CONCATENATE is not able to concatenate cell or element values of ranges or arrays. A user-defined function sbCat can help here:
This formula lists all missing positive integers of the (even unsorted!) input.
This formula has to be entered as an array formula: Press CTRL + SHIFT + ENTER to enter it.
If you are interested in downloading an Excel © sample file which created the output shown above, go to my Download page, please.
[Sulprobil] [Get it done] [Organisation] [IT] [Controlling] [Human Resources] [Family] [Contact] [Download] [Disclaimer]