Диаграмма Ганта одной формулой в Excel и Google Sheets #ДиаграммаГантаоднойформулойExcel

Gantt chart with a single formula in Excel and Google Sheets We use conditional formatting and dynamic array functions. Using the Min and Makes functions, we find the start and end dates of our project. Using the dynamic array function, we get all the days of the project. We then use conditional formatting to display the Gantt chart, and arrange the conditional formatting rules in the correct order. See a detailed description with formulas and screenshots https://docs.google.com/document/d/1T... Link to the Last Lesson    • Урок 6 Динамические массивы Excel -функции...   Link to the Excel file https://docs.google.com/spreadsheets/... Link to the Google spreadsheet Sheets https://docs.google.com/spreadsheets/... #Gantt Chart with one Excel formula, #Gantt Chart with one Excel formula, #Gantt Chart with one Google Sheets formula, #Gantt Chart with one Google Sheets formula, #excel, #googlesheets , #Excel , #Googlesheets, #RobertKirakosyan, #RobertKirakosyan