Forum Discussion
Using names in formulas?
Hello, I have the following table: Items Jan Feb Mar Apples 7 2 3 Bananas 12 25 14 Oranges 10 8 6 What is the best way to use name ranges, so when I want to ex...
Thank you for your reply.
Unfortunately, it is not feasible to individually name a few hundred cells:)
Unfortunately, it is not feasible to individually name a few hundred cells:)
Then you are probably applying Names at too fine a level of granularity, I tend to apply a name to ranges at as course a level as possible and then pick out individual records by formula (typically XLOOKUP or BYROW).
For the moment, though, let's assume you wish to name individual records. Rather than using the numeric sequence numbers on the left, write or generate a text sequence to the right. Use that to name the rows, and then you may delete the text if you so wish.