If you only had 10 Excel Functions what would they be?

[brianmock]

If you could only use 10 functions what would they be?

What formulas allow you do do the majority of your work?


I use INDEX, MATCH, YEARFRAC, concatenate, IF daily how about you?

 

[Colin Legg]

I clicked on the insert function button (to the left of the formula bar) and filtered by category 'Most Recently Used'. It shows:

INDEX

CUBEVALUE

CEILING.PRECISE

WORKDAY.INTL

TEXT

AGGREGATE

SUMIF

CLEAN

ISLOGICAL

SUM


I don't think they're the ones I use the most though. IF and MATCH which you suggested are definitely up there.

 

[keymaster]

Interesting question...


I would go with


sumifs

if

index

match

sumproduct

iferror

countifs

workday

edate

mid

 

[Hui]

Chandoo


I think this would be a great Quiz for the main Chandoo.org site maybe early next year


My top 10:

==========

Sumproduct

Index

Match

Eomonth

Linest

Norminv

If

Rnd/Randbetween

Text

Int

 

[vasim]

Here's mine...


getpivotdata

index

match

offset

countifs

sumifs

iferror

networkdays

eomonth

date

 

[Faseeh]

My top 10 Functions

[pre]

SUMPRODUCT
OFFSET
MATCH
IFERROR
IF
ROW
TEXT
RANDBETWEEN
LOOKUP
SMALL

[/pre]
Regards,

 

[sgmpatnaik]

Wow interesting question it is


My Top 10


INDEX

VLOOKUP

IFERROR

SUMIFS

SUMPRODUCT

IF

MATCH

COUNTIF

TEXT

RANDBETWEEN

 

[DJ]

my top 10 functions would be


Index

match

Vlookup

sumproduct

countif

iferror

If

concatenate

clean

trim

 

[Marc L]

Classicaly :

AVERAGE
CONVERT
FIND
IF
LEFT
LEN
RIGHT
ROUND
SUM
SUMIF
VLOOKUP

 

[Sajan]

Here are mine (in no particular order):


IF

INDEX

N

OFFSET

CHOOSE

SUMPRODUCT

IFERROR

MATCH

ROW

SIGN

 

[kaushik03]

Here is mine:


IF

INDEX

MATCH

ROW

VLOOKUP

OFFSET

SUMPRODUCT

SMALL

IFERROR

TEXT


Kaushik