Not entirely sure I follow... based on your sample:
You would keep the above as it would help you minimise the number of subsequent calculations you perform in retrieving the values themselves
It is imperative I3 (and down) is blank (or does not contain items otherwise found in B:F).
Note however that in the above the values are being coerced to text by virtue of the REPT call.
What I would say is that the above is not a practical solution for scaling against large ranges - if you have large ranges to deal with I would suggest you use VBA.
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks