I want to create a named range for a discreet range.. I'm combining two diferent columns A2:A10 and C2:C7.
Both ranges may vary by adding new rows at the bottom of any of them so it can be aslo A2;A12 and C2:C20. I know each range could be defined by a desref and counta functions but i cannot united both in a single named range for using it in a display list