Functions

COUNTIFS with a date for criteria...
I want to count all the entries in column N that occurred between a range of dates specified in the other criteria. The dates are obviously in column B. I use this currently- COUNTIFS(Data!N:N,"=Option",Data!B:B,">=1/1/2009",Data!B:B,"<=2/28/2009") However, I use this similar function in multiple cells, all ... 3 Mar 2010 16:26

Count how many times conditional formatted cells are positive
Once you have applied conditional formatting, is it possible to count the number of cells that turn the different colours? ... 3 Mar 2010 16:26

Index Match with Min
I have 3 columns; Market #, Start Date and End Date Currently when I match Market #1 in Cell A3 the following works =INDEX(MIN(H2:H20000),MATCH(A3,P2:P20000,0)) But when I try and use it to find the same info for Market #2 =INDEX(MIN(H2:H20000),MATCH(A4,P2:P20000,0)) I get a #Ref! Error... Tried array etc...to no... 4 Mar 2010 12:22

search for text then return text
i need a fomula that will search down a specified cells in a column... look at the words in each cell and then display the text i want. for instance... I have a column with words in it and i want it to search through each cell/word for the letter "P"... then i want it to display a "P". if there are one or m... 3 Mar 2010 15:18

allocating numbers to cells
The numbers represent rounds. So a name will go with a round (number) but some names know more than one round. Name a 1 name b 2 name c 3 name d knows round 1 and 2 name e knows round 2 and 3 Is there an automatic function that would allocate "name d" or "name e" to a round if "name... 3 Mar 2010 14:10

How to find next up matching cell?
The formula below works fine. I need replace "?" with If(A3<A2), search up coulmn for first A3 match,C2, ""), Clear as mud? TIA! =IF(A3>A2,E2,(IF(A3=A2,C2,"?"))) -JS ... 3 Mar 2010 13:02

Blank Check?
Please could someone help me with this problem? The formula in cells of column D must check 'Week Number' (column A) to see if it is blank. If it is blank then the cell in column D should remain blank (no value). If the value in 'Week Number' (column A) matches the value in 'Week' (column C), then the number o... 3 Mar 2010 13:02

link only cells with a certain colour
Is it possible to select only the cells of a certain colour or cells without a colour when I link a range of cells from one worksheet to another? Many thanks ... 3 Mar 2010 16:26

Disable automatic text wrap?
It appears that when one cuts and pastes from one Excel spreadsheet to another, it automatically assumes that you want to wrap text if the column is too narrow. Since I almost never want that, I have to go into the "format cells" area and uncheck "wrap text" every time. Is there any way to change the default ... 4 Mar 2010 13:32

report by date from a list of records
Hi The list is made up of records for training courses and includes start and end dates and course duration, i.e. Name of person, start: 1 mar 2010, ends 4 Mar 2010, duration 4 days What I need to do is create a consolidated report to show the amount of days a single person had training days per month/: ... 10 Mar 2010 11:58