Search results

A wife texts her husband on a cold winter's morning: "Windows frozen" The husband texts back: "Pour some luke warm water over it" The wife texts back: "Computer completely knackered now"

I went to the pub last night and saw a large girl dancing on a table. I said, "Nice legs." The girl giggled and said with a smile, "Do you really think so?" I said "Definitely! Most tables would have collapsed by now."

1.My mother taught me TO APPRECIATE A JOB WELL DONE. If you're going to kill each other, do it outside. I just finished cleaning. 2.My mother taught me RELIGION. You better pray that will come out of the carpet. 3.My mother taught me about TIME TRAVEL. If you don't straighten up, I'm going...

Hi Danny, If the data in the upper cells requires larger cells why not use wrap text and make the cells deeper that way the columns can be adjusted to make the lower data look more acceptable.

Looks like things are back to normal now Guys, probably just a hiccup :awesome:

Another alternative =IF(C5="","",TEXT(E5,"MMM"))

Hi Saha, You could add another column to give you the day of the week as well =CHOOSE(WEEKDAY(WORKDAY(B2,D2)),,"Monday","Tuesday","Wednesday","Thursday","Friday")

@Luke, Just to add to your assumption if the Lead Time varies for each day then you could use =WEEKDAY(WORKDAY(B2,D2)) copied down Whoops - Looks like he got the correct result :)

Hi @SirJB7 Thought this would find you, long time no see! Some would say that middle word means beverage or fuel or anti-freeze. Beverage sounds best to me. ;)

Thanks for sharing Narayan :cool:

Hi I'm sure @SirJB7 will be interested in looking at this one :DD:DD:DD

Hi Safequip, How about =ROUNDUP(A1*2,0)/2 or =MROUND(A1+0.24999999,0.5)

Hi Vipin, You could take a look here http://chandoo.org/wp/2010/11/01/vlookup-excel-formula/ http://chandoo.org/wp/2010/11/02/how-to-lookup-values-to-left/ Or if you have some spare cash http://chandoo.org/wp/resources/the-vlookup-book/ - that would make Chandoo happy :):):):awesome::awesome:

If it's getting that bad you may need to consider changing your job?

I've got a headache after reading that :confused:

Hi, Hope the headache gone now! :DD:DD:DD

Hi, To help people understand the problem perhaps Debraj should have pointed you to this link as well http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705

Hi Mahantesh, Just to add to Somendra's reply you can read more here http://www.k2e.com/tech-update/tips/143-using-two-minus-signs-in-excel

Hi Harsh Khajanchi, Welcome to the forum, , what ever you do first make a backup copy of your data, just in case. Then as Faseeh said it would help if you could post a sample file, please put dummy data in it, but retain the same format.

Hi ganeshm, Remove the space before the "spaceOUT"

@Lohith The formula doesn't appear to work, try '+46 12345678 # Lohith

Hi Why not select your data in columns A1:C1852, then go to Insert > Pivot Table Put "Status" in column labels, "Urgency" in row labels, then drag "File Entry" into values to do a count. This will then show all in the different urgencies

Thanks for the feedback and glad to hear it helped :)

Hi rstotty, Welcome to he forum, can you please upload a sample of your spreadsheet? http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705

Hi, Yes with numbers in column A and this in B1 copied down =CHAR(64+A1)