Search results for query: *

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

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

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