How do I combine and sort a column of zip codes that has data in both 5-digit and 9-digit formats?

HI.. Is there any way to convert multiple rows data into 1 single column? Like this 1 2 3 4 5 6 7 8 Into 1 2

Is there a formula for calculating ROI (Return on Investment) for Excel?

Can I do a countif using only specific cells. for example, a3,a15,a27? Thanks for any help you can offer, Steve

Hi, I'm have the following sample of data from a worksheet in columns "A" through "D". In column E I've managed to find a "COUNTIF" formula that would...

I need a formula that will display a date as the day of the week, the month and the date (example: Wednesday, January 26). I've researched all the...

Hi ... and thanks for being there! For some reason (and suddenly), when I type a formula into the bar it appears on the worksheet ... and will not go away;...

Hello, I would like to add a column to a pivot table that would show the difference between the two other columns. Below is a sample of data and the pivot...

Hi All, I have two columns in a spreadsheet, column A - a list of dates on which transactions took place. Column B the value of the transaction. More than one...

I'm trying to calculate window and door measurements into square feet. Any suggestions? Peggy "GerryK" wrote: Not without VBA Try this: ...

Hi I am trying to create a worksheet whereby when i enter certain data, e.g. the letter 'D', it returns a pre set value etc and the same for the rest of the...

If I have a 'legend' of answers and I want the input cells to reference this legend and put one of the possible answers into the input cell, how do...

How do I get sum of all odd or even numbers from the series (1, 2, 3, ....., n) by using SUMIF function and MOD function or any other function?

How can I link and label worksheet tabs to relative dates contained in each worksheet?

when i clear all the cells in the formula below I get #VALUE! showing in the cell (M15) Is there a way to just show a blank cell? and not have this...

Can I use conditional formatting so as to look at Column A A1 a2 A2 Turns EA 1.00 red CS 100 Blue BX 50 ...

What I need are start and end times. I have a start time cell that shows 12:00pm I have a project that will take 2 hours and 30 Minutes in another cell Then...

I am trying to create a formula to do the following: A1 contains a zip code. Column B is a listing of zip codes with neach code in it's own cell from B1 to...

I have a list in a column, including various comments and dates in 31/01/05 format. How can I apply a filter so I see everything EXCEPT the dates? i.e. if i...

If I am adding records in to a spreadsheet, I want it to count the number of days that record has been on the spreadsheet for. For example I am currently...