My table looks like this:
Customer    NOVA    VAB    Date    SW    HW
A    1        12-Jun    1   
B    1        12-Jun        1

I'm trying to figure out if there's a way to find and replace the last
two digits on a list of invoice #s if they end with a 01 (replacing
them with nothing). Here's a sample list:
190369734601

I created a dynamic named range(Daily_Postage) from data on
sheet1(Import_Postage) that basically includes only the rows that have
data.  Works good.  Now I want to display that new set of data on
sheet2 without spreading formulas around in each cell.  Thought I could

I need to sum a column and the condition has multiple criteria:
SUMIF($G$16:$G$28, between 5 and 10, $E$16:$E$28)
how do I represent "between 5 and 10"?

I'm trying to create a UDF that allows users to input to binomial
experiments and the results will be a p-value for comparing the
proportions.
My function crashes everytime I try to use an excel built in function

In A1 I would like a command that searches for text, located in Col B1 within
a range called VLRange1.  The cells within the VLRange1 may have the unique
name like "Bob" or it may be in a small memo like "Where is Bob today".  I
could not get Vlookup or Lookup or Find to work. ...

I can't figure out how to read a date in a formula.  In my column I have the
format set as mm/dd/yy, but the formula is looking at MMM and it is not
converting.
I want to add sums of money based on month, not mm/dd/yy and I think that is

I have a spreadsheet showing:
Vehicle arrival times - 07:05. 09:01, 10:00 etc
Vehicle departure times = 08:06, 18:32 etc
Type of vehicle - 7.5t, 17t. 40t etc

I have a nubmer of days that needs to fall into a certain week number for
pricing calculations.  If the number of days is 3:8 then it is 1 week; 9:15
is 2 weeks; and 16:21 is 3 weeks.  Right now the function is able to
correctly calculate week 1 and week 2.  If I try to insert ...

Ok I've a list of entries with values
essentially looks like this
ID     Description    Value
What i need is to hide the row if the value = 0

Is it possible to make phone numbers some sort of link in Excel so that when
you click on it, it dials that number?

I need to change the percentages in my assumptions, but it has to equal a
dollar amount shown in my problem. It has to be in a formula so I can then
goal seek it.  HELP PLEASE!!! I dont know what else to do.  Thank you,
Jackie

I cannot use Text-to-column as the alpha spacing is inconsistent.  Is there a
formula that I can use to pull the alpha (or numberic) prefix from a text in
Excel.
Ex:

I had a look through the forum but could not find what i need, can
anyone out there help?
I have a sheet that works fine and am just fine tuning the last bits
and I need a little help please.

I have been able to insert objects onto my spread sheet. For example a Adobe
pdf file.  What in the world has gone wrong?