I have two columns containing data. The first column has all cells populated, whereas some cells in the second column are empty. I am trying to count the...

I'm just wondering how can I make text to be sorted from the right to left... Instead of having: Hello Example One Have:

I need to highlite various rows on my Excel spreadsheet of addresses. How is this accomplished? Thanks, jerry

We would like to have vlookup extend its search (looking for cost) to include a value indicating a cost/price-break for any particular part. If the item is not...

I wander if anybody could help me with this one... ....I am wanting to create a data sheet with a whole lot of different formulas on it. When using these...

I need to use 10 IF functions but if I try more than 7 functions, I get the error message below "Up to seven IF functions can be nested as value_if_true and...

Is this the correct newsgroup for help with array formulas? I have a table containing marks (one row per student), a row for the maximum mark for each...

Hello, I have a small problem. When I try and input data from another source I want that exact data in the cell. So, before I input any data into the...

Hi, I have a price list sheet with item descriptions and pricing. The information is all over, not in straight colums or rows. Is there a way to have excel...

Hi there, I've got a little problem... When embedding a Word document in Excel 97, only the first page appears. I want a 3 page W97 doc embedded, how come the...

I have old database software were I am able to convert the database,onto Excel 97. My problem is this, credits are converted with CR identifiers. example, ...

Is there a formula to insert rows at each date change?

In Column A I have every area code in the US. 201, 202, 203....all the way to the last one. In Column B I have the US State that matches that area code. NJ,...

G'day, I am currently pulling my hair out attempting to summarise a set of data which is formatted as rows and columns into a format whereby it is just...

Hello: I would like to group the date into one cell. Would you mind to give me a help? Source Data! only one...

I need to issue forms with sequential and unique numbers. I can I do this? Rather like the invoice.tmp file creates unique invoice numbers.

excel 2000 need a formula to enter a blank row after a number of entries. However, the number of entries varies with a maximum number of 10 employees for each...

I am creating a report that includes a column that is data type varchar2(1000). My goal is to find a workaround to the 255 character limitation to display this...

How do I see the labels assigned to cells in the formula bar rather than the cell designation? i.e. I want to see: =('Number of units' * "cost per unit')...

Your formula should take a form similar to this: =CONCATENATE(A1,"-",B1,"-",C1,"-",D1,"-",E1) As long as you have the dash in quotes, you should be good to...