Search results

Hi bines53, If your letters are in column A, then put this in B1 and copy down =CODE(A1)-64

Hi bines53, Try this, select your data A1:F1 Go to Data Tab > Sort > Options, select Left to Right > OK > OK

Hi Piyush, You need to save your workbooks first to be able to carry out linking, are both workbooks saved?

Hi lalande, Welcome to the forum, it's difficult to see exactly from your picture, but have you tried making the column width wider?

Thanks for the feedback Sadi and glad to hear it worked for you ....... and your colleague :)

Hi EPTowers, You could just use the Data sheet in Somendra Misra workbook and use the filters at the top or use a Pivot Table to get the results you require

Hi Rahul, This is your fourth vague question so I think it's about time you read the rules of the forum, if you wish to part take and expect people to respond then you need to abide by the rules http://chandoo.org/forum/threads/new-users-please-read.294/

Hi Alkuan, Welcome to the forum, it might be worth your while reading this very interesting article by Jeffery Weir a Moderator on this forum http://chandoo.org/wp/2013/09/29/i-said-your-spreadsheet-is-really-fat-not-real-phat/

Hi Sadi, Welcome to the forum, take a look here http://office.microsoft.com/en-gb/excel-help/where-are-the-autocorrect-options-HA010215826.aspx#_Toc266447359 You may also need to copy your Custom Dictionary to the other computer

Hi msexcel, There are plenty of examples, tutorials and videos here, perhaps this will help? http://chandoo.org/wp/search/?q=pivot%20tables%20tutorial

=If(Formula,TRUE,FALSE) Excel doesn't recognize "checking" it's not a word used. So we start off with:- if it's >2000, it's "high", if it's >500, it's "medium" otherwise it's "low"

@bobhc, No No .......SirJB7 uses both hands to hold the bottles :DD

Hi msexcl, Welcome to the forum, try this =IF(A1>2000,"high",IF(A1>500,"medium","low"))

@Luke M Congratulations on your newborn, hope you will be able to type one handed as the other will be holding the babies bottle ........ mind you I bet you're already an expert at holding a bottle while typing :DD

@json, At least it works, BTW you missed an "A" out :DD

Hi Akash, Here's some information on Windiff http://support.microsoft.com/kb/159214

Hi MGCummins, Welcome to the forum, try copy/Paste values only

@Hui , Thanks for correcting me :oops:

Hi @dolphintabby , To ingnore the negative numbers put this in F2 and copy down =IF(C2="","",C2-B2)

Hi Oscar, Can't the time values be entered as actually times in your spreadsheet, rather than in separate cells. It would make it much more simpler. ;)

Hi, Try this =I30+VALUE(J30&":"&K30&":"&L30) =I31+VALUE(J31&":"&K31&":"&L31) BTW Format your average cell to hh:mm:ss

A couple were Christmas shopping. The shopping centre was packed - as the wife walked through one of the malls she was surprised when she looked around to find that her husband was nowhere to be seen. She was quite upset because they had a lot to do. She became so worried that she called him on...

Hi Kcprakash, I'm not sure whether there are some typo's in your example where initials should be in uppercase, but if there are then you could add to @Hui 's formula with the PROPER() function...

Thanks for the feedback ang_smiles, you've got two options now so best of luck ;)

Hi Darren, I would suggest you upload a sample file with some data so we can see exactly what you are trying to do?