Register now or log in to join your professional community.
Vlookup
data sorting and filtering ;)
Depend upon nature of your work in your organization. There are approx200 functions as per my experince pelase see below functions which are mostly use.
Sum
sumif
sumifs
count
counta
countif
countifs
average
averagea
averageif
averageifa
vlookup
hlookup
if
index
match
iferror
text
and
or
len
left
right
uper
lower
proper
substitute
1.Sorting2. filtering3. Vlookup4.PIVOT
Sum average and filter
I think Vlookup
@sum()
Vlook up & Sumif
people mostly use Vlookup