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

    Excel IF formula returning #VALUE!

    Perfect, Thanks Xlhelp, I sent you the official thank you as well
  2. dhamDIT

    Excel IF formula returning #VALUE!

    Now am I trying to nest more than one Countif, but I think I am getting messed up with the brackets. If the N3 if is found in J3 to J13 I want it to deliver 8 as a value, if the N3 is found in J14:J20 I want it to deliver 6 else I would like it to say "open"...
  3. dhamDIT

    Excel IF formula returning #VALUE!

    Thank you Anotherhiggens, this worked fine for me!
  4. dhamDIT

    Excel IF formula returning #VALUE!

    Hi, what I am trying to do is this, If the value of N3 is found in the range of K83 to K90, I want to return a value of 8. The data is K83 to K90 is not in alphanumeric order and cannot be put in alphanumberic order. Thanks
  5. dhamDIT

    Excel IF formula returning #VALUE!

    Hi I did look at this however my Transistion Formula Evaluation box is not checked Thanks
  6. dhamDIT

    Excel IF formula returning #VALUE!

    I am using the following If formula to search a list and return a specified number based on finding a match. In the formula window it seems to work, it shows me the returned value as 8 which it should be however in the actual cell I get a #VALUE! =IF(N3=K83:K90,8) Any help is apprciated
  7. dhamDIT

    Excel - IF(ISNA

    Hi, I have tried several different options of trying to fit the IF(ISNA into my formula without success. I think I am getting the brackets wrong. Here is my formula. Any help is appreciated. Thanks D =INDEX(Sheet1!$AE$1:$AE$31,MATCH($B3,Sheet1!AF$1:AF$32))
  8. dhamDIT

    Excel Formula or Array? Transfer info between spreadsheets

    Thank you KenWright, your solution worked perfectly for me. This is the first time I have used Index. Thanks, Denise
  9. dhamDIT

    Excel Formula or Array? Transfer info between spreadsheets

    Hi, I have one worksheet with info in this format F S S M T W TH Rep 1 AB AB AB AB AB AB AB Rep 2 CD CD CD CD CD CD CD And another worksheet with info in this format Fri Sat Sun Mon Tues Wed Thur AB CD What I would like is for the active cell to check the matching cell and...
  10. dhamDIT

    Missing vbaproject.otm and this outlook session

    Hi, through trial and error, I came up with a solution and thought I would post it in case anyone else comes across this situation. The vbaproject.otm file was still in the correct directory but it must have been corrupted as Outlook vba was not recognizing it. I renamed the file and them when I...
  11. dhamDIT

    Missing vbaproject.otm and this outlook session

    I seem to be missing my vbaproject.otm file. When I go to Macros/Visual Basic Editor and it opens up the VBA, instead of This Outlook Session and the vbaproject.otm that I am used to seeing (and have written code in), instead it says no open projects. Almost all otions in menus are grayed out...
  12. dhamDIT

    Outlook - save attachment based on sent time

    Hi, I have some code which is successfully used as a script, run by a rule. It automatically saves certain attachments to my hard-drive. I would like to further refine this by limiting the attachments saved to only those which are sent in emails during a specific time period. ie 6:00pm-6:30pm...
  13. dhamDIT

    Copy column & "paste special as values" into first blank cell in r

    Hi, Thanks Bob and Loomah, combining your suggestions gave me exactly what I needed!! Here is the code I ended up with Sub Copy_lookup() Range("B3:B35").Select Selection.Copy Range("ap3").End(xlToLeft).Offset(0, 1).Select Selection.PasteSpecial Paste:=xlPasteValues...
  14. dhamDIT

    Copy column & "paste special as values" into first blank cell in r

    Hi Bob, thanks! this certainly solves one of the issues, (the first option is what worked for me BTW, I was not trying to transpose), My other issue is how to get it to paste to the first column between c and ap where row 3 is blank. Thanks D
  15. dhamDIT

    Copy column & "paste special as values" into first blank cell in r

    Hi I want to copy cells A3:A35 then and then "paste special as value" into the first column in the range of C:AP (beginning in row 3) where C3:AP is blank. Any help would be appreciated. I have tried a few things and have just not gotten it right yet Thanks in advance D
  16. dhamDIT

    auto calculate due date in excel based on starting date

    Hi, If A1 is your start date =A1+14 will give you a date 2 weeks later Is this what you are looking for? D
  17. dhamDIT

    Excel - Array or formula for min w/ multiple criteria

    Thanks Zach, you pointed me in the right direction and I was ultimately able to get what I needed. Array I ended up with is =MIN(IF($C$1:$AF$1="Mon",IF($C3:$AF3>0,$C3:$AF3))) Gives me the minimum, greater than zero in Mon columns.
  18. dhamDIT

    Excel - Array or formula for min w/ multiple criteria

    Sorry just notice I did not actually post the correct starting formula for min - it sb =IF(MIN(C23:AF23)=0,SMALL(C3:AF3,COUNTIF(C3:AF3,"=0")+1),MIN(C3:AF3))
  19. dhamDIT

    Excel - Array or formula for min w/ multiple criteria

    Thanks Lillabeth! that does solve the error issue but I still have the additional criteria of the $C$1:$AF$1="Mon" to add as well Thanks D
  20. dhamDIT

    Excel - Array or formula for min w/ multiple criteria

    Hi, I am having problems getting a minimum based on multiple criteria. I was successful getting a maximum using the following array, (I wanted the max based on day of week = Mon.) {=MAX(IF($C$1:$AF$1="Mon",$C15:$AF15))} My problem with the Min, using the same approach is that is does not...

Part and Inventory Search

Back
Top