I created a V-Lookup that should find the description of an article. The
strange thing is, that at first it wouldn´t find the correct description
although the article numer does exist. The correct article number is in row
467 and the other description it showed me was in row 780. ...

I have searched other messages and my brain must be on holiday because
I cannot get any of the answers I found to work for me.
What I have is a column of data which has to now be changed for GL
Reconciliation, looks like this-

I have column filled either with #N/A or a number. I need a formula to
"extract" the first numeric value in that column.
example:
#N/A

i have set number format to 2 decimal places...but for the final answer i
want the answer to be rounded off to the nearest whole number with 2 d.p
for eg
anwer 312.78 should appear as 313.00..

I have a list of 10 possible categories of debt, i.e:
A 0 - 100
B 101 - 200
C 201 - 300

i have created a table in excel but want the edges of table to be slightly
curved instead of being a right angle....is there a way of doing it?

I'm searching in a large table for a specified date with vlookup. the
function returns a value form the 6th column in the lookup table, where the
last argument is set to TRUE.
My question now is: can excel also return the address of the cell with the

I am downloading from my bank (Scotiabank) to an Excel file, is there any
way to download the next day to the same file, so I will not need to cut and
paste?

I have copied some data down from a web site first into a text file and then
uploaded this into Excel using the tab delimited converter.  I cannot convert
the numbers in the colums onto real numbers.  I have tried the following:
Excel functions:

I need to count how many rows ago a new high was made in the last 6
days. In this case 2 days ago a new high was made. How to I get excel
to count that number of rows ago without manually doing this?

I want to set a simple (k-e) formula to apply to all rows in a column
rather than to a finite set of rows. This is because I want people to be
able to add an indefinite number of rows without the formula suddenly
stopping working. Is this possible? (I asked my work IT helpdesk ...

When the Excel file is opened via Windows Explorer,
it has crazy format that I cannot understand,
and I cannot access the data I want to access.
How can the above be corrected

what processor speed, hard disk drive size, RAM size and other
configurations is good for learning VB6 programming. Please, HELP!

I have a Macro that clears a form, and I want it to replace the cleared cells
with original information.
Here is a brief example of my code:
Range("P3,P4" _ ).Select

Can some tell me if there is a way to set excel to automatically calculate
column or row totals in a financial worksheet?