Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Could you recommend an Excel book?
Could somebody recommend me a book with some advanced Excel functions. I
don't need a book for beginners and I don't need a book that repeats simple functions discribed in free Excel help menu. e.g. I found this formula recently "=SUMPRODUCT(--(B1:B100=1),--(F1:F100="Done"))" and I wish I found it a couple of months ago. I knew the "sumproduct" formula, but I did not know that it could be used this way (I still don't know what "--" means). So, maybe somebody knows a book about Excel with interesting problems and advanced ways to solve them. Thank you, Evgeny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
excel as address book | Excel Discussion (Misc queries) | |||
hyperlinks in an excel book | Excel Worksheet Functions |