Count and Counta in Excel
Count formula in excel will count the numbers present in the cell of the selected data whereas counta formula will…
Round in Excel
To round the decimal numbers as many digits in excel we can use round formula in excel. example shown in…
MAX,MIN,LARGE,SMALL Function in excel
MAX formula will return the maximum value present in row or column. N formula will return the minimum values present…
Countif and Sumif in Excel
The countif function count cell value by given criteria and sumif function sum the values of cell by mentioned criteria.
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…
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…