Functions

Programming style with worksheet functions - discussion invited
As a self taught Excel user I appear to have developed a personal style that differs from most examples of spreadsheets that I see. One issue is the use of named ranges. I observe that I rarely use expressions such as = L9 * "Master sheet"!$F$15 / 100 , prefering instead to name all variable and arrays ... 30 Mar 2010 17:17

Unique Rank with Duplicate Entries
Hi, I have a question about a slightly complicated Rank function I want to write, and I'm having a problem with it. Say you have the following data: Bob Jim Bob Dan Bill Jim Bob Matt Bob Jim Dan Matt Greg I want to make a list that ranks these entries in order of how often they appear, and tha... 30 Mar 2010 15:01

Formula for counting cells with value 'x' provided Col U = 'y'
Hi guys, Need some help with a formula please. Have tried myself and know that the answer is straightforward but going through a mental block! Col Q Col R A01 58 A01 62 P02 62 Both columns data starts in cell 14 and runs down to cell 10000. I need to count the entries in Column Q that =... 31 Mar 2010 13:16

setting cell values based on a 3rd cell
Hi - can anyone help me with an Excel 2003 question? I'm working with 3 cells: a1 [format m/d/yyyy h:mm] - contents= 1/1/2010 b1 [format m/d/yyyy h:mm] - contents= null c1 [format text] - contents "CLOSED" All column & cell values are loaded in from a csv file. I can't [i.e. don't want to] place a formula i... 30 Mar 2010 11:39

Unique Rank with Duplicate Entries
Hi, I have a question about a slightly complicated Rank function I want to write, and I'm having a problem with it. Say you have the following data: Bob Jim Bob Dan Bill Jim Bob Matt Bob Jim Dan Matt Greg I want to make a list that ranks these entries in order of how often they appear, and th... 30 Mar 2010 11:39

1-4-1 is not a date how do I stop excel from changing whats enter
is there anyway to stop the auto format I need to enter 1-4-1 1-4-2 1-4-3 etc... and the data showes up as dates in the cells I hate this auto function and I would like to shut all auto features off they never help ... 30 Mar 2010 11:39

How do I set up a formula to add column a if column b = cell c
I am looking for something similar. I have 2 columns that I need to count A B 8 Yes 2 Yes 6 No 4 Yes I need to count the number of Yes's in column B for each number, so lets say I need the number of Yes's for 8. How can I do that? Is it even possible? I tried using countif but I can only get it... 30 Mar 2010 10:32

Rows to table
I use a sheet to store different modules with start and end time in a table (tab1). In the second sheet (tab2) I want to show all modules sorted in time (rows) and per day (columns). Tab1 should be used as sheet to modify data and Tab2 should be used to present a tabular overview per day. Now I import to Access... 30 Mar 2010 09:26

copy formulas with fill handle
I have two spreadsheets and want to link info from one sheet to another. I have totals at the bottom of columns and I want to be able to put those totals into another spreadsheet. I want to do this with the fill handle instead of entering one by one. I have totals in lets say B66,C66,D66 and so on. I want t... 31 Mar 2010 22:11

to lookup data for 'today()'
e.g A B C D 1 Date (From) 01 Jan 2009 01 Feb 2009 01 Mar 2009 2 Date (To) 31 Jan 2009 28 Feb 2009 31 Mar 2009 3 Actual Qty 205 217 300 4 ... 30 Mar 2010 09:26