[Update] This conference is no longer available.
Excel Resources
For information on other Excel Resources, such as tips and tutorials, Excel videos, and online courses, see the following pages on my Contextures website.
Excel Help – Online Resource List
Other Online Excel Resources
List of online Excel help forums and other resources where you can ask questions or find answers
There’s a wealth of Excel information on the Microsoft web site
List of resources if you need help with Power BI questions and problems
Links to Microsoft Support Pages on Excel Topics
Great reference – Excel Function Bible (free) by Norman Harker and Ron de Bruin
_____________________
Dear All
I would like to know formula in excel sheet. I have some data in excel sheet such as 199950,145200,239500 and this has to convert automatically as 200000,150000,250000. Please help me with example in simple way. i would request you to kindly send on my above mail id.
Sounds easy Ajay. Please forward $1500 to my bank account listed above. On receipt of funds, the solution to your problem will arrive in your inbox.
Seriously though, you may need to give some more precise information about what you are trying to achieve, and maybe ask Debra directly, or visit an Excel Help Forum like http://www.ozgrid.com/forum/
Thanks Lincoln, a help forum or Excel Newsgroup would be a much better place for Ajay to ask his question. And the answer won’t cost $1500!
LOL!
Would love to go!
Unfortunately, at 3,160 miles according to google maps It’s probably not too practical!!
TheQ47, you could add a few extra days, and turn it into a nice vacation. It’s the perfect time of year to visit the east coast.
It’d mean an international trip, as I’d be crossing the Atlantic (from the west coast of Ireland to the East Coast of USA)
Ah, well maybe Jon and Bob could organize a conference on your side of the Atlantic, sometime in the future.
Hi All
I am currently working on two huge data spread sheets. My requirements is that based on the common unique column which is available in both the spread sheets I need to pull multiple records from multiple columns from spreadsheet one and insert and append to the end of the column in spread sheet two. Any valuable suggestions
==================================================================================
Spreadsheet 1:
StudentNumber Semester English Maths Science Computer Biology
10001 I B B A A C
10001 II A A A A B
10001 III B A A B B
10001 IV A A A A C
10002 I B B A A C
10002 II A A A A B
10002 III B A A B B
10002 IV A A A A C
10003 I B B A A C
10003 II A A A A B
10003 III B A A B B
10003 IV A A A A C
=========================================================================
Spredsheet 2:
StudentNumber First Name Last Name Grade DOB
10001 Mark Good 8 10/12/2001
10002 Jame Hary 8 11/03/2001
10003 Ben Handy 8 3/09/2001
=========================================================================
StudentNumber First Name Last Name Grade DOB Semester English Maths Science Computer Biology
10001 Mark Good 8 10/12/2001 I B B A A C
II A A A A B
III B A A B B
IV A A A A C
10002 Jame Hary 8 11/03/2001 I B B A A C
II A A A A B
III B A A B B
IV A A A A C
10003 Ben Handy 8 3/09/2001 I B B A A C
II A A A A B
III B A A B B
IV A A A A C
=========================================================================================================
Any valuable suggestions and fast approach to achieve this
Look Forward
Thanks
Murali