My first row is numbered 28 on the side bar. How do change that to number one, two, three etc...?

I have a spreadsheet that is 3604 rows & 6 columns. Column E has only hyperlinks to URL's. I have filtered my data via column B. I tried to A-Z Column A. When...

A B C D 1 2 4 5 6 7 3 5 4 6 5 7 ... 10 25

i'm having a problem with vlookup not accepting a "reference" to a cell as the "lookup_value" this =VLOOKUP(C2,range,2) returns #N/A but if i manually type...

I have an address list in one worksheet. I have a form in another worksheet where I want to place a combo box that will allow me to select the person's name...

Currently - have data set that has extra blank spaces at the end of the fields - of varying length - what formula do you use to truncate the text fields to...

In the following example column E thru K, are labelled Machine1 thru Machine6 respectively, in only 1 of the columns I mark with an "X", this lets me know that...

I'm having a difficult time with the following sumproduct calculation. The main problem is that I want to sum all cells in column S, that do not have a value...

Dear anyone, I have come across with vlookup funtion which i have to use it at my work. I have two sheets. Sheet 1 has charge codes and value, and sheet 2 has...

I created a great workbook in a prior position that would be useful now. However, I can't remember the password. Is there someway I can recover the data or...

I'm trying to set up an Excel workbook with a dynamic link to an Access database containing quality data, involving dates. I want the workbook to always...

I want to get the parameters of a sequence in terms of Gaussian distribution.I mean, mean value, max. and min. values and standard deviation of that...

I have imported a report to excel which contains alot of blank rows, almost every other row. I want to delete the blank rows so I can use the auto...

This may be too complicated to explain without showing the financial spreadsheet...but here goes. Firstly I have a start date column and end date column for...

-- Incoming & Outgoing mail scanned with NAV

A simplified example of a worksheet to try to explain my question I have a two column work sheet Col A and Col B Col A has no Formula and is for entry Col B...

I have an excel spread sheet from last year in which I put entries and then formulas to calculate totals. I wanted to clear the worksheet so that I could reuse...

I have a column of numbers (based on an underlying formula), starting positive at the top. Somewhere in the column, a number becomes negative. How, using...

In Excel XP you could just drag the field twice into your Pivot table and calculate a sum and an average for example; how do you do the same function in...