Hello, I have a list dates and numbers in a sheet and I want to find the DATE cell that is related to the number cell. I could find the Max number but I only...

Here is an update to my question posted last week: I have a spreadsheet with close to 700 lines of information on it. The current format of the spreadsheet...

I have a single column of data that is sparse, in that many of the entries are blank. Since this data is imported from another source, I want to operate on...

ANybody can help?

Can someone give me some advice. Below is an example. Here it goes: In column A, I have dates of when someone started at a job(Aug 15, 2001); In column B, I...

Hi I have a database (MS Office/Excel 2003) which lists all my contacts details in, which I'm trying to import into BCM. I have imported everything ok except...

How do you name a worksheet according to a cell in the worksheet?

Does anyone know why row height and colume width are measured in different units of measure, and what the units are that are used.

hi, as i was exporting my crystal report 8.0 to excel then i found out that my data which was over 255 characters was been truncated .. isit.. excel onli...

I am sooo stuck. Anyone please help. I need to sum the amounts that I pay to different vendors. I have the vendor name in column "H" and the amount I paid...

I am using Excel 97. I want to create one of several form controls that reference several cells. In particular, list box, combo box and combination list edit...

Hi all I am trying to perform what I would consider to be a simple task and for some reason am struggling!! I have entered the number 1 into cell A1, A2 and...

Would you know how to automate multiple text files conversion to excel? Thanks

I have macros setup in a worksheet with macro buttons set to run these macros. Everything was running fine until I saved this worksheet to a different name....

Hi All, I use a Hummingbird BI Query program - whenever I run a query for data and export the data to 2002 Excel, I get strange characters in various cells...

Talitha, You can add days to a date by simply adding that number to the date. For example, =A1+90 will add 90 days to the date in cell A1. If you want to...

Hello, first let me insert the basic framework of my excel sheet: A: B: C: D: E: F: G: H: I: J: 1: 101 105 ...

On an Excel spreadsheet, I'm looking to convert prices (or=20 numbers with 2 decimal places) to the nearest .00 or .05 -=20 for example =A31.42 would round...

Good day, I need help. I can't seem to get anything to work. I'm a beginner I know, but I have tried the Filters using criteria, Piviot tables, and some other...

How do I make a function where I want the following information. If a certain column contains a value less than or equal to zero then I want the information...