I have stumbled across a small issue which I can’t seem to overcome. In column A, I have a list of amounts for example
In my table array, the data is not consistent. For example, in one cell, I may have ‘’June 2006 opening balance 1286.48”
My objective is to identify if 1286.48 exists within the table array. So if I use the ctrl-f find function and enter 1286.48, it will show me that it is present, however I cannot seem to create a formula which will tell me if it exists or not.