Search results for query: *

Hi, I am trying to find a quick way of counting the number of contiguously connected sub-ranges, within a larger range, that meet a specified criterion. For example, in the range A1:C10, there may be say, 7 cells with values above some specified threshold, let's say 1 for the sake of argument...

Hi. In a workbook, I am trying to write a function in a cell which returns the size of the overlap between two specified ranges. I think the range intersection operator is a space, so I want to write something like: = Count($A$1:$E$5 B2:F6), and I expect to get the answer 16 (i.e. the number...

I just realised that the "Save Workspace" feature has been removed in Excel 2013. Does anyone know of a workaround? I was considering writing a macro to: create a new workbook note all open workbooks and the settings, (number of windows, positions, placement etc.) store that data in the...

I'm trying to write some code which will allow me to do some simple image analysis, manipulation, and display in Excel. I think I have an issue with version compatibility though. Below is an example of some simple code which demonstrates the problem. It is currently set up (just for debug...

Recently my version of excel at work has started to have an annoying quirk with chart data highlighting. Normally, in excel, If you create a multi-series XY chart from a simple rectangular data range, for example: X values in cells A2:A5, series labels in cells B1:D1, Y1 values in B2:B5, Y2...

I first posted this in the office forum, but Skip sensibly suggested I try here. So here goes... This is driving me nuts. I have an Excel workbook with several sheets, including chart sheets. I have set this up to show several of the sheets in their own windows, including the charts (and some...

This is driving me nuts. I have an Excel workbook with several sheets, including chart sheets. I have set this up to show several of the sheets in their own windows, including the charts (and some of the rest - mainly as an "input area"). I need to let the user click a point on one of the...

Does anyone know of a quick & easy method to determine whether two cells have the same conditional formatting? The question arose from one a colleague asked me. First I tried F5 special to see if that would help, but no joy. Then I tried vba. if I directly compare the .FormatConditions...

The words in the following list all have an interesting property. Can anyone tell me what it is? triennially, chainlet, grounded, schooled, baignet, board, allele, also, ours There are loads of other examples out there. So for extra marks, why not suggest some? Tony

There are various standard toolbar button whose state toggles - e.g. format painter, select objects etc... I would like to have a button which does the same thing. Is this behaviour a property of the button somehow? In which case, how does one choose a "toggleable" button as opposed to a...

This is a weird one. I have a macro which is taking a surprisingly long time to accomplish fairly simple tasks. Furthermore, each time I run it, even though it is running on the same data, it takes longer. The workbook has several sheets but the two relevant ones are "Kids Cascade" and...

I have a worksheet with a whole slew of shapes (rectangles) connected by connectors. Don't ask why, it really doesn't matter and it would take too long to explain. The key point is that it looks a bit like a family tree. I want to be able to manually select any one rectangle, then use a...

I have a worksheet with a whole slew of shapes (rectangles) connected by connectors. Don't ask why, it really doesn't matter and it would take too long to explain. The key point is that it looks a bit like a family tree. I want to be able to manually select any one rectangle, then use a...

A colleague of mine has an odd problem with array formulae. He is using a twin PC setup with single screen and single keyboard. He has a "KBM" switch to shift between the two PC's. The system also monitors the keyboard for certain key combinations. Specifically, it gets into a muddle if he...

This issue touches on NLP (Neuro-Linguistic Programming). NLP involves how the words we use affect people. So, given that... "This forum is for light-hearted discussions on words, word usage, grammar, and related topics to improve our ability to communicate effectively and to help project the...

In a recent post, I referred to this site: http://www.word-detective.com/ For those of you who did not follow the link, you might like to try it. The site's sub-title is, "words and language in a humourous vein on the web since 1995". The content is similar to Uncle Cecil, but is aimed...

This is not really a question about words as such (though I'd like to know the name of something), but I do think it is about making an impression. Have a look here: http://xkcd.com/657/ You may or may not find the joke funny, but click on one of the panels (e.g. the LOTR panel) and have a...

Every year I look forward to Christmas, not primarily for the food, or the time off work, or the presents, or even the getting-together with family, but because it means another of Gordon Gray's Christmas puzzles will be available. Sad huh? Well, maybe, but I'm not alone because it is an...

It occurred to me it would be usefull to be able to "comment out" cells in a spreadsheet, the same way one can comment lines of code. So I wrote a couple of subs to do it. See below: Public Sub Comment_out() Dim rng As Range Dim mode As Variant mode = Application.Calculation...

I recently used an array formula in a workbook where I wanted to find the mean of all the values in the range "data" which lay on the odd-numbered rows. The formula I used was: ={average(IF(ISODD(ROW(data)),data))} This gave a VALUE! error. However...