Hi to everyone,
Does anyone know how to validate a List from a Database not sorted?
the point is,
In cell A1 I type a file number to get in B1 a dropdown list with the

Perhaps I can get an answer here. I'd really appreciate it.
I've got 37000 rows of column A and column B
I want to concatenate A to B for all the rows.
my formula is =CONCATENATE(A1,B1)

I need a formula for calculating an even percentage amount between a
specified range of numbers. This is for a pay plan. For example, the starting
salary is $30,000 and the top salary is $65,000; I need a formula that will
give the 8 steps from start to top with the exact same ...

I previously received assistance from Domenic with the great working Formula
below BUT  
can the Formula below be adapted to return the results of  Filtered Visible
Cells?

I’ve been given a spreadsheet to work on, look to be an export from
database.  It has addresses of companies; 3 columns in total: Compan
Name, Company Address and Company Telephone.
Unfortunately I need to separate the Company Address Field to Fiv

Is it possible to increase the size of the font when using autofiltering
dropdowns  in Excel?
Jonah

How do I transfer information in several cells on worksheet 1 to the same
cells on worksheet 3 using a picture button?

In my workbook I have a sheet that contains two columns.  One has employee
name and the second has an employee number. Now, on another sheet I want to
enter an employee number and in the next cell have it return the employee's
name.  How can I do this?

I have two matrices of data which have a large number of the same entries.  I
need to be able to identify the number of entries in one matrix which also
occur within the same column in the other matrix (e.g. how many of the
entries in column A in one matrix are also in each ...

Good Day everyone,
I have a worksheet set up to look like a daily form, columns.
Date:    Amount:      Day:
I want to copy this info after I fill it in in the form the sheet2 and then

In a spreadsheet let's say I have a date in A1.  I could put =A1+1 in A2 to
get the next date.  (I know the autofill works better for this but bear with
me).  
I have a spreadsheet where 5 rows of data belongs to one group/record.  

Sweden!
OK I will make it easier to understand, what I want is a code in vba t
make those combinations:
Say 7 numbers 1 - 10

In cell c4 I enter a value. In column BD4:BD28 this same value appears in
just one of the cells. In column BE4:BE28 I have the value I want to return.
I know with the correct lookup formula I should be able to do this but I am
stumped. None of the columns need to be sorted or in ...

Ok, I have a spreadsheet here at work that someone long gone created...
On the left hand side there are + and - signs that allow you to
collapse sections of the spreadsheet. This is the first time I've run
into this and I'm dying to know how they did it, but I can't seem to

I'm trying to use help in Excel 2003.  I've found a link entitled
'Check if a cell contains text'
This woould appear to be the solution, however, I'm getting an internet
explorer script error on the subsequent links and am unable to get at the