FORMULATEXT
VLOOKUP
COLUMN
COLUMNS
RANGE
=========
استخرج مبيعات المنتج من الجدول ب اكثر من 4 طرق
=========================
2 تحميل كتاب الإكسل للمهندسين pdf
3 كتاب مجاني شرح أكثر من 100 دالة من الإكسل
4 كتاب متقدم جدا 👌 كتاب طرق الاهلاك باستخدام دوال الاكسيل
The VLOOKUP function in Excel
is used to find a value in a table and return a corresponding value from another column in the same table. The syntax for the VLOOKUP function is:
=VLOOKUP(lookup_value, table_array, col_index_number, range_lookup)
lookup_value is the value you want to find in the table.
table_array is the range of cells that contains the table.
col_index_number is the column number of the value you want to return.
range_lookup is a Boolean value that determines whether the match should be exact (TRUE) or approximate (FALSE).
For example, the following formula would look up the value "John Doe" in the table and return the value in the second column:
=VLOOKUP("John Doe", A2:D10, 2, FALSE)
The VLOOKUP function can also be used to return multiple values from a table. To do this, you can use the COLUMNS function to get the number of columns in the table. For example, the following formula would return the first and third values from the table:
---------------------------------------------------------------------------------------------------
=VLOOKUP("John Doe", A2:D10, COLUMNS(A2:D2)-1, FALSE)
The RANGE function can be used to specify a range of cells that is different from the table_array. This can be useful if you want to look up a value in a table that is not contiguous. For example, the following formula would look up the value "John Doe" in the table A2:D10, but would return the value in the second column of the range A2:E10:
=VLOOKUP("John Doe", A2:D10, 2, FALSE, A2:E10)
===========
The FORMULATEXT function in Excel
returns the formula that is stored in a cell as a text string. The syntax for the FORMULATEXT function is:
=FORMULATEXT(cell_reference)
cell_reference is the cell reference that contains the formula you want to return as a text string.
For example, the following formula would return the formula that is stored in cell A1 as a text string:
=FORMULATEXT(A1)
The result of this formula would be the text string "=SUM(A1:A10)" if the formula in cell A1 is SUM(A1:A10).
The FORMULATEXT function can be used to troubleshoot formulas, to create macros, and to export formulas to other applications.
Here are some examples of how the FORMULATEXT function can be used:
To troubleshoot a formula, you can use the FORMULATEXT function to display the formula as a text string. This can help you to identify the syntax errors in the formula.
To create a macro that automates the calculation of a formula, you can use the FORMULATEXT function to get the formula as a text string and then use the TEXT function to convert the text string to a number.
To export formulas to another application, you can use the FORMULATEXT function to get the formulas as text strings and then paste the text strings into the other application.
===============
The RANGE function in Excel
is a built-in function that returns a range of cells. The syntax for the RANGE function is:
=RANGE(cell_reference1, cell_reference2)
cell_reference1 is the first cell in the range.
cell_reference2 is the last cell in the range.
For example, the following formula would return the range of cells A1:A10:
=RANGE("A1:A10")
The RANGE function can be used to select a range of cells, to get the value of a range of cells, or to perform other operations on a range of cells.
Here are some examples of how the RANGE function can be used:
To select a range of cells, you can use the RANGE function in a SELECT statement. For example, the following statement would select the range of cells A1:A10:
SELECT RANGE("A1:A10")
To get the value of a range of cells, you can use the RANGE function in a formula. For example, the following formula would return the sum of the values in the range A1:A10:
=SUM(RANGE("A1:A10"))
To perform other operations on a range of cells, you can use the RANGE function in conjunction with other functions. For example, the following formula would count the number of cells in the range A1:A10 that contain text:
=COUNTA(RANGE("A1:A10"))
==============
The COLUMN function in Excel
returns the column number of a cell reference. The syntax for the COLUMN function is:
=COLUMN(cell_reference)
cell_reference is the cell reference that you want to get the column number for.
For example, the following formula would return the column number of cell A1:
=COLUMN(A1)
The result of this formula would be 1, because column A is the first column in Excel.
The COLUMN function can be used to:
Get the column number of a cell reference.
Calculate the number of columns in a range of cells.
Compare the column numbers of two cells.
Create formulas that depend on the column number of a cell.
Here are some examples of how the COLUMN function can be used:
To get the column number of a cell reference, you can use the COLUMN function in a formula. For example, the following formula would return the column number of cell B2:
=COLUMN(B2)
To calculate the number of columns in a range of cells, you can use the COLUMN function in a formula. For example, the following formula would return the number of columns in the range A1:C10:
=COLUMN(C10)-COLUMN(A1)+1
To compare the column numbers of two cells, you can use the COLUMN function in a formula. For example, the following formula would return TRUE if cell A1 is in the same column as cell B1:
=COLUMN(A1)=COLUMN(B1)
To create a formula that depends on the column number of a cell, you can use the COLUMN function in the formula. For example, the following formula would return the value in the cell that is two columns to the right of cell A1:
=A1*COLUMN(A1)+2
=======================
The COLUMNS function in Excel
array is the range of cells for which you want to get the number of columns.
For example, the following formula would return the number of columns in the range A1:C10:
=COLUMNS(A1:C10)
The COLUMNS function can be used to:Get the number of columns in a range of cells.
Compare the number of columns in two ranges of cells.
Create formulas that depend on the number of columns in a range of cells.
Here are some examples of how the COLUMNS function can be used:To get the number of columns in a range of cells, you can use the COLUMNS function in a formula. For example, the following formula would return the number of columns in the range A1:C10:
=COLUMNS(A1:C10)
To compare the number of columns in two ranges of cells, you can use the COLUMNS function in a formula. For example, the following formula would return TRUE if the range A1:C10 has the same number of columns as the range D1:F10:
=COLUMNS(A1:C10)=COLUMNS(D1:F10)
To create a formula that depends on the number of columns in a range of cells, you can use the COLUMNS function in the formula. For example, the following formula would return the value in the cell that is two columns to the right of the last cell in the range A1:C10:
=A1*COLUMNS(A1:C10)+2