Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Noncontiguous cell range
When I use a function like Match, Count, or another function that
specifies a range of cells, I must enter something like A3:F3. Can my range be a set of noncontiguous cells, like A3, C3, E3, F3? Jeff |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Noncontiguous cell range
On Jun 15, 6:13*pm, jeffrey wrote:
When I use a function like Match, Count, or another function that specifies a range of cells, I must enter something like A3:F3. *Can my range be a set of noncontiguous cells, like A3, C3, E3, F3? Jeff CHOOSE, COUNTIFS, INDEX do not have to be contiguous. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 noncontiguous cell highlight color=light,light blue. How do I make it darker, or like Excel 2003 ( I'm extremely shade blind-PLZ HELP !! ) | New Users to Excel | |||
Excel 2007 noncontiguous cell highlight color=light,light blue. How do I make it darker, or like Excel 2003 ( I'm extremely shade blind-PLZ HELP !! ) | Excel Discussion (Misc queries) | |||
I want to add more that 30 noncontiguous cells in Excel | Excel Worksheet Functions | |||
Noncontiguous rows | Excel Discussion (Misc queries) | |||
noncontiguous cells | Excel Discussion (Misc queries) |