Is it possible to create a lookup that will return many items. I have created a list of roles. I would like to lookup the role and retun many permissions...

I have a database and want to know if there is a way to build this formula without typing this in: Countif(,B6) Category is a heading in the column of the...

Hi All What is wrong with the following formula =HLOOKUP(Diary!$H$24,'Promoters costs and sales'!C1:DR11,11,0) Its function is to use the date in Diary!H24,...

Whyn do I get NA error when I type the following formula. =VLOOKUP(B5,SS!$A$2:$C$170,2) SS is the worksheet A2 has last name C170 has personal ID # Thanks

I have a column of address information (Street City State Zip) each address is contained in one cell. I need to seperate the information so that the Street...

Hi I have a worksheet whihc has a combination of protected and unprotected columns of data. I want to enable users to delete rows even when the worksheet is...

Hi, I have a macro that was created in Office 2003 (i still have a copy in a virtual machine) and was expecting this to show up in the addins section of...

I created a personal.xlsb file and put it in the xlstart folder. When I open a blank workbook, my macros don't execute. Do I need to do something else? ...

Hi I have many spreadsheets where I enter time based data and then want a graph to display the culmative of the data. ie Jan 10 Feb 22 Mar 35 Apr 3 I...

Hello, I am using Office 2007, which I am new to from 2003 and which I am not liking that much. I created a workbook in Excel to use for mail merges for my...

Have a new one... Using Excel 2007 on XP, when I double click a 97-2003 file it opens Excel but does not open the file. (XLSX files work fine.) This has...

Good Day I am currently using the below formula for min and max value by month(). I would like to go a step further now and recover the sum value between 2...

Hi I want to count the number of cells containing a particular uppercase character. I tried using =COUNTIF(J2:AN2,"H") but this counts lowercase as well. Is...

When printing a table with text, the text is out of line with the table???

I have hundreds of "yes" or "no" on column C, and hundreds of "yes" or "no" on column D, and corresponding student number in each row related to "yes" or...

I have 2 worksheets in a workbook which are filled in by other users using a selection of drop down lists and vlookups etc. and I want to be able to...

Is there a formula where you could do the following: 1A 200, 1B 25,000 2A 201, 2B 30,000 3A 202, 3B 10,000 4A 200, 4B 15,000

I'm am still searching for an answer to this. I am needing to count the number of customer's with the occurance. The formula below counts the number of...

I would like to be able automatically insert a row below the last row of data that would have the word “Total� displayed in the column AC and then...

My formula is this: =F28-SUM(G28:K28) My cell contents a F28 = 682.59, G28 = 42.32 (a calculated number of 6.2% of F28), H28 = 9.90 (a calculated number...