ANybody can help?

Is there any way to copy a full date (mm/dd/yyyy), past it into the cells below, but have the year change to the prior year in descending order? Specific...

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

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

I am currently using 2007 - I have about 20,000 rows by 12 columns of information in a spreadsheet. Column "G" cells will at times have more than 1 number in...

I want to convert a spreadsheet that has 9 fields into a block of text. From this in Line 1 in an excel file (9 fields): 300 Shady Grove 15720 Shady Grove...

I have a list of number: -17 9 5 -9 -4 12 -2 -11 -23 29 10 -11 8 0 -1 -8 11 1 -8 3 The sum of those number +1 is the answer to the current number, but what...

I have a matrix of data that lists part numbers in row and serial numbers in column as shown in Example 1. In the example below (Example 1), the range...

Hi, I am new to VBA. Can anyone tell me how to capture Close Application (i.e. close all workbooks) event in Microsoft Excel using VBA? I know that, when i...

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 column of cells which contain some cells with values (ie: 4,6,3,5,7 etc.) and some blanks (cells which possibly will have values if circumstances are...

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

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'm trying to do an advanced lookup that matches 3 criterias so, i though i could use SUMPRODUCT but the...

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

In Excel, I keep setting the "always create backup" in the "save as" toolsoptions menu, but it keeps on getting erased. How can I automatically produce and...