Is it possible to create a complex COUNTIF that will count the number
of rows in a range where, for each row, column A = 100 and column B is
greater than 5?
I realise that I could create a formula cell on each line that contains

Please Help, I really tried on my own.
Column A and Column B
If the cell value in column A1 is <6 format should be Blank
If it is 6.0-6.99 then it will look to B1 for more info

I have data (number) to be imported from a database to Excel workshee
the long of this number is up to 20 digits. when exporting it, the las
digits (after fifteen digits) become zeroes. For example
82000032656565612345 becomes 82000032656565600000.

Once, when I opened more than one Excel file the Minimised Windows Task bar
indicator would show " (2) Microsoft Excel" and if you hovered over it a
drop-up list appeared so you could select which file I wanted to use.
This no longer happens, I just get one Microsoft Excel ...

or can I define one ?
I'm really using a lot of paste values, and it's pain in the *** to use
right click menu every time
Regards,

I want to insert a File open dialog box in an existing macro.  How do I
accomplish this?
The file I want to open and run the macro on is a .TXT file.  And at the end
of my macro, I want to save it in "C:\My Documents" folder as an Excel

I have and extremely weird question or at list I think is odd.  Is ther
any possible way in whish I can translate the language of a column o
worksheet or workbook.  For example click a column and get a menu o
options to change the language

i posted this in general forum but i think its better suited here -
got a worksheet such as this:
SequenceId Musician Initial YOB YOD Instrument
1 Micheal A. 1975 1999 Chello

Here is my scenario:
I have two workbooks in one xls file. Workbook 1 takes values from
Workbook 2 and formats them as a receipt. I have 10 products on
Workbook 2, each with a different name and a different price.

It seems Search fucntion is not working so I am posting this questio
here for which the answer must have been already available.
In one sheet I have couple of columns and one of the column has count.
From another sheet, I need the rows that has maximum count and minimu

I have a report I do each month.  On the report there are cells where
data is entered.   (numbers)  I would like to be able to put the data
in the cell and then have excel output the data to a chart in excel.
Would be a big deal to do?

I need to go from this:
apple
orange
widget

I have  two columns (A) and (G) that have like product codes however
they are not in any particular order. In columns (H) and ( i ) are bin
numbers that are associated with the product codes in column (G) I
would like to put these bin numbers in columns (E) and (F)

I'm trying to create a Macro that does the following:
1. Copies the values of 12 cells from Sheet1 to Sheet2.
2. Perform an import of data from a database that will over-write the values
in the 12 copied cells.

In Excel is it possible to use 'Replace All' function in hyperlinks
Normally, if you do a replace all in excel, it replaces the contents o
the cells but not the hyper links. I want to change one particular wor
in around 100 hyperlinks in one particular master file. Pls use you