| Thread | Last Post | Replies |
|
| Cardiology | 30 Jan 2004 22:49 GMT | 3 |
Please, could anybody assist me? I'm about to enter the university to study medicine. I plant to later specialize in Cardiology. Please kindly explain all it requires and give me all relevant information.
|
| changing the background color on a single column | 30 Jan 2004 22:32 GMT | 2 |
I am trying to change the background color on one column. The only thing it will let me do is change the background on the whole table. Can someone please tell me how to do this?
|
| find on multiple worksheets | 30 Jan 2004 22:27 GMT | 2 |
Is there a way to find data on multiple worksheets instead of searching individual worksheets?
|
| 100% eliminate the "Save before quitting?" message | 30 Jan 2004 22:21 GMT | 6 |
In my workbook I have: ActiveWorkbook.Saved = True and it works. However, there are two instances when it does not work and I still get the "Save before quitting?".
|
| weekly top 50 titles _newbie,please help!!! | 30 Jan 2004 21:01 GMT | 5 |
Hi. I am tracking the usage rankings of a number of links for a web page over the course of a week. Each day has it's on sheet.
|
| Looking for "StDEVIF", if it exists | 30 Jan 2004 20:32 GMT | 2 |
Does excel contain a formula operator similar to SUMIF but would utilize StDEV in place of SUM. I need StDEV to ignore 'empty' formulas in my sheet which return #DIV/0!
|
| Detecting invalid links | 30 Jan 2004 20:18 GMT | 6 |
A quick question about links, probably with an obvious answer for thos in the know. I want to avoid a value being displayed if a link is not valid becaus the file does not exist. Is there an 'If Exists' command or similar?
|
| more help - Formula to check values | 30 Jan 2004 20:03 GMT | 1 |
maybe someone can help - I am dealing with a negative numbers: if the value in cell 1 = -1.0 and lower (i.e. -2.0) then "CR" should display in cell 3
|
| how to change extension of unopened file | 30 Jan 2004 19:27 GMT | 2 |
I copied an excel file to a CD and it copied it with an ink extension instead of xls. How do I change it? I cannot open the file to save it as anything else. Rita
|
| vba - need to find the type mismatch in this line of code | 30 Jan 2004 19:22 GMT | 2 |
While Worksheets("Log-Import").Cells(counter, LogCol).Value And Worksheets("Log-Import").Cells(counter, UsernameCol).Value And Worksheets("Log-Imports").Cells(counter, DayCol).Value <> "Logoff" And username And Cells(counter, DayCol).Value
|
| footers | 30 Jan 2004 18:48 GMT | 1 |
does anybody know a way to insert a graphic file into the footer of an excel sheet so it appears at the bottom of every page? this might be a little basic, but i can't seem to figure
|
| Duplicate searching through multiple columns, rows | 30 Jan 2004 18:28 GMT | 1 |
I just did a search through the newsgroup but didn't find anything specific to this. I'm trying to look for duplicates so that it would recognize ROWS A and C as being duplicate (see below). Is there any way to do that?
|
| IF Formulas to Find Text String in Specified Range | 30 Jan 2004 18:28 GMT | 4 |
I am hoping that someone can help me out here. I am looking for an IF formula that will allow me to search a specified range for data that does not = "--" and then return that value in a specified cell. Does anyone know
|
| converting imported numbers | 30 Jan 2004 17:51 GMT | 4 |
I have imported a text file containing numbers that I need to change/move the decimal left 2 places i.e I need convert/change 123 to 1.23, 123456 to 1234.56 etc. for the entire sheet. Any suggestions?
|
| Include error checking | 30 Jan 2004 17:47 GMT | 2 |
=IF(BL484="saleable",(SUBSTITUTE(TRIM(BS484&" "&BT484)," ",","))) I want to include error checking so that if BL484 does not contain a value it will not return FALSE Thanks in advance!
|