I am importing a report into Excel and I would like to make comments on each
line. But this report will change as I update purchase orders in our system.
It will also change as purchase orders are received into our system. Our
system generates this report and I would like the ...

I am using =NETWORKDAYS(B23,B29)-1 as one of my formulas. I have the -1
because I am tracking several different time frames going from one place to
another and without the -1 it is counting a day twice. I need this formula in
every cell that has the days, but there won't be a ...

My series B13:B20 contains zero's and text values. I wish to count the text
values but not zero's or blanks.
I have tried the following as an array but its counting all cells in range
with the result = 8 which is not correct (as there are zeros and balnks in

I have a query on some data i'm currently analysing and it's causing me a
headache. I'm hoping there is a simple solution to this that doesn't involve
macros.
Any help much appreciated

Example: I want to be able to display "Cathy's Check" in cell G4 by typing
the number "2" in cell B4 but I also want to display "John's Check" in cell
G4 by typing the number "3" in cell B4 as well. Can some one help me please!

What I am trying to do is be able to lookup one number in Column A (Header is
WP), and give me all the matching results from Column B (Header is PMC), and
put display all the results in Column C.  I need to do this without
downloading anymore addins also, thanks for your help in ...

I have a table that I created in a GIS of tax parcel numbers that are in a
specific zoning district. I have another table that was created in my tax
assessing program of all tax parcels in town with parcel location address,
owner, mailing address, etc.

I was wondering why my text formula of proper is not working. I have placed
the formula =proper(f2) in column e2 All I get is the formula =proper(f2) and
nothing else. It looks like it is stuck. When I try to copy down the whole
column e has the same formula. I have tried ...

I  was using the SUMIF command as follows (=SUMIF('Active Data'!Z:Z,2,'Active
Data'!AK:AK) ("Active Data" is the previous tab), and the formula works
great!.... until the criteria for the calulation changed.
Now I require 2 sets of criteria before I sum the AK:AK column.

In excel how do I display every 5th row from sheet 1 and place it in sheet 2?

Im wondering if the following is at all possible in excel?
I want to place a button on the worksheet that on enter (press) it would
duplicate and insert a selected cell range (with formulas) at a set location
below the selected cell range.?

With =COUNTIF(A1:A700,A1) in cell B1 and copied down, entries which have a
space after the final letter are, quite correctly, treated as a different
word and therefore not included in the total for a particular word. IE:
[testing] and [testing ] are treated as different words. ...

i have in sheet 1 a list of 3500 acounts where i have make clear of
important and non important acounts that i need, by give them a simple color
to the specific cell.
Because there nothing to short them by color, at least i have not found

I want to create a checkbox type spreadsheet that will autofill line data to
a total sheet. What do I use? Formulas? Which one, and how?
Ex>>>Cell H63 will be filled in with the amount in F55 if I check G55. Then
check a secondary, (G45), and H64 will will autofill with F45

I am aware of conditional formatting, but what I want to be able to do is
colour multiple cells on a single row based on the 1st cell (being a date)
equalling a date in another work sheet, as conditional formatting only allows
the function to work on the worksheet that the ...