Results 1 to 8 of 8

Match Multiple column contents

Threaded View

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    singapore
    MS-Off Ver
    1906 Build 11727.20230
    Posts
    6

    Match Multiple column contents

    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 .
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Match multiple column contents
    By blinkblink in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-09-2019, 12:27 AM
  2. [SOLVED] Show row if cell contents in column A match filter selection from column B
    By SHANNON MAUGHAN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2017, 01:28 AM
  3. [SOLVED] Trying to get a column in one table to match the contents of a column in another
    By peteypops33 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-28-2017, 11:50 AM
  4. Match cell contents with column
    By hannsg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2016, 11:23 AM
  5. Match One Column's Contents with Anothers
    By AlexNsvc in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-29-2016, 07:16 PM
  6. Replies: 6
    Last Post: 12-07-2012, 05:38 PM
  7. [SOLVED] Vlookup? Pivot Table? How do I match column A and B to contents in column C?
    By rushnit in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 08-08-2012, 10:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1