I have a large qty of numbers within a column with many duplicates (2300+ rows). What function can I use to find and eliminate all duplicate numbers?

I'm trying to create a list of models from a column that has multiple models with duplicate entries. example: column a model b model c model b model a model a

I need to freeze several rows at the top of my spreadsheet and several at the bottom so that both the top and bottom remain in view whilst a user scrolls...

Pulling a value into a cell is easy. But can you go the other way, ie, can you send text to another cell and then have that cell be a value not a formula? Or...

=IF((C3=1,I3=100%, IF(C3=2,.I3=.80, IF(C3=3,I3=1.25, IF (C3=4,I3=0, If(C3=5,I3=0))))))

I have been researching and trying to figure out how to get a spreadsheet do some counting for me. I am on active duty with my National Guard unit on a...

I have a simple formula--which sums the numbers in a list. However, when I change a number in the list, the total number is NOT changing. The formula is...

I downloaded a mailing list and it is all in CAPS (i.e. PHILIP SMITH). I need to do a mail merge & need to change the Syntax to upper & lower case (i.e. Philip...

does microsoft xp have excel word as i can not find it please help thank you

I am trying to do a search on a list of names (around 1000) the columns listed are first name, surname and employee number. I want to be able to search on...

I need to compare and calculate a range from two separate worksheets

I have the following table (simplified) that indicates what shipping zone will be assigned to a shipment based upon the first three digits of the package...

It appears Excel doesn't recognize years prior to 1900 for sorting. Has anyone ever found a format fix for this? or have a suggestion to get around it...

We just received new computers and the highlight option is not showing on the main screen, but items do show as highlighted when I click on PRINT PREVIEW. How...

I have a column with a list of names with commas, example: Smith, John. I want to either make the first and last names in seperate columns or make the comlun...

One way. Enter your 1 to 10 in column A. In column B enter and pull down =RAND(). Now sort the two column by the rand column and pick the top two in column...

Can someone tell me how to format a date cell so the user does not have to enter the "/" marks when entering a date? I would like the user to be able to use...

Hi I am working on over-time claims. On A1 is start time, B1 is end time and C1 is sub-total time. All cells format are :mm Example: A1 B1 C1 18:00 ...

It should be so simple.... I am trying to get excel to count the number of values for 2 conditions in a worksheet. i.e. I want a count of the number of times...

Quick question, I have several cells clculation an equation. A1+B1=C1 A2/B2=C2 Answers C1&C2 will always be the same, as (for example) A1=1, B1=2, A2=6,...