| Thread | Last Post | Replies |
|
| Row Sequencing | 18 Aug 2005 18:33 GMT | 8 |
I have done a number of sorts and filters and rows now skip the numbers that are hidden. Now I am satisfied with the rows showing and I want a straight numerical sequence of the rows shown, without any numbers skipped. Can I get this?
|
| Selecting Random Data | 18 Aug 2005 18:26 GMT | 2 |
I have a spreadsheet that has data in A1:J4163 but the size is not always the same. My question: Is there a way that I can make a formula, VBA or Contitional formating to select rows randomly and color fill the rows
|
| How do I print two sheets in same workbook duplex? | 18 Aug 2005 18:24 GMT | 1 |
I am trying to print two sheets in a workbook duplex. It worked yesterday but today for some reason it has stopped working.
|
| Can the =CELL formula be used to determine the worksheet tab name. | 18 Aug 2005 17:41 GMT | 4 |
The tab is named '522' and I want '522' to show up in a cell in the worksheet such as A1. I know that =CELL can be used to get the filenam, but can it be used to get the tab name? If not, is there another function that will?
|
| Linking spreadsheets | 18 Aug 2005 17:30 GMT | 2 |
Not sure if this can be done but this is what my boss is trying to do: Have two worksheets. Worksheet A is a shared worksheet. Workshop B has cells linked to figures in worksheet A.
|
| subtotal - multiple criteria | 18 Aug 2005 17:20 GMT | 7 |
i have a sheet, which i want to sub total on two levels.. for example, i have a product number, country code, and value. Th sheet is sorted by product number then country code. i require totals for the value of the product (which i can acheive b
|
| Linking arrays and Worksheet names | 18 Aug 2005 16:55 GMT | 2 |
Doozie of a question - workbook, formula linking Hey guys, So I have this workbook with tons of different worksheets, with different names. I also have a summary page with summaries of the
|
| Setting Purely BLANK Cell | 18 Aug 2005 16:43 GMT | 4 |
I am using an IF function that states as the following [in Cell B1] =IF (A1="ABC","","ELSE") When this IF statement is TRUE, I want B1 to be a blank cell, hence the
|
| Formula to combine text? | 18 Aug 2005 16:29 GMT | 5 |
Greetings. I need a little help. Is it possible to combine text from to different cells together with a formula? Example: A1 = My name B1 = is Will, and I want C1 to say My name is Will. Is this possible? Thanks in advance for any help.
|
| Need help adding : | 18 Aug 2005 15:59 GMT | 2 |
I need some help, desperately. I was sent a spreadsheet with several thousand entries, and all of the dates reported as (example) 1015. Is there a function that I can go into the next column and say " take value in A1 and move over two places, add a ":", in theory converting ...
|
| Simple selection, but hey, I'm no guru!! | 18 Aug 2005 13:56 GMT | 1 |
I have a small table of data ranging from column A to column D runnin from cells 5 to 11. Lower down the sheet I need to select from th items in column A and I am currently using a "Validation" drop down bo to do this. I would like to populate another cell with the data on th
|
| Performing a convolution in a worksheet | 18 Aug 2005 13:28 GMT | 2 |
I have data in the first two rows of my spreadsheet. In the third row, I would like to compute a convolution: X(3,j) = sum for i = 1 to j of X(2,i)*X(1,j+1-i) where X(i,j) is the data in the ith row and jth column of the spreadsheet.
|
| How to make the cell or font color red if the number is negative? | 18 Aug 2005 13:28 GMT | 6 |
I'd like to make a cell change color or the cell's font change color as the number in the cell changes from negative to positive or vice versa?
|
| WHAT'S THE FORMULA FOR CALCULATING OVERTIME IN 1 CELL? EXAMPLE: 8. | 18 Aug 2005 13:22 GMT | 3 |
TRYING TO CALCULATE 8 HRS STRAIGHT TIME, IN ADDITION TO ANY HOURS OVER 8 MULTIPLY BY 1 1/2 IN THE SAME CELL
|
| Can I Somehow load a Spread Sheet thru a Scanner | 18 Aug 2005 13:11 GMT | 1 |
I am wondering if you guys may be aware of a hardware or a software product that can provide me the capability to put scanned table data in a spread sheet format. For example, I make a Xerox copy of a data table
|