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
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
Post a Comment