I have a spreadsheet with a single column of numbers. There are 1000
numbers. I need to perform a count if formula on these numbers if they
are above .5. Now sometimes I need to group these numbers in groups of
10 or 20, or 50.

I am having tough time converting CSV files into Excel, Could anyone
help me   in  converting  CSV files into Excel files .
Thanks in advance.
baski

I am trying to convert a list of payments in this format:
Date | Account Code | Amount
into a quarterly cash flow categorised by Account Code type. I’m trying to
use VLOOKUP to convert the Account code into a category so that I can split

Column "A" Is My Date column Which Starts with Jan 1, 2000
Column "B" Has Generic Data
Now In column "C" row number corisponding to Jan 1, 2001 (Cell "C55")
I have this formula , =IF(ISNUMBER(B55),B55-B54,"")

I'm working on a work schedule. I would like to put two numbers that
represent time  in a single cell and have them caculated to total the
amount of hours worked.
example:

or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?

or maybe with sort I don't know. All data in Column A several rows between
data. When I sort, all numbers go to top and names and ids drop to bottom.
How to maintain data integrity in the group and still delete the rows?

I'm trying to figure out how to have a formula return the column number from
a maximum value in a row. I've tried using =column(max(a1:c1)) to return the
column number but it errors out. Can anyone offer a suggestion?
Thanks

I have built a worksheet with multiple tabs.  Something has happened to the
workbook that is not allowing me to build formulas by pointing to a cell on
another tab.  How do I correct this?

I have some data that was sent to me that needs to be manipulated.
The data includes date/times  in a column that I want to reformat into the
date/military time format.
The original spreadsheet had the date time format as custom.  When I try to

I have a report that I download off our National System that is converted to
an Excel worksheet.  After the conversion, I have to format the cells with a
smaller font, change two columns to a different format and sort by a separate
column.  

need to delete blank rows without using sort or maybe with sort I don't know.
All data in Column A several rows between data. When I sort, all numbers go
to top and names and ids drop to bottom. How to maintain data integrity in
the group and still delete the blank rows?

Hello from Steved
If typed 12805 in cell A1 then the value in the cell  A1 will be 12/8/05
in Numbers , Custom can I put something like d/m/yy to do above please.
Thankyou.

... I have a particular Excel sheet. Any date I enter shows up as an
ordinal number (in the cell and printing; in the formula bar it
displays correctly), notwithstanding that I format it as a date.
Anywhere on this sheet. A new sheet added to the workbook behaves as

I am trying to find out if it is possible to take an excel spreadshee
and shade or color a certain box based on the text that I have in tha
box.
For instance, if I have the word CREATE in 75 different places on