Search results

Deleted as it didn't work EDIT: Sorry about that, thought it was better to delete it than leave you with something wrong. Try this: http://speedy.sh/J6qTY/Team-Selector.xls Just put new team names in DATA. Not sure if the long runtime is because of the quality of my work machine or what...

Hi all, Odd question here (I've already tried the search to no avail) - I need to take a sample from a large data set (~600 entries) so I can make a graph that's a bit more readable. The data is year-on-year turnover (2011 vs 2012). I'd like to take either a random sample or systematic...

Hui - in your spreadsheet if you put 0, 0, -1 in as your search value you get B as your output, not E. I think this is the only combination of -1, 0 and 1 that doesn't work for it though. This is because the gradient of the two lines are the same, and this is what Correl() is comparing, so...

A few questions: Are there letter codes for all 9 possible combinations, or is it just the 4 above? If not, how do you determine "best"? e.g. the series 1 0 0 is equally close to B and D, which would you want as your result?

This isn't quite as simple as it sounds, as it depends on what you mean by "month", but the best way to do it would be to multiply by 12 and divide by 365.25 (or 365.256363004 if you want to be particular, but I doubt it), then round to 0dp, so use =ROUND(DAYS*12/365.25,0) EDIT this will...

Thanks Luke. Looks like that involves using some third party things, which is an issue on a work machine. Getting the data series and all that to work isn't an issue, it's just having this axis is a bit ugly when it's not needed.

Any admin about to deal with the bags95760 post?

Is it possible to hide/show an x or y axis with a checkbox? Basically I've got a chart with two y axes, one showing value, one showing volume. I'm controlling if value or volume or both are plotted with two checkboxes, is there a way to say "If (linked cell) is true, show (y1 or y2)"? I'm...

If you're happy using some VBA code, try this: Private Sub Worksheet_Change(ByVal Target As Range) Set CheckRange = Range("E3:E100") 'this is the range you're checking for a condition For Each Cell In CheckRange If UCase(Cell.Value) = "EKC" Then 'replace the =...

I've been thinking about this myself, it seems to me that it must be possible, but without seeing the code (php/html/both) for the website I doubt it can be done - there are way too many ways of creating a table across these to give you a general case.

Ok, so conditional formatting in excel 2003 (and later versions?) gives you the option for three criteria. These are applied in order, and excel stops looking at the format for each cell when it's found a criteria that it matched. In order to give a solution I think you're probably going to...

wow, that's much more sensible than the way I was looking to go about it.

To clarify, are you looking for something that would say 1 crores, 11 lakh, 3 Sau 1 ek, or 1.1100301 crore? (Also am I understanding the number system here right - not one I'm familiar with?)

A possible solution would be to insert an "Output" sheet with a circular reference on it that effectively adds one each iteration, and to check the setting in excel to perform the iteration on a button press. Use this with some kind of lookup value (return nth from the sorted list), and hey...

Thanks Narayan, Unfortunately I think my work computer may just be a little inadequate, so I'll have a play at home and see if this works.

Unfortunately most of the creation of this is based on guesswork and half remembered coding, plus possibly misunderstood dissected macros. 1. Yes, it should reset, my bad; 2. & 3. I think I probably need to define another range - I'm trying to say if the value of the active cell is more...

Hi All, I recently came to the conclusion that my spreadsheets just aren't colourful enough. To that end, I decided to bodge out some VBA code to give me a full range of cell shading from RGB(1,255,1) to RGB(255,1,1) - increasing red by one each iteration and decreasing green by one. Perhaps...