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 Chriss Miller 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. camster39

    GoDaddy email Spam

    On my GoDaddy email account, I have automatic forwarding to my icloud email address. Over the past 3 weeks, I have been inundated with Spam. I do notice; however, that 95% of all my Spam does NOT get forwarded to my icloud email address which is good. All other, non-spam, email is successfully...
  2. camster39

    USB Splitter / HUB?

    From my MFC-Brother printer I have a single USB cable that is running directly from the printer to my PC. It works fine. I want to keep this existing line running to my PC but I also want to split this and also run another line to a USB port on my Netgear Wireless Router. This way I will have...
  3. camster39

    Burn DVD from various file formats

    I am using OJOsoft to create any of the following video files: MP4 AVI MPEG MOV VOB etc..... Once I have the actual file created, do I need DVD burning software to create an actual DVD? I was under the impression that a VOB file can be read by any DVD player, therefore, I just copied my VOB...
  4. camster39

    Excel formula needed - cell reference

    PERFECT!!! Thank you very much for sticking with me on this and getting it working. Here is the final formula and it's working just as it should. =IF(ISERROR(OFFSET(J19,-$P$3+3*ROUND((B19-$P$3)/12-0.5,0),-1)),0,OFFSET(J19,-$P$3+3*ROUND((B19-$P$3)/12-0.5,0),-1)) Thanks again.
  5. camster39

    Excel formula needed - cell reference

    I tried something like this.. =IF(OFFSET(J20,-$P$3+3*ROUND((B20-$P$3)/12-0.5,0),-1)<0,OFFSET(J20,-$P$3+3*ROUND((B20-$P$3)/12-0.5,0),-1),0) I didn't know what to put as my condition true so I just chose < 0. In reality if my offset value is #Name? then I want a zero otherwise I want the actual...
  6. camster39

    Excel formula needed - cell reference

    I tried several versions on IF, ISREF, ISERROR and I'm either getting #Name? or just null values across the board. =OFFSET(J19,-$P$3+3*ROUND((B19-$P$3)/12-0.5,0),-1) I can find a workaround (e.g. not applying the formula to certain cells when P3 changes) if I can't get this working.
  7. camster39

    Excel formula needed - cell reference

    In the event that the data is not present in the table can we return either a zero or a null? Row #1 would always have a zero and if $P$3 had a value of 2 or greater that would always have a zero etc... I think that would do the trick as I have a ton of other cells that reference column J...
  8. camster39

    Excel formula needed - cell reference

    Excellent - thank you very much. I've got it working 'almost' perfectly and I neglected to tell you that my first row is January 2009. Here is my formula based on some slight movements of my rows. =OFFSET(J19,-$P$3+3*ROUND((B19-$P$3)/12-0.5,0),-1) The only problem I'm having is if my value...
  9. camster39

    Excel formula needed - cell reference

    I think I'm doing something wrong: Formatted columns A&B as Category Date with type 03/14/01. I entered 01/01/2009 in A4. In A5 I entered formula =EOMONTH(A4,1) and I'm getting #Name? as a result. And then the same type of error for column B since I messed up column A.
  10. camster39

    Excel formula needed - cell reference

    I have a spreadsheet where each row corresponds to a specific month, by year, and there are 3 rows separating each year. The first month starts in Row 4. Example: Row 4 = January 2008 Row 5 = February 2008 Row 6 = March 2008 Row 7 = April 2008 Row 8 = May 2008 Row 9 = June 2008 Row 10 = July...
  11. camster39

    Cell Reference in Excel

    Thank you - that worked perfectly.
  12. camster39

    Cell Reference in Excel

    In Worksheet A I have a monetary value in Cell A13 - I am trying to derive a value in Cell A40 that references Worksheet B for the resulting value based on Cell A13: ________________________________________________________ Worksheet B looks like this. Column A Column B $1,300 $400 $1,310 $410...
  13. camster39

    Excel - reference 1 worksheet &amp; populate another worksheet

    I have 2 worksheets, 'Final list' and 'NJ List'. There are 3 columns in 'Final List' that are not yet populated with data. They are 'email', 'phone' and 'title'. I want to reference NJ List and if there is a match for first and last name (which are contained in both lists in columns A & B...
  14. camster39

    Word Merge - Formatting Fields

    I have a simple excel data source that contains currency amounts: 1 - Renewal Amount 2007 (example $25,000) 2 - Renewal Amount 2008 (example $32,000) When I merge into MSword it appears as 25000 & 32000 respectively. How can I format in Word so that it appears as currency? I seem to remember...
  15. camster39

    MS Word mail merge .....

    My word template has the following fields: Company Name Activity 1 Activity 1 Date Activity 2 Activity 2 Date Activity 3 Activity 3 Date My data source (a CSV file), however contains multiple records for each activity for example...... ABCM Corp, Call Client, 1-12-08 ABCM Corp, Set...
  16. camster39

    Seperate Rows

    Column A - Employee SSN Column B - Employee First Name Column C - Employee Last Name Column D - Benefit Plan Type If the value in Column D is anything other than "Employee" then there will be a value in columns E,F & G, otherwise there will be no values in E,F & G. Column E - Dependent First...
  17. camster39

    Outlook 2003 - opening MSG files

    My old PC was running Outlook 2000 --- I have a bunch of emails that I've saved to my hard drive on the old PC. To save I would just open up the email in OL and choose File - Save As - Message Format(*.msg). I copied over all of the .msg files from my old machine to the new PC which is running...
  18. camster39

    New XP Install - missing drivers??

    I just did a fresh install of Win XP on my Dell Dimension 8300 after a defective hard drive was discovered. I removed the defective drive and kept the good one (it was a Raid 0 setup with 2 drives). I ran through the XP setup without a problem --- after the install however, I am not able to...
  19. camster39

    Excel Formula

    Column A contains Soc Sec No Column B is Employee Last Name Column C is Employee Middle Name Column D is Employee First Name Column E is dependent Last Name Column F is dependent First Name Sorted the spreadsheet by column A – if an employee has more than 1 dependent there is a repeat of the...
  20. camster39

    Matching Cell Values?

    In Column A I have a master list of all Social Security Numbers. In column B I have a partial list of Social Security Numbers. I would like to create a formula in Column C that will return a SSN if it exists in Column A and NOT Column B. If I can't return the actual SSN then just something...

Part and Inventory Search

Back
Top