bad

Hi, I have a workbook template that you can input a string and it will pull the picture from a directory or internet. The only issue is when it gets quite bulky, some of them result in a picture can't be displayed but unsure why as if I was to run the ones that don't pull the image one at a...

Hi , I have the look up table below <tbody> A B C D E STATUS YES YES GOOD NO NO FAST BAD </tbody> <tbody> </tbody> i have a table of data below and i need to pick the correct status based on the rules in the look up table. <tbody> name A B C D E STATUS craig yes yes no no...

Hi guys, I researched some data for my project, and the problem is that it's shown as quarterly, so instead of having 2005, 2006, 2007 etc. I have Jan-March 2005, April - June 2005, July - Sep 2005 etc. What's the formula to change it? I tried everything, I'm really bad with excel anyway so I'm...

Hello, I am sure this is an easy question, but I have not been able to get it to work for me. I have 5000+ rows that can contain both numbers, alpha and a mix of both. The column is formatted custom '000000000000000' (15). What I need is if the cell contains anything other than 15 (no spaces)...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

hello all... how to solve lookup data this below : <!-- Please do not remove this header --> <!-- Please do not remove this header --> <!-- Table easily created from Excel with ASAP Utilities (http://www.asap-utilities.com) --> <table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF"...

I thought this would be a pretty straight forward formula to create, but I'm not getting the result that I intended. I have a few dozen check boxes on a worksheet(Sheet1). I have their values displayed in cells on a different worksheet(Sheet6). I've transposed the values on Sheet6 to Sheet1...

<tbody> D E F G H I J K L 11 name age complaint response days drug symp repeat R.resp 12 Shyam 33 pain good 2 a ss y good 13 Sunil 24 fever good 5 x aa n bad 14 Aji 46 colic good 6 f ss y bad 15 Tom 34 fever bad 2 g dd y bad 16 Mathew 23 fever good 4 c ab n good 17 Sucy 17 pain...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, if is possible for anyone of you, I need your support so that to create a vba code, which should “SUM” rows based on text string criteria as my below extract. Should...

I searched for a similar topic but couldn't find one so here goes: I am looking for the best way to sort survey results and present comparisons and I think a pivot table may be my only option. My question is, how do I keep a consistent answer set across multiple instances of the same question...

Hello guys, so i have this problem in excel where I need a fomula to sort words separated by commas and code(in this case its coded as 1) them individually in each field. brown, fox, is, lousy, fox, fox, is, bad, fox -- sample word. this is stored in a single field so as I separate them...