frequently

I have been using the following formula which works fine, but I would like to be able to change the Year part of the dates and wondered whether there is a way of referencing a cell value which would contain the year and therefore make it easier to change, I was thinking about the Indirect...

I have a worksheet full of data, across which I'd like to see what words are used most often in it? Then to see all results, from most frequently used, to least frequently used words? *I'd like to be able to do this both across a worksheet, as well as along a column, or row? I know the...

I have a worksheet full of data, across which I'd like to gauge what words + 3 words on either side appear most frequently in that set of data. To begin, I'd like to see what words appear most commonly in this data. And then to search for some of those words + 3 words on either side them. So...

Hi all I have a DDE-Sample.xls file which I downloaded from the Forex Factory website and found it ran well for me collecting the current selected last prices every second. I would like to modify the data collection rate to 4 hourly or at least less frequently if that were possible. Does...

Hi, I would like to see what the most frequently occurring text occurs in the whole range, not just line by line. How do i combine all? i.e. A1:F8? And ignore blank cells? I see there are a multiple threads and posts on this topic already, but all focus in on 1 row or column at a time. Any...