DROP

The DROP function excludes a specified number of rows or columns from the start or end of an array.

DROP(array, number-of-rows, number-of-columns)

array: The array from which to drop rows or columns.

number-of-rows: The number of rows to drop.

number-of-columns: The number of columns to drop.

Notes

  • DROP can remove headers and footers in a report to return only the data.

  • A negative value for number-of-rows or number-of-columns drops from the end of the array.

  • If the selected array includes empty cells, the function fills the empty cells with 0.

  • You can use the spilled range operator “#” to reference an array created by a formula.

Examples

=DROP(A1:E5, 1,1) removes the first row and the first column.

=DROP(A1:E5, 2) removes the first two rows.

=DROP(A1:E5,,1) removes the first column.

=DROP(A1:E5,, -3) removes the last three columns.

See alsoEXPANDTAKEUNIQUE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ਕੋਈ ਮਦਦ ਮਿਲੀ?
ਅੱਖਰ ਸੀਮਾ: 250
ਵੱਧ ਤੋਂ ਵੱਧ ਅੱਖਰ ਸੀਮਾ 250 ਹੈ
ਫ਼ੀਡਬੈਕ ਲਈ ਤੁਹਾਡਾ ਧੰਨਵਾਦ।
Morty Proxy This is a proxified and sanitized view of the page, visit original site.