Search results

@SirJB7 That was a pretty good blind shot - well done :cool:

Hi Jamie, I would suggest you upload a sample of your spreadsheet so that we can see exactly what you are trying to achieve as the title and question isn't making sense to me :(

@Luke M I think you got your colours round the wrong way :DD Blue highest, Yellow 2nd

Hi Ashok, We didn't get your file but does this help?

Hi Ashok, It would make it easier to understand your problem if you could upload a sample file http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705

OK in that case, do this first with your data Select the data, copy, select cell A12, paste special, transpose. Now carry out my first answer on that data. BTW I forgot to mention to replace the ; with just a , but I assume you worked that one out for yourself.

Hi NewTeacher, Welcome to the forum, please take time out to read the rules of the forum if you haven't already, here is the link http://chandoo.org/forum/forums/new-users-please-start-here.14/ With regard to your question, try this Select cell G1 and type =TRANSPOSE(A1:D7) in the formula...

Hi Karanbir Soin, Welcome to the forum, please take time out to read the rules of the forum if you haven't already, here is the link here http://chandoo.org/forum/forums/new-users-please-start-here.14/ With regard to your question, maybe this link will help...

Hi Ashok, Given the cell references in your formula try this =ROUND(I4*100,0)&"%"&IF(I3<I4,"▲",IF(I3=I4,"●",IF(I3>I4,"▼",))) I'm not sure where "Cell J" comes into it?

Hi sachin kumar, Welcome to the forum, please take time out to read the rules of the forum if you haven't already? Here is the link here http://chandoo.org/forum/forums/new-users-please-start-here.14/ With regard to your question does this help...

@SirJB7 Well I'm glad you've got that off your chest. I must admit I'm still a bit of a dinosaur and still using 2007 :DD

Thanks for the warning Jeff. :eek:

Hi Sushanth, It's hard to tell without you telling us if you have a formula or format on the cell. For example if in A1 you had .0254, then you had in B1 =ROUND(A1,0), that would give you zero

@SirJB7 Maybe it's not a problem for the OP, perhaps he's gone away satisfied :confused:

@indesignkat Also is it always {digit}{text}//{digit}{text}{text}

Hi, Does this work for you? =LEFT(A2,FIND(LEFT(A2,1),A2,2)-1) copy down

Hi, Try this one using a data validation list

Hi Safequip, Here's another http://spreadsheetpage.com/index.php/tip/spreadsheet_protection_faq1/

Thanks Hui... I didn't know whether to trust that :rolleyes:

This is what I get???

Hi Harshinee, Welcome to the forum, if you haven't read the rules of the forum yet, please take some time out to do it, you can start here http://chandoo.org/forum/forums/new-users-please-start-here.14/ With regard to your files, for some reason I cannot open them, please can you open your...

Creative Problem Solving!! Farmer John lived on a quiet rural highway. But as time went by, the traffic slowly built up and became so heavy and so fast that his chickens were being run over at a rate of three to six a day. So one day Farmer John called the local police station and said...

Hi, Doesn't that do it for you? You can also delete a line from the Table for the previous day.

Thanks Somendra Misra, very well explained :)

Hi Narayank991, Can you just explain how that formula works for us please?