To get detailed information about a function, click its name in the first column.
Note: Version markers indicate the version of Excel a function was introduced. These functions aren't available in earlier versions. For example, a version marker of 2013 indicates that this function is available in Excel 2013 and all later versions.
Function | Description |
Returns a reference as text to a single cell in a worksheet | |
Returns the number of areas in a reference | |
Chooses a value from a list of values | |
Returns the column number of a reference | |
Returns the number of columns in a reference | |
Filters a range of data based on criteria you define | |
Returns the formula at the given reference as text | |
Returns data stored in a PivotTable report | |
Looks in the top row of an array and returns the value of the indicated cell | |
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet | |
Uses an index to choose a value from a reference or array | |
Returns a reference indicated by a text value | |
Looks up values in a vector or array | |
Looks up values in a reference or array | |
Returns a reference offset from a given reference | |
Returns the row number of a reference | |
Returns the number of rows in a reference | |
Retrieves real-time data from a program that supports COM automation | |
Sorts the contents of a range or array | |
Sorts the contents of a range or array based on the values in a corresponding range or array | |
Returns the transpose of an array | |
Returns a list of unique values in a list or range | |
Looks in the first column of an array and moves across the row to return the value of a cell | |
Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. | |
Returns the relative position of an item in an array or range of cells. |
Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
HELLO GET OUT OF FINANCIAL MESS WITH THE HELP OF drbenjaminfinance@gmail.com
ReplyDeleteI have been in financial mess for the past months, I’m a single mum with kids to look after. My name is REBECCA MICHAELSON, and am from Ridley Park, Pennsylvania. A couple of weeks ago My friend visited me and along our discussion she told me about DR BENJAMIN OWEN FINANCE of (drbenjaminfinance@gmail.com); that he can help me out of my financial situation, I never believed cause I have spend so much money on different loan lenders who did nothing other than running away with my money. She advised, I gave it a try because she and some of her colleagues were rescued too by this Godsent lender with loans to revive their dying businesses and paying off bills. so I mailed him and explain all about my financial situation and therefore took me through the loan process which was very brief and easy. After that my loan application worth $278,000.00USD was granted, all i did was to follow the processing and be cooperative and today I am a proud business owner sharing the testimony of God-sent Lender. You can as well reach him through the Company WhatsApp +19292227023 Email drbenjaminfinance@gmail.com
THANK YOU VERY MUCH
Hello Everyone,
ReplyDeleteWelcome to the future! Financing made easy with Prof. Mrs. DOROTHY LOAN INVESTMENTS
Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. DOROTHY LOAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via profdorothyinvestments@gmail.com
Services rendered include:
*Refinancing Loans
* Car Loan
*Truck Loans
* Home Loan
* Mortgage Loan
* Debt Consolidation Loan
* Business Loan [secure and unsecured]
* Personal Loan [secure and unsecured]
* Students Loan and so many others.
For more info; Contact us via Email: profdorothyinvestments@gmail.com
With Prof. Mrs. DOROTHY LOAN INVESTMENTS. you can say goodbye to all your financial crisis and difficulties as we are certified, trustworthy, reliable, efficient, fast and dynamic