| Thread | Last Post | Replies |
|
| change array to simple columns | 23 May 2008 13:15 GMT | 6 |
I have a large array that has names as row headings and week dates as column headings with hours as the data. It looks like a crosstab query would in Access. What I want to do is convert it to a list where the names repeat in one column, the week dates for each name repeat in the ...
|
| autoshapes | 23 May 2008 13:06 GMT | 4 |
Does the Flowchart "rectangle" function permit to vertically center align? If yes, how?
|
| database and date | 23 May 2008 12:51 GMT | 7 |
Hi, i want to extract some data from another sheet (or the same sheet), with "if" i think.....and macro maybe. In database example, i have a planning...john's day is monday, and mary's day it's friday. in example 1, i want to write the day when john and mary will arrive and in ...
|
| Add new subtotal lines | 23 May 2008 12:21 GMT | 1 |
Hi, quick question on subtotals. I have a huge list with subtotals and I need to know how I can insert new subtotal lines.
|
| Compare dates and unique identifier | 23 May 2008 09:34 GMT | 1 |
I need to compare two sets of data having dates in coulum A and a numeric unique identifier in colum B. I need to compare the date to the date and in it dosent match then go to the next date, once the dates match i need to compare the unique identifier of those two records and ...
|
| calculate year and month | 23 May 2008 08:54 GMT | 9 |
I have a start date and an end date. I want to show the number of years and months between these two dates. (i.e. from 8/9/05 to 2/1/07 it would show 1 yr 6 mos)
|
| Excel 2003 - copying word to excel | 23 May 2008 08:33 GMT | 1 |
Hi - does anyone know how I can copy data from word that includes paragraphs with line returns etc to an excel spreadsheet so users can copy & paste without getting gridlines etc ? Thanks for your assistance
|
| Formula | 23 May 2008 08:10 GMT | 3 |
If i enter any number "101000" in one cell I want other cell to show in word "One Lakh one thousand only". Is there any formula for this Please help
|
| Decimal Values | 23 May 2008 07:00 GMT | 1 |
For some reason I can not get decimal values to show up on my spread sheet. For instance, if my A1 Value is 2050, I type in Quotient (A1,12), it will read $170.00. I have it set to currency, I've tried checking and unchecking precision as displayed. I've tried making the cell ...
|
| Selectively printing | 23 May 2008 04:29 GMT | 1 |
Is there a trick to print some word and no others ? example NAME : excel 2005 LOCATION : united states
|
| formula | 23 May 2008 03:59 GMT | 5 |
Hi Need help new to all of this' I trying to add color to a formula,if possible. here is my formula
|
| how,, | 23 May 2008 03:56 GMT | 2 |
PLEASE guys i have 2 questions first issue) given :
|
| Search for occurence of any item in table | 23 May 2008 02:53 GMT | 3 |
I have data in cells d2:ac1000. I have another table of items I am looking for in a1:a7. For each row of my data, I'd like to know if there's any matches to items in the table. I know I could sum a bunch of Countifs, as in:
|
| Summing up digits in a cell | 23 May 2008 02:49 GMT | 7 |
i need to add all the digits in a cell. For example, if I have a number 58 in a cell, the adjacent cell should return a value of 13. regards krishna
|
| Search a value basing on another value | 23 May 2008 02:26 GMT | 4 |
Col 'A' = Date Col 'B' = Amount I am looking for a function for: Search if there is current month's date entry in Col'A', if found search for any entry in Col'B' of same row.If both
|