We use Excel for our memebrship data, on our zip code entires for NJ and Y which have a leading zero we get a blank. On last number in CC entry we only are...

hi all..! i am having product names in A1:A10 with col header in A1 as "products". B1:F5 having the vendor codes like 001, 002, 003, 004 & 005. B2:F11 there...

An Excel workbook I set up and colleagues have been using simultaneoulsy for years suddenly is not being shared when I upload it to the network.

I am looking for a function that works using a =sumif function to add things that are not in a range that are next to each other as seen below the letters...

I am using Excel 2007 and I can't seem to copy and paste formulas from one workbook to another. Instead I get a dialogue box asking me if I want to use...

Hi I'm trying to solve this problem I have and could use some help, I was wondering if its possible to use VLookup to check through a range of data in one...

If I have the following data A B C D E NY MO IL NJ KS 1...

I have two columns where basically I want to sum all the unique values in column B i.e the 5.89 etc based on the criteria of which number they are in Column...

I have one workbook that has book information such as book code, title and author. I have another workbook that has the ISBN Number and the amount of revenue...

In the past I know I have done this but I can't see the option now to insert a calculated field. Does someone know where this is located? Thanks so much.

When clicking on 1 cell, it outlines 2, I can't "unlock"; check to see if it was merged, it's not. Any ideas?

how could I built a bell gauss or bell frecuency graphic?

I have a column that has these values AA, AX, AW, RJ, WD, CA, IE, NC Now I would like to filter AA,AX and IE only. How can I do it with just one step instead...

Hi, Can anyone write a macro for me so that it takes the current formula I have in a cell and adds a IF function and iserror fuction around it. Here is...

I am trying to merge to time cells, (both set to English (United States), Time Type 13:30) both cells display correctly where I entered them (9:00 and 9:45)...

When I have a spreadsheet #1 and would like it to automaticaly update spreadsheet # 3 in the same workbook, how do I do that. I know that there is a way but...

In Excel 2003 is it possible to set the "Style" of one worksheet to be different than the others? Thanks.

I have a spread sheet that in colum a I enter the time in, B is Time out, C is total time for that period, C is total for the day. Now I am trying to add all...

Can someone please explain the Index, Match formula to me? It is used in a spreadsheet and I need to understand it. Thank.

I am using excel 2007. I want to create an invoice where the total number of line items is dynamic. I have created the 'header' section of the invoice with...