Hiya, Does anyone know if there is a 64bit odbc driver for excel?

Hi! Is it possible to 'autofilter' a list according to the format of the cells? Alternatively, could I create a new list with all the relevant lines of data...

How do I write the formula so it will tell me when another cell input is out of Range. eg B8 may be 1960 and C8 can not be any more than 1860 or less than...

Excel 2003...Is it possible to create an invoice that can be linked to a worksheet whereby selecting a record in the worksheet then activating a custom...

I need to to this with VBA A1=randbetween(1,100)

i have a an excel game that has been taken from a web site and i am trying to figure out how to do this!!!! Can anyone help?

Can someone please guide me to a means of placing numbers in cells without decimal points? I want to build a spreadsheet to track miles. Thanks in advance,...

I had a column of about 2500 with names and mobile numbers in the same cell. I needed to extract only characters from that columns into separate column. I...

I need to extact values from an array when there may or may not be multiple matches to a column value in the array. VLOOKUP does not work because it only...

Hi there. I want to extract an information with base on 2 columns, like the example below: SHEET_1 SHEET_2 ...

Here is what i have i have a table that has 5 columns; Category, Date, Amount, Description, Location. i have made these columns as References if that helps...

I have done a V lookup, which takes an item no. (B:B), looks for it in the 'Sales analysis by items' and returns the value in column 3. Althought if there is...

So..I want to sum a column, but only consider the cell's value in this sum if a cell on the same line has an entry in a different column? Hope that makes...

I have 2 Pivot Tables in a worksheet. They both have Date, Total amount. One Pivot table is producing deposit info from the ERP data while the other one is...

When I try opening a excel worksheet from the shorcut on my desktop I get a blank blue screen with no grid lines and no data. I can click on file and open a...

I am importing an access query into an excel spreadsheet. The query has about 30 fields that work fine. I added a calculated field to the query and...

i can't seem to open read-only spreadsheets (from people using windows xp instead of vista) without having to save them then open. seems there's some setting...

Hi - and thanks for reading this! I have a csv which I need to run a few format routines on to enable me to use it. The first column contains data that is...

I am unable to open a file I have opened many times before but now I get Microsoft Office Excel Security Notice about automatic update of links has been...

I have the following formula that totals data for multiple tabs. Each tab is a month and each tab is set-up the...