Functions

Max Function
Is there any function available that works similar to the MAX function for alpha characters? Thanks Irie ... 18 May 2010 17:02

Questions
hi, can someone helps me to solve this problem? name no books read month nasir 1 12-jan-2010 adam 2 12-jan-2010 fatima 3 14-jan-2010 nasir ... 18 May 2010 13:41

Creating backgroound for an Invoice
I am creating an invoice using Excel. The invoice has already been created and is fine. I am now just trying to input a header and footer with a middle. I have them as seperate PDF files. I can add them as header and footer but when I "print preview" both ends (left & right) of both head and foot are cut. Thi... 18 May 2010 15:55

Combine data into central worksheet
I have a main costing work sheet that needs to be populated by individual costing sheets that went out to all of the buyers to populate. Main Costing Sheet A. Item # B.Desc C. QTY D. Cost E.....F.........G......H (all contain irrelevant information to costing activity. There are 5 buyers (Ni... 18 May 2010 12:35

Ability to sort data in Excel by fill color
We often use fill colors to designate different values. It would be helpful to be able to sort using these colors, to obtain value groups. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" ... 18 May 2010 15:55

Time formula
Working with a spreadsheet (Excel 2007) that has a start time, end time and time Start Stop time 14:00 15:18 1:18 Would like to convert time to minutes and add 15 minutes to the answer. I have set up a custom format for minutes [m] but can't get the +15. Any help you can give me will be appreaciated. ... 18 May 2010 14:48

Find the last number in a row
Hi, I have lots of rows of data which are either a value between 50 and 200 (e.g 115) or "0". Each column is a specific week of the year, ie from 1/1998 to 52/2009, so the values run from left to right giving a number for each week, and when there is not an entry for that week, there is a "0". I need a f... 18 May 2010 12:35

Separate Date from a Text String
The data that I have looks like this: [10/24/10 11:45PM] And I would like to just get the date like this: 10/24/10 Is there any way to do this in Excel with a formula? Thanks!! Sara ... 18 May 2010 11:28

Formulas
I wanted to enter a number in a cell for example 10 in A2 and this number should be converted into a letter say "A"in A2 cell. How could it be done? ... 18 May 2010 10:22

Define a Value
Thank you to those who posted to my question earlier, but just to give a little more insight on what I am trying to do: I have a scroll list in one cell and I am trying to make it where if I select one thing from that scroll list the cell next to it will auto populate with a number I define. However different t... 18 May 2010 10:22