Series & Data Frame in Python
The Series is row or columns like object contains values and data frame contains row and columns like object as…
2021
Xlookup Function in Excel
If we want to vlookup something in excel it should be in left to write order otherwise vlookup will not…
Unique Formula in Excel
formula in excel is used to find unique values in a row or column and results list of distinctive element.
IF and Nested IF in Excel
IF formula in excel is used when one condition in bracket will be true then it will give result as…
Substitute and Replace in Excel
The Replace formula is used if we want to replace any character by its position. Substitute formula is used if…
Str.isspace
t will return True if all the characters in string are whitespaces.
Lower ,Upper and Proper Formula in Excel
The Lower formula in excel will result in all lower case characters. Upper case formula returns all characters in upper…
Find and Search Formula in excel
The Find and search function is used to find text or characters in cell. Both will return the number at…
Formulatext function in Excel
t is used to document formula of a cell in sheet.
Text Join in excel
It is used to join two or more cells and have more useful than concatenate function in excel. It can…