-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Venting!
- Thread starter Brian from Maui
- Start date
Excel Facts
Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
I've seen heaps of that -- spent much of the last 12-13 years as a trainer, and people can get precious about their manuals.
I love the fact that if someone works for a big company they are automatically assigned "expert" status -- like, "Yep, that's our model and it's correct because it was put together by a guy from [Insert name of big investment bank here]. Quick scan of the workbook shows that the user is limited to half a dozen functions and could have put together a much more efficient workbook if they knew a bit more about Excel.
Denis
I love the fact that if someone works for a big company they are automatically assigned "expert" status -- like, "Yep, that's our model and it's correct because it was put together by a guy from [Insert name of big investment bank here]. Quick scan of the workbook shows that the user is limited to half a dozen functions and could have put together a much more efficient workbook if they knew a bit more about Excel.
Denis
Darren Bartrup
Well-known Member
- Joined
- Mar 13, 2006
- Messages
- 1,297
- Office Version
- 365
- Platform
- Windows
I had to read a whole two pages of text explaining that I must use text to columns, copy this here, paste that there, turn it inside out, email it to Mars....
Once I understood what it was trying to do, I got it down to these formula:
=TRIM(PROPER(LEFT(A2,FIND(" ",A2))))
=TRIM(PROPER(SUBSTITUTE(A2," ","."))) & "@myemail.com"
And another one which was telling me to sort on a certain column, open another sheet sort that into order on a column, paste them next to each other, copy the results to here, etc... ended up with a simple VLOOKUP.
Once I understood what it was trying to do, I got it down to these formula:
=TRIM(PROPER(LEFT(A2,FIND(" ",A2))))
=TRIM(PROPER(SUBSTITUTE(A2," ","."))) & "@myemail.com"
And another one which was telling me to sort on a certain column, open another sheet sort that into order on a column, paste them next to each other, copy the results to here, etc... ended up with a simple VLOOKUP.
