by 
ANSWERS: 13
-
Nested IF's
-
Concatenate... That's not a naughty word, but it sure does sound like one.
-
sumproduct ... it produces some answers
-
Exciting isn't the first word that springs to my mind when I think about Excel - useful or interesting, but not exciting. The most exciting formulas on the workbook I'm currently working on are just COUNTs and SUMs of 22 other worksheets to produce a sports league table.
-
Array formulas in general. Like... =SUM(IF(C1:C3="a",IF(D1:D3=1,E1:E3),0)) Which works like a SUMIF but for two conditions instead of just one. (Excel 2007 now has SUMIFS which does the same thing, but you get the picture). Array formula's are very powerful and often clever things.
-
Control F....X....;)
-
=IF(ISNA(VLOOKUP(HLOOKUP(INDEX(A1:K10000,MATCH(C7,H:H,0)1),P1:P300,MATCH(C7,A:A,0),FALSE)),"",VLOOKUP(HLOOKUP(INDEX(A1:K10000,MATCH(C7,H:H,0)1),P1:P300,MATCH(C7,A:A,0),FALSE)))...to name one.
-
I never ever thought that I'd live to see the words "exciting" and "Excel" in the same sentence
-
using VLookups are my favorite.
-
Are you kidding??????
-
-
Use of Text Functions
-
"exciting", and "excel" should never appear together in a sentence.
RELATED QUESTIONS
Copyright 2023, Wired Ivy, LLC