I am trying to count all the "Nissans" in column a where in the same row in
column b is blank without having to create additional columns, I am sure that
there should be a way of creating a countif and statement but do not seem to
be able to make it work.

Is there a formula that I can use to find the prime factors of a given number?

Dear friends..
i want your help regarding this subject.. can anyone help me?
actually, i have a big database in excel.. dont want to go last and first...
i want to know in certain cell (B1) which is the last entry had done in A:A.

It has been some years since I needed this application.  On an Excel
spreadsheet I need to enter [via VBA Editor] a sequence of 3 macros which
will activate a "running total" in each cell.  I have the code, but not sure
how to enter [type] in the Editor page.

Is it possible to Autocomplete the Forms-ComboBox?
Like the "fmMatchEntryComplete"-functionality from his "brother", the
Control-Combobox...
Best Regards Sige

I have two lists on two sheets in one book (two lists were required because
I have about 85,000 records). One column in each list contains 'Class Codes'.
I want to produce a report that counts the combined total of each class codes
across both lists. The problem is that while ...

I have several spreedsheets that users enter some data and then the results
appear on 'Report'!A1:N28 spreedsheet. Is it possible to click on (let say)
an
actionbutton on the "Report" sheet to automatically save the cells A1:N28 as

is it possible to dump rows of data into a spreadsheet and automatically have
it insert a blank row between?
ex:
asjdflasjdlfjak;lslf;a

I have 2 files i need to compare one is a file from our customers and one is
a file from our office but in their files are missing information which are
in our files how do i compare the two to show me the difference between the
two in  excel and they are not in the same order. ...

            I want to Split text ina cell in to two parts in to the
other cells. Here I'm giving an example of my problem.
In cell A1 = B1OL(03) nOW WHAT i NEED IS
In cell B1 = B1OL

Just wondering if anyone knows if i can do a formula to add up all green
filled cells in a workbook???

I have been trying to compute a data table and have hit a road block, my
table looks like this,
           1%        2%     3%   4%    5%
2400    692        692    692   692   692

I need to interpolate two points (x0,y0) & (x1,y1) to find the y value for a
given x. First, I need to find x0 and x1 from a column using a lookup
function. The x's column increases as you go down.
For example given a data set:

I need help with pivot tables.  I have created a pivot table with an open
order summary.  I want to subtotal the units of each order and $ amount of
each order.  These currently appear singularly by line item.  Thanks!

unable to view color fill color changes and font colors when I click the tab
to change colors.  I can only view it by Print Preview.  This does not happen
on any other computer I use.
I should be able to see the new color I selected in fill or font on my