Google Sheet Formula Sample with Explanation

I want to share some Google Sheet formula examples with their definitions.

If you want to put data into one column;
SORT(unique({C10:C;D10:D;E10:E;F10:F;G10:G}))

Multiple Source Query
QUERY({IMPORTRANGE("1UDEdV70XTxw7fCFna6wSS7XYkZsSKm5rVgZL3uCsD4k","Sheet1!A1:C");IMPORTRANGE("1w5ILzQcW5xokFVFBpcYVumjKXzuLdII0iEjX8P52WiA","Sheet1!A2:C");IMPORTRANGE("153DPunGmabPPfLg9wx7VDOZc9GxZTc-sUlkSHk8DDK0","Sheet1!A2:C")},"Select * where Col1<>''",1)
For more details:
https://docs.google.com/spreadsheets/d/1OhGnZLzGeQOSA0hgyLfHBvDXIAp0E4aeH3vVlVILJeU/edit#gid=0

Multiple If (ifs) vs. Index(Match)
index(LP!A:G,match(1,(LP!B:B=C20)*(LP!C:C=D20),0),match(E19,LP!1:1,0))
If you increase blue part, coklu sinirlandirma yapabilirsin. If the blue part is correct, the value is 1. If it is not correct, the value is 0.


Comments

Popular posts from this blog

iBoss Tips&Problems

Synology DiskStation Quick Installation

Sonicwall; Open a port and how to use sonicwall wizard