We have columns with 50+ items that are unique. Filtering from using a pulldown isn't desired. We need a keyword search. Is this possible? Similar to some...

Excel 2007 - I have a pivot table with a formula in it that multiplies the quantity and price of a product description. If there are no entries in my data...

I am hiding several columns (B:F) and it works, but the button that I have in column D is shifted to column G. How can I hide the button as well?

I have two sets of serial numbers. One is genarated by system and other one is physically scanned number. I have them in two columns and want to identify...

I receive a text file which has a column containing data such as "2010/04". this is not a date and represents the 4th period in the fiscal year 2010 (which in...

Hi there I wanted to add a calendar to an Excel spreadsheet but I can't seem to find the Microsoft Date and Time Picker Control 6.0 in the ACTIVE X control...

Hi All, If anyone could help me, it would be appreciate. I have three columns with numbers and text (see below).The result is in column B and C but I have not...

I imported data from an industry-specific software into Excel. The 09/02/09 date, for example, converted to 20090902 in Excel. How can I change this to a...

Here is my Equation In Sheet 2, column 3, is First name: i would like for only the first character of the name to come up and for the column 2, for only the...

Maybe I'm not explaining what I need very well so I'll try it this way since I cannot attach an example of an excel sheet: In column B, row 8 I have "H"...in...

I resized my worksheet and accidently got it to the point that I can't get to the top to grab it and move it around. I've moved the tool bars and still...

Hello, I have a simple line chart, generated from a list of numbers, many of the numbers are zero, which I dont wnat to show up on the chart. At the moment,...

This seems like it should be simple enough, but for some reason it's eluding me today. I want to "countif" values in one column based on a specific value in...

My sheet is layed out like so: A B 1 Jim 100 2 Dave 200 3 34 4 300 5 ...

Hi, I understand how to use the weeknum() function to conert a date to a week number, but this is only useful if need to convert 1 year. What should I do to...

I have an excel spreadsheet with due dates in a cell. Is there anyway to alert the reader a week before that due date?

A B C D E F G H 4 | Month | J J A S O N Year to...

I have a result of a function that multiplies two cells (currency and a percent) that I would like rounded to the nearest dollar. Where do I tell excel to...

I am currently trying to create formulas in my pivot table to help calculate a certain field. I am dealing with temperatures and would like to analyze the...

Hello, I need some help to breakdown a total months to months in a year, such as total 32 months will be broken down by 12month 12month and 8month total...