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!

  • 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!

Recent content by camster39

  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...

Part and Inventory Search

Back
Top