Use QUERY Formula in Google Sheet as Replacement of PivotTable Function
QUERY formula can be used as replacement of PivotTable function. However this formula can only be used in Google Sheet not other spreadsheet application.
Tagged: sheet
Project Gantt Chart with Google Sheet
This Project Gantt Chart is made with Google Sheet and not compatible with Microsoft Excel, because some important formula is not available on Excel. It’s not as complicated like Microsoft Project, but not very simple neither. You can input project...
Summarize Cable Schedule Easily with Google Sheet
This tutorial will show how to summarize cable size & length, cable gland, and cable lug from cable schedule easily with Google Sheet. Steps: Copy Cable Size & Cable Length column from cable schedule spreadsheet to Google Sheet. Rename this...
