Google Sheet Formula Samples

-
You will see some formula samples below. Please think what they mean. If you have any questions related any of them, please write them in in the comments.


if(COUNTBLANK($A8:$M8)=0,transpose(query(Directory!N$2:N$3)),"No")

QUERY(ImportRange("1qchEnmIzpT9zP82hTJCPEgKIADb-j2Obci7X-PUkLa4/edit#","Form Responses 1!A:N"), "Select Col13,Col4,Col5,Col6,Col7,Col9 where Col11='APPROVED' order by Col6 desc")

QUERY(Home_Visit!A:N, "select * where ( E='' or F='' or G='' or H='' ) and (I!='' or J!='' or K!='') and ( toDate(now() ) > E) ")

query(Main!1:1223,"select B, E, I, M, N, O where H contains '"&C3&"' and D contains '"&D3&"' and E contains '"&E3&"' order by B asc ",1)

QUERY('Lesson Plan'!A69:B215, "select * where A contains '"&C3&"' ")

AVERAGE(if(today()>$D$1,E3),if(today()>$F$1,G3),if(today()>$H$1,I3),if(today()>$J$1,K3),if(today()>$L$1,M3),if(today()>$N$1,O3))

ARRAYFORMULA( COUNTIFS($B$2:B,G2, DAYS360($C$2:C,$D$2:D)-2, ">0"))

IFERROR(SUM(FILTER(Tutoring_MS!H:H,Tutoring_MS!G:G=$Z$3,Tutoring_MS!B:B=B3)*$AA$3,FILTER(Tutoring_HS!H:H,Tutoring_HS!G:G=$Z$7,Tutoring_HS!B:B=B3)*$AA$8)/43,"0")

sort(unique(filter(Main!H2:H1223,Main!H2:H1223<>"",Main!G2:G1223=B3,Main!C2:C1223="2015-16")))

query(AddCourse!$A:$C,"select B where C matches """&F1&"""",0)



Comments

Post a Comment

Popular posts from this blog

My CCNA Useful Links

-
Summary of All Topics-1 Click on the "Sections (Theory)" part. Summary of All Topics-2 Summary of All Topics-3 Cisco Networking All-in-One Cheat Sheet GENERAL INFO&TERMS IPv4 IPv6 ROUTING OSPF Explanation Video OSPF Lab - 1 OSPF Lab - 2 EIGRP Explanation Video EIGRP Lab - 1 EIGRP Lab - 2 Troubleshooting: Check AS, networks must be configured under eigrp (check the interface ip to see there is any missing network), metric values must be same. Static and Default Route Lab HSRP Vs VRRP Vs GLBP Redundancy Protocols How to Break Cisco Routers Password Using Rommon Mode Don't forget to go rommon mode back and start your router with default register value which is 0x2102. This part is not in the video. SWITCHING STP VTP STACKABLE SWITCH ETHERCHANNEL VLAN HOW TO CONFIGURE ROUTER ON A STICK - 802.1Q TRUNK TO CISCO ROUTER How to Confi gure Port Security on a Cisco Switch   OTHER ACL Router1(config)#access-list 101...
Read more

General Printer Errors

-
Q: When I send a print to the copier it takes several minutes to print ! A:   The reason can be the size of the file and the resolution. (What are the size of the file and how many pages?) or driver issue (needs to update latest version) or printer firmware issue (needs to update latest version) or speed negotiation issue (set speed/duplex manually on both ends (switch and copier)). Q: The address label doesn't fit on the paper! A:   Make sure that it fits the page. You will see it when you goes the print > more settings (The scale may not 100%. ) Q: The wifi drops down! A:   I recommend you to do the followings: Check the printer firmware. (Refer the manufacturer website.) Check your machine wifi capability and you network band. (2.4GHz or 5 GHz) Check your network minimum bitrate (Mbps) Be careful! increasing or decreasing it may affect your network, if you have close AP in the building. Try usb cable no longer than 2 meters. (Some devices do...
Read more

Python

-
Image
Don't repeat any code! If you do that, there is something wrong. Don't dry (don't repeat yourself) It is a Case-Sensitive language. Keep your variable lower case letters. No space, If you need, use _ .  Ex: my_language print ('Hello World') print(f"{kind} kilos ")     # kind is a variable which defined before. name= input (' What is your name? ') str: All input are str (default). You need to convert them int or float to make calculation float int ' ' '  You can write whatever you want here ' ' ' word= "Python and Mr.G" print (word[0:4])  ==> Pyth      0 is P.  4 is o. But the last one is excluded. Examples: print (word[2])     ==> t print (word[-1])     ==> G print (word[2:5])     ==> tho print(word[1:-1])  ==> ython and Mr. Function = Methods message.upper()                   # to convert to uppercase message...
Read more