mrxlsx
Board Regular
- Joined
- Dec 15, 2012
- Messages
- 95
Hi all,
I have a formula range like this " =IFERROR(SMALL($H$2:$H$16,G3),"") ".
It works only for H2:H16 at present, but I want it to be a dynamic one as the no of rows grow.
Basically I am trying to extract Invoice records from a self-expanding data range.
If I select an Invoice no in M2, I will get records for that Invoice no. But it has a limitation regarding its range, how to overcome this??
All the problem is in the Column I i.e. in the SMALL function's place.
Please check the below link for more information.
https://drive.google.com/open?id=0B6GD5M1_zN7bTUFaSWlubGtCcjQ&authuser=0
Please ask me for any clarifications.
Thank you
mrxlsx
I have a formula range like this " =IFERROR(SMALL($H$2:$H$16,G3),"") ".
It works only for H2:H16 at present, but I want it to be a dynamic one as the no of rows grow.
Basically I am trying to extract Invoice records from a self-expanding data range.
If I select an Invoice no in M2, I will get records for that Invoice no. But it has a limitation regarding its range, how to overcome this??
All the problem is in the Column I i.e. in the SMALL function's place.
Please check the below link for more information.
https://drive.google.com/open?id=0B6GD5M1_zN7bTUFaSWlubGtCcjQ&authuser=0
Please ask me for any clarifications.
Thank you
mrxlsx