Hi. I have a list of data that is about 350 rows dwon by about 100
across, and need elegant ways to present this data. The data is of a
list of stocks from about 10 countries and from about 10 sub-sectors.
If using the data in one worksheet and using dropdown filters, is

Hi guys - I'm a bit of a newbie to this programming lark and am struggling -
I am trying to update a SQL database from a form in excel, below is the code
that exists however doesn't seem to work, actual feilds on Spreadsheet and
SQL DB are as follows

I would like to update an SQL DB called tblnames- it contains the following
fields :  Department;Name;TL;userid.
I would like to update from an excel spreadsheet by entering the relevant
details and then clicking a button.

I am taking a course online about Excel. I would like to know how you would
type a question to find the definition for a result of a formula.
=IF($B$13*E4+D4>$B$15,$B$15-D4,$B$13*E4)
If have tried several methods in type a question to find this definition but

Help
I want to count down to a set time.
In A1 I will have a time in the future (it will normally be in around
3 hours time). In A2 I want it to show hours and minutes to the time.

How can I import Access data that exceeds 65 rows?  I understand that Excel
can now handle 1 million rows - but I cannot figure out how.

In the RANK() function I can rank a value depending on one set of values (one
condition), but when you SORT data you can choose a second (and a third)
condition.
Is there a way to RANK with two sets of values (two conditions)?

Worksheet Menu Bar on all of my spreadsheets not longer shown on pre-existing
worksheets, but does if I create a new one.  The option is selected under
options, and if I go to Customize/Toolbars, the Worksheet Menu Bar is
checked.  If I uncheck it, the bar reappears at the bottom ...

I need to create a spreadsheet to calculate the annual time share
percentages that are allocated to the two parents in a child custody
case.
The time throughout the year is typically allocated in three block:

I am trying to write a formula.What I need is:
On sheet 1 column A I have a list of dates (for next 2 years). With
varying data in column C E G & J.
On sheet 2 A1 I want it to lookup for todays date and display the data

I am attempting to copy financial data from one worksheet to another.
Unfortunately, the worksheet that I am copying from is formatted as
one column of data in column A. The data appears as follows in column
A:

heres what is happening:
the formula is correct, but when i paste it, the value computes to 0,
which is not the correct value.  However, if i paste it then press F9,
the correct calculation appears but the formula disappears, leaving

I have worked out the formula I need to use (with help from someone
from this group).
However how do I stop it returning a 0 when no data is present in the
cell?

When I set the format/alignment of a SINGLE (unmerged) Excel cell to select
"WrapedText", the row height adjusts upward, automatically, to accommodate
the greater height needed by the wrapped text.  (That's good/)
But if I select "WrappedText" for a MERGED cell (e.g., a cell made ...

I am creating a .csv file which includes bank account numbers. Some of them
include zeroes at the beginning but even if I format the column as text, the
zeroes keep disappearing.  
Is there a way to keep the zeroes at the beginning of each cell?