To be开发者_StackOverflow社区tter illustrate what I am looking for I will give an example. Imagine a spreadsheet with two columns, Priority and Value.
I have found several sites that talk about work arounds but they all talk about doing some kind of mathematical equation, so this is the nested if\'s I am trying to fix.
Named lists in an excel sheet are referenced from another sheet on the same book. E.g. Sheet 2 has the named lists(GRPCNT) contain strings
I want to edit this query =COUNTIFS(\'Sheet1\'!E2:E465,7,\'Sheet1\'!F2:F465,2) so that when I drag/copy it sideways, as in, next cell to the right the 2 stays constant and the 7 increments like
加载中,请稍侯......