Remove Junk values in
Excel:
Often while working in Excel, You will get Junk values, the
simplest way to remove the Junk values is by applying the Formula Clean.
=CLEAN(Text)
Sum the values based
on the condition:
For Example, Assume we have List of materials and the number
of counts, but we have total counts on the specific material, we can use the
SUMIF formula.
=SUMIF(RangeOfThingsToBeExamined,CriteriaToBeMatched,RangeOfValuesToTotal)
No comments:
Post a Comment