I have a formula written to pull the first 2 left digits from each cell (f2:j2). The values are put in cells (a2:e2). I am trying to get the values from cells (a2:e2) combined into cell (a5). These numbers need to be listed in ascending order separated by a comma. I am getting #NUM! Error when I hit the enter key.
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. It would be a great help, you don't have to readjust everything yourself to see where the problem could be.