I got a excell sheet that the column names have been changed from A,B,C,D ect to 1,2,3,4 ect. I need to change them back to the A,B,C,D ect. How do I do...

I have around 12 sheets with data in the same format, i.e.: Month Client Amount Quantity Branch Product. What code colud help me to consolidate...

I have data on 2 sheets. The basic structure of both is as follows: Zone Branch Client Outstanding Upon creating a Pivot based on Multiple...

Dears, Please kindly let me kow if i can add a new currency symbol in Excel format/cell/currency. I wan to add a symbol for Afghanisan currecy - AFG....

How can i match information from Sheet 1 to SHeet 2 using MODEL NUmber if i have Model Number in Both sheets. Thanks

I have a cell that is formatted as text. It's a merged cell with settings for wrapped text. It will only display # no matter how many characters are typed....

Please help me with a formula, or conditional formatting. i have the situation: a1 = start date, a2 = due date, and 4 cells with percentage from done (25%,...

Dear all, The formula below is ok, but only for one row. How to use it for range of...

In Excel 2007 I have a table named BidBookData on Sheet 1 in Workbook A. I'd like to create a pivot table in Workbook B that uses the data in the...

Sorry I took so long, bugger me; "To send attachments just post a new thread........LOL." Am I that #@%# #@%# Obstinate is the correct word you used for this...

Folks: In column #1 of my spreadsheet, I have a list of hyperlinks. When I hold my mouse over these links, the URL (or email address) associated with...

I have a macro whereby I have cells each a with number that could be upto 2 decimals in length. Example: A B C ...

hello i have he following formula...

Dear all, i hope somene can help - because ive just pulled out my last hair i'll tryto explain - in column A i have a list of 30 names (which may be...

As I work in Excel and do my cut/copy and paste procedures, many times I have no difficulties. On occasion, and apparently from nowhere, I encounter this...

-- JerryG

I currently receive a file that has a list of client ID and each Client ID contants a list of codes listed on the same row of the Client ID. I need to have...

How do I word a worksheet function where both of these is true, IF C18=C20 AND IF C18=C16 gives a 1, not it gives a 0

I've used Excel for years. A few days ago I couldn't open an Excel file attached to an email from a coworker. Since then clicking on any shortcut or an...

I have 11 charts in one Workbook that tall need to have the same backgrounds, bar colors, fonts, etc. How can I customize one and then duplicate the...