Not sure what type of formula to use I'm trying to find in one of my rows of my excel spreadsheet specific countries like Germany, Italy, France, etc. I need a formula that will display IF one of those names occurs in that row, it will display a Y for Yes. If it is not one of those names, I want it to display a N for No. ... 17 Feb 2010 00:34 Find and Replace wildcards Hi All I need a little help. What would be the codes to enter in the Find and Replace boxes so that the second decimal place in any number would be replaced with a given number? For example 5.97 16.23 22.64 9.66 105.26 Would become 5.95 16.25 22.65 9.65 105.55 if I wanted to search an... 16 Feb 2010 18:23 addendum 2 I've now tried vlookup and it too isn't giving me what I'm looking for. My eq arrangement is: =VLOOKUP(SUBTOTAL(109,range),range,1,FALSE) ... 16 Feb 2010 18:23 Whats wrong with this array formula Try it this way: =AVERAGE(IF(A2:A9176="philadelphia",I2:I9176)) Still array-entered using Ctrl-Shift-Enter. Hope this helps. Pete On Feb 16, 6:55 pm, Carl_B wrote: I have a worksheet with 5 city names in column A and dollar amounts in column I. I need to calcula... 16 Feb 2010 18:23 freeze column and row on same spread sheet freeze column and row on same spread sheet - will only freeze one or the other ... 16 Feb 2010 18:23 subtotal, match? Morning all. I need to do a name check to match with a subtotal function. Is that possible? I was thinking that subtotal(Func_Num,match(....)) might handle it, but I don't see anything that'd allow for that in the list of function numbers for subtotal. My goal is to perform a subtotal type operation, to ... 16 Feb 2010 12:57 iserror, index & if I'm trying to design a workbook that has a front sheet where you input all the information, then a function that will copy it to relevant worksheet within the workbook ie 4,7, etc etc, but there will be multiple information on the front sheet to copy to the relevant sheet. Sheet 1 INput Sheet 2 4 Sheet 3 7 sh... 16 Feb 2010 12:57 emailing from excel 2003 thru outlook 2007 is not being recieved I currently have outlook 2007 and excel 2003 when I send a workbook as attachment it is never recieved. what is causing this issue? ... 16 Feb 2010 12:57 Find a single value from tables by selecting two variable inputs? I am trying to have a worksheet locate a single data value based on two, variable input values. The single data value is located at the intersection of two variables in tables within the workbook. LOOKUP functions are only good for one variable and column/row identifier. Since I have two variable inputs, thi... 16 Feb 2010 12:57 Counting Number of Discrepancies between 2 rows I've got integer values in Rows B and C, columns 1 to 20 I'd like to be able to count the number of times where the column values in rows B and C don't match. Can someone point me in the right direction. TIA Rob ... 16 Feb 2010 12:57