How can I write a formula for a column of colors, (some have numbers, some don't) that will go down the column and look for Interior.ColorIndex 36 (light...

Hello to all! I want to start an inventory cycle count program in my company. How can Excel be used to do random selection? The only data I currently have is...

How do I reconcile two sheets with in a .xls book?

Hi! I could use some help with filters. I have a spreadsheet I distributed to others to complete and return to me. Once I got the copies back I combined...

I've exported a load of data into excel but the info in the columns I want in rows and vice versa. I'm sure there must be an easy way to flip them.. Can...

why would a value in a cell as shown here 8212.0011( return a value of 8212.00110000.00 when the ( character was deleted from the cell? The version of excel...

In one colum I have different years eg. 2009, 1979, etc.. In the next column I have 2010. What I'm trying to do is subtract from each colum to show how...

Is there a formula to obtain a total for each quarter which excludes including the year? Thus avoiding having to change to year on a yearly basis. Your...

How can we hide pre-selected groups of graphics elements with the touch of a cell or control? We have two distinct groups of rectangles with gradient fills. ...

Hello there, I am using IF function to return values as digits. Now I need the sum of such digits in a coloumn. Pease help me to do this. Thank you Jeevan

Could someone tell me how to make an Excel spreadsheet to track intermittent FMLA? I do not know very much about Excel, so any help would be...

I created a hyperlink to a pdf file ,it flashes and closes whats wrong??? \\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf I can make...

Can someone tell Both the standard formatting toolbar to show For example B for bold the Dollar sign $ and back ground bar like the color icon to appear

Hi, how can i make this code work in Combo Box (Activex Control) to populate data fields in excel? I got it to work in Combo Box (Form Control) but it will...

When a user selects the 14-Mar-01 standard date format in Excel 2007, then selects the custom format option, this is the standard format that...

I have a lot of sums I have to add up, and was advised by my boss that it would be best to use Excel to do it; however, i'm having a hard time figuring out how...

Hi, How do you search for data from a table having 2 criterias? Example: Month Name Score Jan John 3 Jan Mark 2 Jan Tom 4 Feb John 5

1. How can I create a Pivot Table from a text file, downloaded from a mainframe database? I have been told this could be done in previous versions of...