I see that I can instert form control/option button, but what I need is to have a list of questions that can each be answered Yes/No Question Yes ...

I want to round a number after I apply a percentage to it--for example: =F11*1.02, then round the number to the nearest 100. Is this possible? Thanks,

Is is possible to define a condition depending of the text color of cells ? Thank you

Does any one know how to take a column in a worksheet that has several words in it and sort them by a specific word? eg; M Walter c/o ABC I dont...

Simplified scenario: I have column A and column B with multiple rows of variable data in the column A cells (i.e. account numbers). I want to return a value...

Hello, I have equipment that need to have a maintainence checks every 3/6/12 months. I have created a workbook for this data ( equip, week and days)....

This is a copy of a spreadsheet I have: A B C D E F 1 Name Grid Years FTE Amount Allowance 2 John...

Want to copy the content of a coloum ( eg Coloum F ) from 10 different excel workgroup to a Master excel workgroup. (ie. to copy the content of coloum F from...

Good day, I am hoping for some help solving an Excel problem. I have a sheet with 2006 data and another with 2007 data, both have identical layouts, however...

We have a VLOOKUP fetching prices for various options. On one option the user has to ask for a specific price. This means that in our price list we have the...

I have an Excel spreadshee with 16000 Employee Numbers. I need to put a Zerro in front of each number to have a nine didget number. It can not go at the...

I use Excel2007 and save in 2003-file format for compatibility. I wrote VBA code to create an in-cell drop-down list based on a certain value in cell B6. As I...

How can I use CF to change appearance of cells if say $A1 was either the word "Highway" or Highway Line". I want these to return the same conditional format...

I have a drop down box with many Factors. when the user select one factor below I like the data to show up as correct format on the out put . How can i do it...

http://roundandbrown.wordpress.com

I have a pivot table which works beautifully but have and oddity that while it doesnt affect results, its annoying and odd. In my data, I had formerly items...

Hi, I have four: A = Name B= Employee Start Date C= 6monthReview D= AnnualReview I want to put a formula in columns C and D based off of the Employee

I need to allow users of a spreadsheet to only be able to type a certain number of characters in a paricular field. How would I do that?

Is there anyway to automatically remove unique entries on excel 07?

Hi All, I have one formula saying =IF(SMALL(Range,3)=0,0,SUM(Range)). I named this range by selecting 10 non adjacent cells in Row1. It works fine But.....If...