Hello Everyone.
I am having with matching the multiple columns .
I have a file, which shows customer record of ordering the food from tablet menu .
I want to display the data of customer who ORDERED after SCREENSAVER is displayed.
My data sample are as follows
Date- Time- INFO-Table -Bill Number-Unique ID-Status- Order Status Product Name
7/1/2019 20:43:57 INFO 1 266 16bad5278a1 ORDER 注文します。 商品:ダブルフレンチトーストセット/ホット茉莉龍珠茶/黒蜜きなこ=1
7/1/2019 20:44:02 INFO 1 266 16bad5278a1 ORDER 注文完了 7/1/2019 8:45
7/1/2019 21:07:05 INFO 1 266 16bad5278a1 ORDER 注文します。 商品:角ハイボール=1
7/1/2019 21:07:10 INFO 1 266 16bad5278a1 ORDER 注文完了 7/1/2019 9:09
7/1/2019 21:23:55 INFO 1 266 16bad5278a1 SCREENSAVER クリックされました。 MENU:651
7/1/2019 21:24:25 INFO 1 266 16bad5278a1 ORDER 注文します。 商品:ブルーベリークリームチーズジェラート(3枚)=1
7/1/2019 21:24:31 INFO 1 266 16bad5278a1 ORDER 注文完了 7/1/2019 9:26
In this table Table Number 1 Have Bill Number 266 and its Unique ID is 16bad5278a1 .
On 21:23:55 SCREENSAVER pops up at screen and the customer touches it .
After the word SCREENSAVER there is one more order made from same customer "注文完了" means order confirmed.
Now First of all
-How to match the Table Number ,Bill Number and Unique ID , and display all the remaning customers "ORDER" after and before SCREENSAVER?
I have also attached the workbook.
What I want is to find the total number of customers who ordered after screensaver .
Bookmarks