I am using some Now() functions to show the date on current month reports,
but when those reports are opened in succeeding months the dates then change
to the new current month.  Is there a way to keep the data automated but at
month end lock the field?  As opposed to copying and ...

I want to write a macro to sort uppper and lower bounds form a sries of data
(numerical).

How can I break column formatting in Excel so that I can have varied cell
widths in a vertical arrangement?

I would like to create a function to add the amount column for each specified
priority.
For example, all "PRIORITY", 4, would calculate the sum of it's "AMOUNT"
counterparts. (D18+D19+D20+D21+D22+D23)

Any ideas out there?  I have a spreadsheet with an unknown number of rows
(1-100).  I am trying to concatenate in one cell the output of each row.  I
can use a count function to tell me how many rows to concantenate, but is
there some type of repeat function that will move down ...

I'd like to use a COUNTIF function with criteria being all visible rows set
in the column filter. Thanks-

I would like to create a function to add the money in the "amount" column for
each specified number in the "Priority" column..
For example, all "PRIORITY", 4, would calculate the sum of it's "AMOUNT"
counterparts. If Amount what Column D and Priority was column

Here is an example of my data:
Org                                     criticality                        
score
Corporate Marketing               critical                            100

I'm trying to figure a way to simplify this COUNTIF formula by using the OR
Function.  It works the way it is, but it seems like I should be able to
make it more simple.
=COUNTIF('Week 1'!N$3:N$10000,"CR")+COUNTIF('Week

Here is the data I am working with:
LOB                              C/N                       #
Corporate Marketing                       2
Corporate Marketing    Critical                   1

I have a mortgage calculator which calculates the outstanding amount on a
daily basis.  This gives me a huge column of figures, which eventually turns
negative somewhere around the middle, depending on how much I am repaying!
I would like to put a single cell at the top of the ...

I have a list of servers in column A, some of the server names are IP
addresses.  I need a macro that will determine if the server name
listed is an IP address and if so, do a specfic action.
Example Spreadsheet

I have a formulat that is not working.
Basically I want a formula that will take up to $100,000 and  multiply the
cost per thousand by $5.75
if the amount is over 100,000 to $1,000,000 I want it to take the first

Is there a way to get the sheet name to show up in a cell? Say sheet name;
"Pear" tp show in cell B2 of said sheet?
Thanks,

I've been tasked to getting to the third standard deviation.  I know
Excel has the STDDEV function, but that only takes you to the first
deviation, right?
Is there a way to use the STDDEV function in Excel to get to the third