Middle | search
Click here to view Middle news from 60+ newspapers.
Bookmark or Share- MEDIAN function - Microsoft SupportReturns the median of the given numbers. The median is the number in the middle of a set of numbers. If there is an even number of numbers in the set, then MEDIAN calculates the average of the two numbers in the middle.
- Find and remove duplicates - Microsoft SupportHow to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.
- CONCATENATE function - Microsoft SupportLearn how to concatenate text strings in Excel using the CONCATENATE function. Our step-by-step guide makes it easy to join two or more text strings into one.
- Using IF with AND, OR, and NOT functions in ExcelIn Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportIt's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
More
