Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › Excel

TAKE, SORT, DROP and CHOOSECOLS

Revision card: TAKE, SORT, DROP and CHOOSECOLS. Example data table with Top 3 orders by profit: O2, O3, O5; All orders except the first: O2 to O5 (4 rows); Only the profit column: 120, 450, 300, 90, 210.

Revision card: TAKE, SORT, DROP and CHOOSECOLS. Example data table with Top 3 orders by profit: O2, O3, O5; All orders except the first: O2 to O5 (4 rows); Only the profit column: 120, 450, 300, 90, 210.
Card 2 of 2: TAKE, SORT, DROP and CHOOSECOLS · Download PNG
Read card text

What this card says

TAKE, SORT, DROP and CHOOSECOLS

Example

data table with Top 3 orders by profit: O2, O3, O5; All orders except the first: O2 to O5 (4 rows); Only the profit column: 120, 450, 300, 90, 210

Learn this in the lesson: 9. Dynamic Arrays

See all Excel revision cards