Dear Experts,
I have a datasheet and i want result in second sheet based on week numbers.
Main columns are as i mentioned below,
in second sheet using same columns and i want to use drop-down list for week numbers, when i select a week it showed me only filtered data against that week.
=IF(ROWS(A$14:A14)<=$B$3,INDEX(INDIRECT(A$13),SMALL(IF(ShipWeeks<=$A$3,ROW(ShipWeeks)-ROW('Datasheet'!A$20)+1),ROWS('Secondsheet'!A$14:A14))),"")
It is working properly but i want to add some lines too, suppose i have selected week 8 and those lines which still in-process in less than week 8 too.
Hoping to get a good result with expert teams,
Best Regard,
Kamran Noor
I have a datasheet and i want result in second sheet based on week numbers.
Main columns are as i mentioned below,
- Customers
- Styles
- Qty
- Rate
- Values
- shipment dates
- week numbers (Weeknum)
- status (In-process, ready to ship, shipped)
in second sheet using same columns and i want to use drop-down list for week numbers, when i select a week it showed me only filtered data against that week.
=IF(ROWS(A$14:A14)<=$B$3,INDEX(INDIRECT(A$13),SMALL(IF(ShipWeeks<=$A$3,ROW(ShipWeeks)-ROW('Datasheet'!A$20)+1),ROWS('Secondsheet'!A$14:A14))),"")
It is working properly but i want to add some lines too, suppose i have selected week 8 and those lines which still in-process in less than week 8 too.
Hoping to get a good result with expert teams,
Best Regard,
Kamran Noor