・無在庫抽出タブにてフィルタ。購入有無が#N/Aで日付精査に日付が入っているもののみ選択。（これが新規注文分）
・新規注文分を日付精査よりPhoneナンバー（Q列）まで選択。GDに貼り付ける
・GDのB列の式を下まで引っ張ってダブりをチェック。2が連続して入っているものは同梱なので問題
題なし。飛んで2が入っているものは別のオーダーが再度記載されている可能性が高いため、要注意。
Rating
52
Translation / English
- Posted at 14 Sep 2014 at 18:43
-The out-of-stock should be extracted by tab filtering.
Selection should be performed in only items that is
indicated with #N/A ;purchase with or without and
confirmed with entry of date on investigation column.
(This is new order items)
- New order item is selected from date investigation to
Phone number (Q rows). Please attach to GD.
- Check overlaps by bringing the formula of GD B row to lower part.
In case 2 of entry appears continuously, this is bundled item.
so there is no problem.
In case 2 of entry is jumped, there is high possibility registered
another order again. so Please pay attention to it.
Selection should be performed in only items that is
indicated with #N/A ;purchase with or without and
confirmed with entry of date on investigation column.
(This is new order items)
- New order item is selected from date investigation to
Phone number (Q rows). Please attach to GD.
- Check overlaps by bringing the formula of GD B row to lower part.
In case 2 of entry appears continuously, this is bundled item.
so there is no problem.
In case 2 of entry is jumped, there is high possibility registered
another order again. so Please pay attention to it.
Rating
52
Translation / English
- Posted at 14 Sep 2014 at 18:01
· Filtering out by the non-inventory retrieving tab. Select only a row of which order record cell shows #N/A and date examination cell shows date (This is for new order).
· Select the cells from the date examination to the phone # (up to Q columns) as the new order and paste them to GD.
· Drag down the formula of column B for GD and double check the dual entry. If the cell shows the value 2, it means to say enclosed together, so it is problem.
No subject: it should be very careful for those orders which show the value entered separately as it may be high possibility of double entries of separate order.
· Select the cells from the date examination to the phone # (up to Q columns) as the new order and paste them to GD.
· Drag down the formula of column B for GD and double check the dual entry. If the cell shows the value 2, it means to say enclosed together, so it is problem.
No subject: it should be very careful for those orders which show the value entered separately as it may be high possibility of double entries of separate order.
Rating
50
Translation / English
- Posted at 14 Sep 2014 at 17:15
・Filter in no stock extraction tub. Only select purchase is #N/A and the date exists in the date scrutiny.(That's new order).
・Select new order from date scrutiny to phone number(Q column).Paste it on GD.
・ Check the duplication by drugging B column's formula below. The material including 2 continuasly is included, so no problem.
The material including 2 at intervals is possible that another order is listed again, so caution it.
・Select new order from date scrutiny to phone number(Q column).Paste it on GD.
・ Check the duplication by drugging B column's formula below. The material including 2 continuasly is included, so no problem.
The material including 2 at intervals is possible that another order is listed again, so caution it.
