Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. iGrant

    Can't send mail over 10MB (exch server 2003)

    I get a non-deliverable report (with error codes 5.5.0 and 5.3.4 when I try and send a mail over about 10MB. I've set limits at 100,000KB in each of 'Global settings', 'SMTP Connector settings', 'SMTP virtual server settings', and 'User mailbox settings'. Exchange server message tracking shows...
  2. iGrant

    Office XP Excel Mouse Problem when clicking in a cell.

    Try pressing f8 to turn off 'Extended Selection' mode
  3. iGrant

    Copying Formula's from one Workbook to another

    Try this formula in the Process worksheet: =indirect("'Dept MIS'!G2") When you copy and paste this into another workbook, it will refer to cell G2 of that workbook's sheet 'Dept MIS'
  4. iGrant

    Excel Parsing

    You mention that the city name is a variable length, can we assume that the state and zip are fixed lengths (2 letters for state, not sure how many letters you have in a zip code - being from the UK an' all...)? If there are 2 letters for state, a space, then say 6 digits for zip code, then try...
  5. iGrant

    Excel XP - Print command causes page break problems

    Have you checked if you have rows or columns fixed to repeat on each page? If the fixed rows (or columns) take up more space than a whole page, you can end up with the result that you are experiencing (ie Excel wanting to print on lots of pages).
  6. iGrant

    sum question in excel

    You could also use SUMIF. At the end of your table of data, use the formula =SUMIF($A$1:$A$20,2001,$C$1:$C$20) Where your 'year' data is in column A, and frequency is in column C. This will then total all the frequency items that appear in a row with 2001. Copy the formula for each other year...
  7. iGrant

    Word Tables Frustration - Please Help me!!

    Do any of the paragraph formats in the cells have 'keep with next' checked? This might force one row onto another page, if the following paragraphs are too big to fit on the current page.
  8. iGrant

    Adjusting Percentages in Excel

    Thanks for the star - appreciated. Just had a thought, though - if you have two percentages in your list that are both the same, and the largest, then each will have 0.1% (or whatever difference) added to them and hence throw out the maths. Is this eventuality likely?
  9. iGrant

    Formula to Compute # of Days Between a Date and Today

    If the entries in your cells, such as 20020911, are just numbers, you'll need to chop them up into a date. Try this formula to convert the number 20020911 in A1 to a date: =DATE(VALUE(LEFT(A1,4)),VALUE(MID(A1,5,2)),VALUE(RIGHT(A1,2))) Then you should be able to do =int(now()-A2) to give...
  10. iGrant

    Adjusting Percentages in Excel

    Keep the formula that you have in column B. Then in column C, against each row, copy the following formula: =IF(B1=MAX($B$1:$B$3),B1+100%-$B$4,B1) It will add the difference between your summed total (of 99.99 or whatever) and 100% to the largest percentage in the list, and thus not throw the...
  11. iGrant

    Date function in Excel

    This is a bit long winded, but =IF(YEAR(C17)>YEAR(B17),SUM((YEAR(C17)-YEAR(B17))*12,MONTH(C17),12-MONTH(B17)),MONTH(C17)-MONTH(B17)) seems to work OK. BUT it won't work if the date in column B is earlier than that in column A - if this is likely to happen then some more work will be required...
  12. iGrant

    Excel error - inserting columns/rows

    You can use Ctrl + End to have Excel go to the cell that it thinks is the bottom right hand corner of the spreadsheet. If you have selected a single row and 'merged' it by mistake, this will prevent the insertion of columns (because it will have affected the cell in column IV, as Geoff suggests...
  13. iGrant

    Changing multiple, linked Excel Workbooks

    To pick a cell from a range, you can use the Index function =INDEX(NamedRange,2,1) will refer to the cell in the 2nd row of the 1st column of the named range. Any use? To address the issue of your linked sheets, I'd be tempted to have the sheets structured with a column of data with the...
  14. iGrant

    Sat/Sun Vie

    In Outlook 2000 this works: Select View menu - Current View - Customise Current View... then click the 'Other Settings...' button Then in the 'month' area of the dialogue box, uncheck 'Compress weekend days'
  15. iGrant

    Excel has lots of pagebreaks with certain printers as default!

    This can also be caused by setting a high number of rows to repeat at the top of every sheet.
  16. iGrant

    Why "Winmail.dat" hides my attachments?

    I'm pretty sure that this is a problem with outlook. There's a note about it somewhere on the Microsoft web site, but I think the only solution (which has worked for me) is to change the format of the mail message to 'Plain Text'. (Select Plain Text from the Format menu when writing the message...
  17. iGrant

    Calendar local and server synch

    Maybe you could set your PC up as if it was a laptop, which will have Outlook create an .ost (offline store). The ost is simply your mail folders stored locally, and then when connected to the network automatically synchronises itself. When I used my iPaq with my laptop like this, it...
  18. iGrant

    Format Cell After Cell Has Contents

    Or as an alternative, put the formula =Value(A1) in B1 (assuming your list starts in A1) and copy down the length of your column of numbers. Then copy the results in B1 to B2000 (or whatever) and Paste Special - Values back onto A1.
  19. iGrant

    How do I take screen shots with a mouse

    Snagit is the right one, definitely. They also do something called Camtasia, which allows you to record a section of the screen (with mouse movements) into a little movie file.
  20. iGrant

    Double nested lookup maybe?

    I would think you could do this with a VLOOKUP, that checks the product code entered in your input sheet and returns the price from your named range. You should be able to fix the last-but-one argument of the function to refer to the quantity, something like: =VLOOKUP(A2,NamedRange,D4+4,false)...

Part and Inventory Search

Back
Top