Search results

Hi westend9876, If it worked the first time, give it a try =SUM(IFERROR(((A1:A6/B1:B6)-$G$3)^2,0) Ctrl+Shift+Enter

Hi Firasath, Welcome to the forum, I can't seem to download your file from 4shared, please can you attach it in your post? See how to here http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705 Thanks

Hi bhavin shah, Welcome to the forum, please take time out to read the forum rules if you haven't already, you will find the link here http://chandoo.org/forum/threads/new-users-please-read.294/ With regard to your question, what exactly is happening with your dates?

Hi ang_smiles, Welcome to the forum, please take time out to read the rules of the forum if you haven't already, you can find them here http://chandoo.org/forum/threads/new-users-please-read.294/ With regard to your question here one way to transpose your data with a little help as it's not...

Hi, Or do you mean one sheet tab per month - 12 sheets, then one each sheet dates of the month?

Hi Pasterdoc, Welcome to the forum, from your question it sounds like something like this might be useful? http://chandoo.org/wp/2014/01/02/download-free-2014-calendar-daily-planner-templates/

@NARAYANK991 Perhaps I've read more into it? :oops:

Hi Dennis, Try this =IF(AND(D3>0,D3<10),"*",IF(OR(C3="",D3=""),"-",C3/D3))

@Faseeh, They need to be sorted in numerical order

Hi Marsoni, Welcome to the forum, if your data is in A2 put this in B2 and copy down, then filter the table by column B, the files will then be in order...

Hi, How about using COUNTIF()

Hi Somnath, To do the whole range in one go, follow these steps Select the range B4:B136 Select Conditional Formatting > New Rule > Use a formula to determine which cells to format Enter =C4="" then click the Format button and Font, Bold, color - Red >OK See attached

@SirJB7 Doesn't works on row 12 - William will have to correct one's like those :(

I thought for a minute Justin Bieber had joined the forum :DD Welcome Justin

Hi Mohammad Younous, Try this =OFFSET(C2,MATCH(MAX(C2:C30)+1,C2:C30,1)-1,0)

Cardiovascular Exercise The older we get the more important it is to incorporate exercise into our daily routine. This is necessary to maintain cardiovascular health and maintain muscle mass. If you're over 50, you might want to take it easy at first, then do more repetitions as you...

@Ashish Batham Your file didn't get attached?

Hi Abbas, You may find this useful for question 1 http://wordribbon.tips.net/T009632_Wrong_Values_Merged_from_Excel.html

There is also a quick way in correcting things, by using the Find/Replace menu, for instance I notice that after using the Proper function (UK) got changed to (Uk) so see attached. BTW where UK is without brackets that also has been changed to Uk, but when you use Find/Replace for that one...

Hi, I would say that probably some in your spreadsheet should be all capitals i.e. BDA DESIGN probably BDA Design, only you can answer that one? But have you tried using the =PROPER() function as dan_l suggested?

Hi Safequip, Please can you give us some examples of what you want, or alternatively upload a file?

Hi Abhijeet, Take a look here, it gives three different examples, either with formula, conditional formatting or VBA

Bryz, The drop down arrow on "Related risks", then select "Text filters" and play around with those until you've found the right one ;)

Rick, Just to add to Faseeh great formula, you could enclose it in a IFERROR(), again with Ctrl+Shift+Enter and drag it down the column

@Ashok Thanks for the feedback, glad to hear it helped, any issues please let us know