RANK in Visual C#

Creating QR-Code in Visual C# RANK

Fills a cell with a string of characters repeated a specified number of times and takes the form =REPT(text,number_times), where text specifies a string in double quotation marks and number_times specifies how many times to repeat text. The result of the function cannot exceed 32,767 characters. Returns the rightmost series of characters from a string and takes the form =RIGHT(text, num_chars), where num_chars indicates how many characters you want to extract from the string (1, if omitted). Blank spaces count as characters. See Using the Substring Text Functions on page 419. Returns the rightmost series of characters from a string, based on the number of bytes you specify, and takes the form =RIGHTB(text, num_bytes), where num_bytes indicates how many characters you want to extract from the string, based on bytes. This function is for use with double-byte characters. Converts an Arabic numeral to Roman numerals, as text, and takes the form =ROMAN(number, form), where number is the Arabic numeral you want converted and form is a number specifying the type of Roman numeral you want (1, 2, or 3 = more concise notation; 4 or FALSE = simplified notation; TRUE = classic notation). Rounds numbers to a specified number of decimal places and takes the form =ROUND(number, num_digits), where number can be a number, a reference to a cell that contains a number, or a formula that results in a number. num_digits can be any positive or negative integer and determines the number of decimal places. Enter a negative num_digits to round to the left of the decimal; enter zero to round to the nearest integer. See Using the Rounding Functions on page 414. Rounds numbers down to a specified number of decimal places and takes the same form and arguments as ROUND. See Using the Rounding Functions on page 414. Rounds numbers up to a specified number of decimal places and takes the same form and arguments as ROUND. See Using the Rounding Functions on page 414.

Returns the row number of the referenced cell or range and takes the form =ROW(reference). If reference is omitted, the result is the row number of the cell containing the function. If reference is a range or a name and the function is entered as an array (by pressing Ctrl+Shift+Enter), the result is an array of the numbers of each of the rows or columns in the range. See Using Selected Lookup and Reference Functions on page 426. Returns the number of rows in a reference or an array and takes the form =ROWS(array), where array is an array constant, a range reference, or a range name. See Using Selected Lookup and Reference Functions on page 426. Returns the square of the Pearson product moment correlation coefficient through data points in the arrays known_y s and known_x s and takes the form =RSQ(known_y s, known_x s). Returns real-time data from a program that supports COM automation and takes the form =RTD(progID, server, topic1, topic2, ), where progID is the program identifier (enclosed in quotation marks) for a registered COM automation add-in that has been installed on the local computer; server is the name of the server where the add-in should be run (if other than the local computer); and topics are up to 28 parameters describing the real-time data you want. Returns the position of specified text within a string and takes the form =SEARCH(find_text, within_text, start_num), where find_text is the text you want to find; within_text indicates where to look; and start_num specifies the character position in within_text where you want to begin the search. See Using the Substring Text Functions on page 419. Returns the position of specified text within a string, expressed in bytes, takes the form =SEARCHB(find_text, within_text, start_num), and is otherwise identical to SEARCH. Returns the seconds portion of a serial date/time value and takes the form =SECOND(serial_number), where serial_number can be a time/date value, a reference, or text in time/date format enclosed in quotation marks. See Working with Date and Time Functions on page 445.