I use Excel a bit but I don't have much experience with formulas. I'm finding more and more things that I would like to put into a spreadsheet and have Excel...

What formula or particular statistic can I use to determine what the population would be ...say in 2010 in a city if I have data from 6 previous years with...

I'm using VLOOKUP to search for an exact match of a cell but when it can't find a match it returns #N/A. Now, I KNOW, that there sometimes won't be a match...

In a database of say 10 columns and 100 rows, how do I record a macro that will o Insert a new column to the left of column A, then o in the...

I am randomly entering data in previously created Transmittal log, as I get it, and after I am done I want the area that say\'s weld number to all be...

I want to associate letters of the alphabet with numbers so that when a letter is put in a cell, a numerical value can be associated. Sort of like a phone...

Can someone tell me how to get the button for sending an excel file with an attachment via email by just clinking the button. I cannot get the button to open...

can anyone tell me pls if it is possible to sort my worksheets alphabetically? I have about 30 or so which I would like to sort after renaming them.

I am making a table in Excel. I tried to format my table and I was not able to customize the width of the borders in my table. How could I do that? Your help...

Hi, I'm facing a little problem and I have no idea how to solve this, so I hope some of you guys can help me out on this. I'd like to see a time of for...

OK guys/gals - I know this MUST be simple, but I'm very new to excel. I'm trying to look at one column (A), if the work "Dist" or "Sale" is in the Cell, I...

Do someone could help me solving the following problem U E C 2'000'000.- 1'000'000.- 5'00'000.- Initial amounts -20'000 ...

Hi all, I have got 3 columns with the column headings as follows Column : A B C Firstname ...

how do i create a toolbar that the macros run on the active worksheet and the macro addresses don't change when the worksheet is renamed?

5489 4861 3481 5448 8461 turns to 5489 4861 3481 5440 0000 how do i maintain those numbers?

I have a 'master' spreadsheet that I would like to add additional tabs to. I'm not having any problems moving the worksheets into the document but when I try...

Hello- Is there an easy way to remove the "highlighted yellow background" in all cells in all worksheets of a workbook, but leave the data in the cell? So,...

Hi, I am looking to use a tick mark and an X for incorrect in a cell. I can't find either in Excel. Does anyone know how I might go about getting them? I'm...

I think I posted this but I can't find it anywhere so here goes again: A1 displays "Week 1". I want B1 to display "Week 2" using a formula. I learn how to...