Hi,
Any help appreciated to edit the formula in AI7 highlighted in yellow so that the 3 named ranges (bfast, Lunch, Evening) provides the total unique text.
Basically this formula works well for 1 named range but I would like this to expand to all 3 areas as shown
More detailed information on the sample file.
Many thanks
Garry
Bookmarks