| Thread | Last Post | Replies |
|
| Removing A Vertical Page Break That Won't Go! | 07 Aug 2006 07:33 GMT | 5 |
Hi. If anyone at all can help me out, that would be great. I a trying to print something that can fit onto one page vertically, bu there is a vertical page break which will not remove itself no matte how I try to do it. I've already done the obvious by using the Offic
|
| Help Creating A Formula To Copy and Paste Text | 07 Aug 2006 02:33 GMT | 1 |
Hi everyone. Thanks in advance for any help you may have. I need to create a formula that searches for a specific word in a column then cut the word and paste it to another column. Of course this would be simple if it was the only word in the column, but there
|
| Displaying a number from another column | 07 Aug 2006 02:11 GMT | 7 |
Need some help: Let's say I have a list of numbers in column A: A1:1 A2:2
|
| formula. | 07 Aug 2006 02:06 GMT | 6 |
Hello, I'm in need for a formula, if in cell A for example i introduce numbe 2 and in cell B number 3, cell C would give me a total of 5. But if fo example i write '23' in the same cell (a) i want cell b to give me
|
| Formula'd cells charting as zero values | 07 Aug 2006 00:57 GMT | 3 |
I have a very simple series, on which a line chart is based. The series contains the following formula: =IF(I6<>"",H26+I6,"") Therefore the cells in the range are blank if the source cell (row I) is
|
| How do I correct a range 'reference'? | 07 Aug 2006 00:53 GMT | 3 |
Using Excel XP. ===================== I've had a frustrating time with DSUM on a workbook I'm building from someone else's model - I keep getting #VALUE! errors. After lots of looking
|
| Autofilter or Advanced filter not working as I want to! | 07 Aug 2006 00:43 GMT | 4 |
Hi... I have this list of products from A2:A250 , companys orders B2:B250 & C3:C250 and so on... what i would like to do is to be able to wiew only the filled cells all
|
| Checking for ALL Upper case? | 06 Aug 2006 23:32 GMT | 3 |
Can anyone let me know how to check a cell for text in all upper case? I have a column containing only text, some cells contain the manufacturer & some the model. However the Manufacturer is in all upper case. And the cells below that particular Manufacturer are the models of
|
| Adding times | 06 Aug 2006 23:09 GMT | 3 |
Anyone able to tell me how to add times minutes and seconds so that the answer will show hours minutes and seconds. Any hints on the best way to format the cells to show times would be great. Thank you!
|
| Moving around in spreadsheet | 06 Aug 2006 23:06 GMT | 1 |
OK this should be an easy one. For some reason I cant arrow right an move to the next column anymore. I can enter and move down but th arrows arent moving me to the next or previous columns. Did I mess u my settings somehow?
|
| merging sheets | 06 Aug 2006 22:55 GMT | 1 |
hi membes how can i merge the data of 15 different worksheets into single sheet in the same workbook data is almost of 5000 rows in each workbook
|
| Problem saving excel file | 06 Aug 2006 22:50 GMT | 4 |
I have an Excel file which I can't save to the server nor local har drive. When I open it and make a change and click on *-save as or sav -*a dialog box appears and says*- file not saved-*. Even if I don' make a change and just click on save it says the same thing. No specia
|
| Filter columns by fill colour | 06 Aug 2006 22:45 GMT | 3 |
How do I filter columns by the colour the cells have been filled with? I've tried all kinds of hexadecimal junk with the advanced filter, with no luck. Your help will be appreciated.
|
| Comparing Record In Two Recordset | 06 Aug 2006 22:30 GMT | 1 |
I am writing macro who will extract table name from ORACLE and chek is this in DB2 or not. I am using windows2003 server and ORACLE 8.2.1 and DB2 8.2. and office 2000
|
| Categories in Databases | 06 Aug 2006 22:25 GMT | 3 |
I have a database of things in Sheet1 and one of the columns is labeled "country". Let's call this the master list, with about 150 rows. I want to make a list in Sheet2 with just things in "China". The way I've been doing it is by scouring through the master list, seeing which
|