ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Criterian Range taking value from another cell (https://www.excelbanter.com/excel-discussion-misc-queries/165087-criterian-range-taking-value-another-cell.html)

Shrikant

Criterian Range taking value from another cell
 
The Criterian Range contains following formula
=+K5P7
This returns 0 filter range. In the Criterina Range at the place of the
formula, I get 'TRUE' remark.
When instead I put following criteria
=+K5100
I get correct filter data. It means that I can only put absolute figures on
the right hand side of the comparison formula. I can not put reference to
another cell.
Is there any method by which I can use the value in another cell on the RHS
of the comparison formula in the Criterian ?


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com