Google Sheet – useful formulas

Summarize Your Spreadsheets by Month, Quarter, or Day of the Week 'https://www.youtube.com/watch?v=PmXKxIefsaw  Protect or Totally Hide Data Using IMPORTRANGE 'https://www.youtube.com/watch?v=UyBSXgt2_Yg Conditional Formatting Entire Rows | Text or Dates 'https://www.youtube.com/watch?v=WM4hgenP8g4 highlight highest value and lowest in google sheets Row and Column wise. 'https://www.youtube.com/watch?v=kYUaypeaIuw Two Way Lookup, INDEX MATCH, VLOOKUP midnorthsoutheasta111b222c333d444e555666777888 '=VLOOKUP(H7,$A$2:$E$6,XMATCH(I7,$A$1:$E$1),FALSE) 'https://www.youtube.com/watch?v=bTmuQuB1BNU filter based on month … Continue reading Google Sheet – useful formulas