Need help in GSHEET QUERY

N

Nikhil Ramesh

New Member
Joined
Dec 11, 2024
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
Pls help on the ghseet
I need a pivot query





DateWarehouseOrder IDPart IDECC Order NoArticleOrder FulfilledCAC.CAR Mov.Pushed Date
01.01.2024TN99653478323392044434468No 02.01.2024
01.01.2024KL20415656243696149429696Yes WH Order
01.01.2024KL74908251749924841413118No WH Order
01.01.2024KL38835779505878335182730Yes WH Order
02.01.2024KL18592549860507046932289No WH Order
02.01.2024TN6774376939537896429834Yes 01.01.2024

expect result

Order fulfilled YES or NO, we need to display based on column Pushed Date = WH Order

DateNoYes
01.01.2024
​
2 2
02.01.2024
​
0 1
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Sort by date Sort by votes
Why you got 2 on 01.01?
In first row there is Pushed Date = 02.01 so only row 3 shall count for that.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Create pivot table from multiple sheets
Replies
3
Views
201
arthurbr
arthurbr
N
  • Question Question
Google Sheet - Math formula inside a Google Sheet formula
Replies
0
Views
360
Naegino
N
J
  • Solved
QUERY questions
Replies
2
Views
240
Jewells0905
J
J
  • Question Question
Convert VBA to Google Sheets Apps Script
Replies
0
Views
357
joeyrain
J
xarzu
  • Question Question
How do I resolve this exception thrown while trying to do CRUD operations on CSOM?
Replies
2
Views
270
xarzu
xarzu

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top