Hello T. Valko,
Thanks for your help. Unfortunately, the software doesn't support ROW() function either. I've figured out another way to get around the problem. I had to split the information into two sheets, using max(), match() and index() to get around it. It's not pretty, but it works.
Thanks again for your help.
|