I recently implemented a formula into my cycle count program. The formula looks as follows
=INDEX('Count Status'!$B$8:$B$1667,SMALL(IF(('Items to Count'!$B$1='Count Status'!$H$8:$H$1667)*COUNTIF('Count Status'!$B$8:$B$1667,"<="&'Count Status'!$B$8:$B$1667),ROW('Count Status'!$B$8:$B$1667)-ROW('Count Status'!$B$8)+1),ROWS(B$6:B1348)))
However, after using this formula I have used all of my computer companies RAM and have been tasked to find a new way to go about using my spreadsheet. Essentially, when I have a item change from do not count to count on the count status page, I would like the Item to count page to reflect that so that I can then issue out those counts.
I really need some help with this one if anyone has any suggestions. Previously this topic was posted about a month ago under creating a unique lookup.
Thanks
=INDEX('Count Status'!$B$8:$B$1667,SMALL(IF(('Items to Count'!$B$1='Count Status'!$H$8:$H$1667)*COUNTIF('Count Status'!$B$8:$B$1667,"<="&'Count Status'!$B$8:$B$1667),ROW('Count Status'!$B$8:$B$1667)-ROW('Count Status'!$B$8)+1),ROWS(B$6:B1348)))
However, after using this formula I have used all of my computer companies RAM and have been tasked to find a new way to go about using my spreadsheet. Essentially, when I have a item change from do not count to count on the count status page, I would like the Item to count page to reflect that so that I can then issue out those counts.
I really need some help with this one if anyone has any suggestions. Previously this topic was posted about a month ago under creating a unique lookup.
Thanks