如何在Excel中从非连续命名范围中选择单个值

I've created some named ranges on a spreadsheet which are built up from non-contiguous cells.I've created some named ranges on a spreadsheet