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...

Hi, Is there anyway that we can get the Detection to flag partial name matches in a populate list of matching words? I have an example here. At cell B6,...

I want to analyze 36 months of historical sales figures to see if I can identify any time-series that will allow me to project them into the future. My rusty...

Hi. I have a column of stock tickers, and the next column is their share price. Is there a way to automatically pull their prices when I open the workbook...

I have a column of Vendor Comments on the Outreach effort such as "Client's case is closed" "Client lacks transportation" "Client is 8 months...

I need to calculate a monthly payment but the interest method will be 365/365 or 365/360, 30/360, or 30/365. My question is - can I use the PMT function for...

Problem- Problem- Excel not recognising or counting values between '0.01 to 0.99' in cells containing formula. Exact sheet can be downloaded at-...

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...

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...

Hi I'm trying to do an advanced lookup that matches 3 criterias so, i though i could use SUMPRODUCT but the...

Hi: I need to know exactly what xlnm is, because it's messing me up. I have two excel files, one used as a database and the other as a reader, {Showing the...

Hi I receive requisition spreadsheets that I want to populate and reply to the sender or senders. Currently I need to open the sheet, enter info, save and...

ANybody can help?

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...

I would like to find the SMALLEST value in an array that is GREATER than lookup_value. However VLOOKUP returns the LARGEST value in an array that is LESS than...

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 ...

I am using Office 2000, and my sole learning source is EXCEL HELP. At present I use cut and paste to get all the data from sheet1 onto sheet2 so I can print...

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...

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...