creating a link between countif

  • Thread starter Thread starter alistair01
  • Start date Start date
A

alistair01

Is there any way in excel to create a link between the result of
countif formula to those occurances in another sheet (database)?
or even to show these occurances within a new sheet? Any ideas would b
very helpful
 
To display just the rows that match some criteria you can use Data, Filter,
AutoFilter. You can then copy those matching rows to another location. You
can also use Data, Filter, Advanced Filter to copy matching rows directly to
another location. Both of these filtering operations use criteria you
specify, similar to the COUNTIF criteria, but there is no automatic link
between the two.
 
Back
Top