At work, base on several parameters, we assign risks (1=Low Risk, 2=Medium
Risk and 3=High Risk) to each account. Customers may have 1 or more accounts.
We have decided that the risk to assign to each customer will be the same
risk of the account having the highest risk. That is, ...

I have about 10000 social security numbers currently parsed out in the
following manner:
Column 1 000 Column 2 00 Column 3 0000
I have tried to use CONCANTENATE to move them back over into one column, but

Someone has suggested using the analysis toolpak. Is it possible to do this
withouth the toolpak and do it using date functions.
thanks
suzie

I am wanting to import data from a table in Access, which I've done, but need
the numbers to work in Excel formulae. The numbers are importing fine, but
the calculations are not happening, unless I go in to the Excel worksheet and
retype the numbers...then the formula will work.. ...

Here is what I want to do (for example):
If A1 > A2 then use the formula in B1
If A1 < A2 then use the formula in B2
Two different formulas that use the same variables.  In the above example,

I am working on a timesheet in Excel and seem to have come upon a strange
quirk/error. The timesheet is supposed to take two times, find the difference
and then display it in decimal format.
For example:

Since it took me a while to fine tune this macro, I thought I'd post it
in case anyone else can use it.
This macro selects 3 consecutive cells at a time and looks in those
cells for values.  If all 3 cells are blank, that row is deleted.  If

I need excel to take the date in column B and the percentage in column L and
add the percentages for each month and separate the sum by month.  I then
need to create a line chart to reflect the data.

Is it possible for excel to remind me with a pop up that i have to update a
cell?
Like i updated cell A1 rite now. Now i'll have to update the cell B1 after 1
hour.

Is there a way to have a formula dynamically select the end of a list.
For example I have a list in Col A that can range from 10 - 5000
entries.  I want to dynamically sum this (without always just selecting
the max size because there is information below the list).  I also want

I need help creating a formula for the following,
if cell K12 is not divisible by 12 then return "OK" if its not divisible by
12 then return "not ok"
Thanks for your help!!!

Is there a keyboard shortcut to bring up the excel sheet tab menu (Insert,
Delete, Rename etc.) without right clicking the mouse over a tab?

I'm building a sheet that pulls data from another worksheet based on a
customer number, so when I enter a customer number into cell it will pull
specific information.  The part I'm stuck on is this....There are varying
numbers of rows below each customers' data depending on the ...

I'm badly in need of some help with an excel formula. Essentially I
need to check to see if the value of C7 is "Y" and if so for the
formula then to look at D7 through to J7 and look for a value of "Yes".
the total amount of "Yes" boxes should then be multiplied by J5 and the

I have routine that updates previous workbooks by copying sheets within the
new workbook and getting the old sheet information.
Everything works great, but for some reason after more than 45 sheets are
copied it errors out.