Hi there! I've inserted several ActiveX Control text boxes into an excel form. A couple of them are too small and I need to make them bigger but I can't...

Is it possible to use the "Forecast" function in Excel to predict lottery numbers? If so, how?

I wish to add a row of cells that contain “x� or “xx� or “xxx� etc this I can do...

A B C D SL. # Subject Marks Grade 1 English 96 2 History 58 3 Math...

Very basic question guys and gals, I have a formula like this in, say, Cell A2: =+A1 What does the "+" sign do? I think I asked this question in a workshop...

I’ve been having an issue when I analyze results (Survey Monkey) and download into Excel. When I set up the type of question, I used Multiple Choice with...

G'day Everyone Using Excel 2K - 2K3 compatible format Range("G5:G2004") is setup with DateTime Picker. Was hoping to setup a Case Select...

How do I copy a formula in Excel without the prior formatting?

I am working with three tables. In the third table I am attempting to create an "if" formula that will change the equation twice. Essentially, when table...

Hi, I have the following data - Row Date Time in Time out 1 1/1/08 1:05 AM 1:40 AM 2 1/1/08 1:15 AM ...

I use a barcode scanner to make entries into an Excel spreadsheet. How do I get the cursor to move down a column after a scan?

Hi, I have a single column of numeric data that I want to search for duplicates. I know that I can use a "countif" statement with Conditional Formatting to...

I have tried just about every combination I can think of in the "help" section and can not see any way to get rid of "draft"in my printed file in Excel. Can...

Hi all, After some good advice on here I'm using the SUMPRODUCT function to analyse personal expenditure data. It's scanning data on another worksheet to see...

I am working with a spread sheet that has 10 columns with info including names, addresses, type of crops grown and acres. This column was sent to me listing...

Howdy All, I have a table of values in 50 columns by 13 rows. Each row represents Hours for an employee for each project list in the 50 columns What I want...

For bowling average

I have 2 tables which both are a function of time. The number of lines in the tables are different and the time span is not regular . I would like to: -...

I built a model that takes an input "A1" and produces 120 outputs "B1:B120". How do I write a formula that says when A1=C1 export the array B1:B120, then...

This is what I have E16:E39 are various dates (some duplicated) G16:G39 are numbers When H16:H39 = "in" or "ti" then the values in G16:G39 should be added,...