Search results for query: *

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

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

Thank you Anotherhiggens, this worked fine for me!

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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