I have a query with merging cells.  I know how to merge cells from one sheet
to another (just learnt that).  I have an inventory list and as I purchase
goods I want to put the information on one sheet and have it merge to another
sheet for other purposes.  On the other sheet can ...

I was wondering if an array formula was best for this or hopefully there
is a shorter way?
I have a sheet (Base) which has the information for interrogation and a
summary sheet (Monthly).  I wish the monthly sheet to extract data from

I am trying to write an If statement that uses wild cards, but it is not
working. My formula looks like =IF(A6="109*",85,IF(A6="110*",75,0)). A6 could
have a value of 109: Consumer Construction 1-4 Family Residential and I don't
want to have to type out the whole value. Is there ...

how to change colour of text in true or false formula
e.g. True Black  False Bold Red

I am A MP and I am trying to create an excell doc that will track the time
that has elasped from the date a case is open to the present date is this
even possible. thanks for any help. For example a case was entered on date
"A" and it has been 49 days sence that date.

I'm having a little trouble with a VLOOKUP function where I have a
range of values spread over 9 columns with the lookup value appearing
somewhere in the first column. What I need to do is have the function
select the appropriate column based on yet another criteria. So, say I

I have a conundrum which is proving very difficult.
I have a month set of data which has each day of the month as a heade
and then a series of metrics under each day. What I need to do is sum
days worth of historic data from and including today.

I have a worksheet where using VBA I am inserting a new row and setting
cell values
in the new row to values specified in other worksheets. I can control
the values I want to refer

I'm a newbe having problems with the functions IF and AVERAGE. I have a
spreadsheet with about 1322 rows. In Column "B" I have a value that
ranges from 0-10. In Column "D" I have numerical data.
I want to average only those rows in Column "D" that have a certain

Greetings!  Am trying first experience of creating a VBA function that is
called via a cell formula in a worksheet, unsuccessfully so far.
Steps have been to paste code into a workbook module such as:
Function CellType(c)

I work for a county jail and I am trying to create a data base to manage
inmates. I hope I can explain what I am doing in order to get the help I
need. I have 7 worksheets in 1 workbook with 10 columns in each. Each sheet
is the same. in 3 of the columns I want to put in a YES or ...

First i dont even know is this is possible orif i am using the right program
but...i would like to set excell for a football pool where each players pick
is matched against the outcome of that game and will enter the value win or
loss i used the formula =IF(AND(D2=B2,D2<>C2) ...

I have a regression analysis done on a template form that I want to update
itself every time I paste in a new set of data. I noted that the simple
analysis within a plot will update / recalculate -- but the more detailed
analysis in the Data Analysis section will not.  How Can I ...

Good morning everyone,
Quick question...
I need "NO MATCH" to appear in the cell rather than the value of the
closest LOOKUP match that satisfies the formula. How can I do this?

I have list of products that are tied to rates.
one product has 5 rates and the second has 10 rates.
The product is chosen by a drop down box
I have a lookup to create a table with the rates- this is range named "rates".