i'm not a user of exel , but i have to convert an exel file (.xls) to
mysql database ...
trying to use alot of converters , but failed , because the exel file
has macros in it ...

How to round values to the nearest 1000?
Like: 12,549,235 > 12,549,000
Like: 12,549,735 > 12,550,000
According to Help I should use =ROUND(P9,3-LEN(INT(P9))) but the result

When I summarize by every change in column A and sum the other columns it
works. But I to have the data in Column B as well.  It just populates a '0'
because I am summing the totals of Columns C - D.  I don't want to sum Column
B I just want the data to be brought down to the ...

I have the following formula in colmun Q    
=IF(ISNA(Q12(T8,CPT!$B$64:$B$89,FALSE)),"",VLOOKUP(T8,CPT!$B$64:$D$89,3,FALSE))
I also want to add the condition that if in column I the age is less than 50
then return a value of blank.

I have multiple defined ranges that I called "List1", "List2"..........
all the way to "List61".  I could manually input the new lists names
into the function everytime I fill down but this is a tedious job.  I
was wondering if there was a way to have a the function call a seperate

Is there anyway of scrolling through all worksheets in a workbook in print
preview.  Rather than having to close the print preview, select the next
worksheet and then go to print preview again.

Hola me pueden explicar por q no funciona esto: ?
Range("e1").Formula = "=SI(BUSCARV($C2;$C:$D;2;0)=D2;BUSCARV(C2;$C:$D;2;1);
BUSCARV($C2;$C:$D;2;0))"
La formula en la hoja funciona correctamente, pero quiero ponerla desde VB.

As you can see I am totally a noob to excel. And I have another noo
problem needed to be solve. can someone please help me once more.
Quetion #2: per say, I have a table of data, and I would like to exce
to return the matching values from the table to a2.

Hi,
How can I set up a sheet when the value is greater than 1.5 the product
will shown as 0.01 and every 1.5 it increases the 0.01.
for example, if a1=1.5 then a1=0.01, if a1=3 then a1=0.02, if a1=4.5

Just trying to figure out how to implement a search function, as
follows...
sheet1 contains all the data to be searched;
example:

Hi;
Can any one help me in putting a formula for partial search (word) in a
coulam or row and result would be the cell value containts that
searched word or value.

I have a workbook with six sheets. Four of these sheets behave quite
normally.
However, one sheet, which should print on onto two pages, shows four pages
in Print Preview. The extra (unwanted) two pages have a continuous line down

I need some help.
I have two columns in a sheet, A1:A100 and B1:B100, in which it is:
The first column A1:A100, have some data (numbers). In the second column
apply B1=A1, B2=A2,……..B100=A100. In the B101 i am trying to apply the

I not long ago had Great Info Provided By Max similar to what I'
requesting here, but hopefully a bit simpler.
Now that I have a way to ID duplicate Phone numbers accross multipl
sheets, I want only the name and number of these dupes applied to

I am trying to run vlookup for about 5K cells from range of 20k cells.
Now the problem is that some of the cells include only numbers and some
both numbers and letters, like AB11002.
I also have empty spaces on the data so I have to run trim on both data