View Single Post
  #4   Report Post  
ltzhao ltzhao is offline
Junior Member
 
Posts: 2
Default

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.