Apologies to all for the hiatus – hopefully I will have a bit more time now in which to post some new material.
Anyway, before beginning anything new, I would just like to offer my thanks to Alex, Lori and Michael for their illuminating contributions to the challenge I set a while back and which can be found here.
Another challenge to follow shortly. Watch this space!
so, where is the result of challenge 13? can we see it?
@Flora
Apologies. There was no clear ‘winner’ for this one – I simply refer the reader to the excellent posts made by all those who contributed to this challenge.
I appreciate that I have traditionally declared a single ‘winner’ to these challenges, but here I feel that this would somehow detract from the many good solutions.
Regards
Welcome back!
Thanks a lot, Alex! 🙂
Thanks. I cannot seem to get this formula work in the sample workbook. I am trying to learn how it works. but cannot get the formula right. what area in all sheets should be Rng of named range? and which named range should refer to ={“Sheet1″,”Sheet2″,”Sheet3″,”Sheet4″,”Sheet5”} am I missing something?
@Flora
As mentioned in the original article, Rng is a Named Range (created via Name Manager) which refers to the range of your choice. I used A1:G4 as an example, but you can choose whatever you want here.
The other Named Range, Sheets, refers to all relevant sheets in the workbook, e.g.
Let me know if you’re still having difficulties.
Regards