Need help in GSHEET QUERY

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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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

Forum statistics

Threads
1,225,750
Messages
6,186,808
Members
453,373
Latest member
Ereha

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