Here is my situation. I have a group of numbers in column a that I need ranked. The catch is that I only want to rank the numbers that have the...

I have an worksheet that counts the number of cells containing a...

i want to imput fractions in excel but i dont want excel to simplify them is this possible? because im trying to input 2/60 and it changes it to 1/30...how do...

I want to set up one cell (F41) to contain data validation that verifies that the entered contents are greater than the contents of another cell (F28). Since...

Hi, I know that it is possible but i don't know process to do it. I have several users (5) who should have access to the same XLS file (under Excel...

If I type in cell a1, for example, 450, and then push enter, is there a keystroke that I can type that will put the same thing in the next cell. In...

A template to assist folks in planning for a hurricane, including an evacuation plan with what to take with you. ---------------- This post is a suggestion...

I have an excel workbook. When I open the workbook, I dont see the workbook but it's there. I can see the macros in VBA editor and I can see the properties,...

The current number format is general. I would like to change it to accounting with no $ and 2 decimals. I can't seem to find how. I'd appreciate any help that...

I'm working in an excel with columms that I grouped .. ex .. columm A & B & C is one group columm D & E & F is a second group etc .. now I would like to...

I have an excel workbook that started as 148kB and is now 2.6MB, but the size increase is for no apparent reason, I'm not aware of doing anything other than...

I have an expense reporting template which I have locked certain cells that I do not want changed while allowing input into other cells. This is under...

I have several thousand rows in my spreadsheet. My question is that I want to look at the value of one column and based on its value, change the value of...

I grouped my columms in excel for ex. group one is columm A & B & C group twoo is D & E & F etc.

Hi all One of my colleagues has a workbook with 110 charts in it, he has made some mofications and updated ranges etc and now receives the error 'no more...

I am creating an inventory spreadsheet for my workplace. I wanted to list the products as well as list their respective UPC/Bar codes. I am not sure how make...

I have a worksheet that I protected so that no other users could mess up my formulas. I only protected those cells with formulas but I want all users to be...

combine duplicates clmns then delete duplicate Customer 2000sales 2001 Sales 2002 sales Joe Smith $200.00 Joe Smith ...

We are looking at having separate workbooks (with one worksheet) to track time worked on specific portions of a project. I'm envisioning that each person...

Is there a way to randomize several columns of data without having to add an additional column and then generating random numbers and doing a normal sort?