I have populated many cells in column A with the numbers 1 through 12. The numbers are synonymous with the months of the year. However, I would like to enter...

I have an worksheet that has data that is sorted like the following Bar NumberProperty Node...

Hi! I use Microsoft Office 2003. A part of my job is to maintain a spreadsheet containing data on vehicles my company owns & rents. It looks a little...

I have the following problem trying to set cell color based on conditional parameters. I have a large spreadsheet where I do a log transform to get a result....

Hi guys, I posted a question a few weeks ago about a spreadsheet I have been working on for my boss. Just when I thought I was home and dry, he has asked me...

How do I sort the following text; EP2323A-01, EP2323A-02, EP2323A-03, EP2323A-04, EP2323A-05, EP2323B-01, EP2323B-02, EP2323B-03, EP2323B-04,...

The web table that I want to import is divided into a number of pages (1-12) but only the first page is selectable (yellow arrow) in the 'New Web Query'...

I would like to sum up only the £ values in a row containing £ and units. Ideally I would also sum £ values only within a specified date range ( I...

Hi, I have two columns of data that I would like to analyse. Column A holds a reference number and column B holds the “class� for each of these reference...

I have excel 2003 and XP. I have a worksheet with some 50,000 entries. Column E is an address field. Some 7,000 of the addresses have a suite number in...

I have a formula that figures out the hundred weight of a warehosue. Throughput / Hours / 100 = CWT When I use the numbers it comes out to this: 5544654 /...

Hi, I have a workbook that has a worksheet for each month of the year. Each month has over a dozen columns with figures that are totalled. Then I have a...

Good afternoon, I have a list of collaborators with one score associated to each one. I intend to distribute the collaborators in 3 groups: the good one, the...

How to create a Gauss chart? Any suggestions? Thanks in advance, Alexandra

I have some output from a database listing chargeout rates for various contractors. As these are updated yearly, there are various values for each...

I hv a list of records in Column A which may be duplicated more than once. What I'd like to do is count the number of record in the list which start the...

I have a rather large personnel spreadsheet which I am collating every employee's details into, a similar but less extensive and recent spreadsheet had a...

I have an employee's name in cell A5 on a SS called Repair rotas.xls on the Plymouth Staff tab. The Saturday rota for this employee, called 'Saturday C', is...

I have been given a csv file - on opening in excel the dates are in the format 25051917, 5051949, 23121979 etc. I have been struggling to get them into the...

The following formula works on a column range (A1:A40), but not on a row range (A10:U10). What have I missd? ...