I have a column of text labels, with subtotals denoted by "TOTAL", and a corresponding column of amounts. However, the latter includes some B-cells with...

How do I get one? I'm d*****d if I can find the way! Why do they have to change everything?!?!?

Can a cell be named so that when the sheet is sorted, the name refers to the same data even though the position of the cell has changed?. I tried naming...

Hi, I have code as below which will update links.. On error sheet will be unlocked.. how to lock the sheet again and exit sub? Sub...

I have spent all morning filling in an Excel sheet with a lot of data, then moved or copied the worksheet so that I could massage the information without...

Hi, I'm a bit rusty on excel functions. 1st Loan $ is AR1 2nd Loan $ is AS1 Sale Value is AE1 and mathematically LTV = (1st+2nd)/Sale in a percentage format.

I'm using the LARGE function to find the top five values (number) in column "F" of a large list and place those values in Cells N1 thru N5 — Cell...

Is there a way to link information from an Excel spreadsheet in a source workbook to a second (destination) workbook, sort the source workbook, and...

Can I send someone my spreadsheet - pasting from one spreadsheet to another is not working. Dates and other data do not paste correctly and all my data...

I have Excel 2003. I've entered concatenation formula, which is calculating correctly, but the cell itself shows the formula, instead of the result. The...

I have a worksheet with a list of names like this A Staff Joe Suzie Sally Sam And another worksheet that has a pivot table of data that I need to sum

Can vlookup or any other function bring over the cell formatting?

i have three fields like Date description amount 1/2/9 Mobile bill 45 25/2/9 Lycatel (mobile) 5 27/2//9 Shopping...

hello, I have A B C B E 1 c 100 90 c 2 c 100 100 b 3 d 200 80 f 4 d 100 90 d total I need a...

I have an excel file with 5 worksheets saved. Computer was cleaned of viruses. Now when I open the file only one worksheet comes up and no tabs to click on...

I am trying to find out how I can create a form that will add up how many times a certain letter combination appears in a row of data. To help clarify, I am...

Dear All, I would like to split one text file (example bellow) containing several packs of data with the head "MW-....." into one excel file for which each...

In MS office 2005, there was toolbar for the checking of the data by using the text to speech toolbar. Can Anyone guide me where the same is located in...

I think the sumproduct is the correct formula but I can't get this right. I am trying to get a total amount of parts though multiple issues as shown...

I remember using the $ i think to keep a column constant when doing a formula. What is it?