Search results

Hi chronot, Welcome to the forum, you should really start a new thread, please read the rules http://chandoo.org/forum/forums/new-users-please-start-here.14/ With regard to your question turn your data into a Table, selected your data, go to Insert > Table, then when you add to the table the...

My trip to the grocery store There was a bit of confusion at the store this morning. When I was ready to pay for my groceries, the cashier said, "Strip down, facing me." Making a mental note to complain to the manager before leaving the store, I did just as she had instructed. When the...

Like it :DD

Hi Ashish, Take a look here http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705

Hi sreekhosh, This might be a good one to keep for future reference? http://www.datapigtechnologies.com/downloads/Visual_Guide_To_Choosing_Chart_Types.pdf

Hi guitarman, Take a look here http://chandoo.org/wp/2009/03/13/excel-conditional-formatting-basics/

@Aurelie As they say "There are more ways than one to skin a cat"

Hi, When you say you unmerged them, did you select the whole sheet by clicking on the square in the top left adjacent to column A/Row 1?

Hi, I'm still on xl2007 so haven't tried this, but have a read here http://www.excel-user.com/2013/03/install-excel-2013-side-by-side-with.html

Hi Narayan, Firstly a very Happy New Year to you and many thanks for your very informative posts you share with everyone here, please keep up the good work ..... to infinity and beyond :)

Hi syed, Welcome to the forum, please start here and you will find the answer http://chandoo.org/forum/forums/new-users-please-start-here.14/

@Debraj, I know one Ninja who will find that very useful :DD

Hi SirJB7, A very Happy Christmas and New Year to you (and everybody else) :) Thanks for the mention well at least the old British is right

Hi malbarki, Don't forget it is an array formula, so when you copy it and paste it into your other spreadsheet you need to enter it with Ctrl+Shft+Enter More information here by forum member Colin Legg http://www.xtremevbtalk.com/showthread.php?t=296012

Congratulations Oak Ville, now you can celebrate Christmas :DD

Hi Oak ville, Try this in G6 copied down =($B$2/SUM($D$6:$D$10))*D6

Here here or is it hear hear

Ah......... yes :rolleyes:

@Somendra Misra There seems to be a problem with rows 19 and 20, both have 540 but end times are different?

Well am I glad about that! :DD

@ Jake, Snap 71 characters against 74

Hi, Try this =IF(VALUE(A2)>=VALUE(B2),VALUE(A2)-VALUE(B2),"-"&TEXT((B2-A2),"hh:mm"))