Functions
in [Excel]
|
VBA data validation Hi all, I have created a textbox input on a userform. I would like to input the postal code here and would like to dala validate it for a 6 numeric input. Is ther a way to do this ... 9 May 2010 19:49
Colour code specific name if it appears in a group of names I want to be able to colour code the name of jo bloggs when his name apprears in a cell that has many names. I have been able to colour code a range of cells with a few names but I have a list to 200 names that I need to check against the same listing of names. I used conditional format but need to be able to... 9 May 2010 00:21
update vlookup formula sheet reference for multiple sheets In Excel 2003 Starting with this formula I need to have the sheet name change to each tab available on the sheet. =VLOOKUP($A$1,'4-4 to 4-10'!$A:$P,13,FALSE) Other tab names are: 4-11 to 4-17 4-18 to 4-24 4-25 to 5-1 Looking for a more automated way to create the following other than manually change the sh... 8 May 2010 04:44
Question using countif I'm using office 2007, specifically excel. I cannot get the countif function to accurately count cells containing multiple numbers. For example below is a column containing both single and multiple numbers. I'm trying to get a count based on any number in the column. Perhaps, I'm using the wrong count function.... 14 May 2010 20:31
sumifs multiple columns help Excel 2007- I cannot get my sumifs formula to work. If I just have the sumrange one column of data it works perfect, but I need it to sum multiple columns. Here is my current formula: =SUMIFS('Original Data'!$C$2:$C$46668,'Original Data'!$A$2:$A$46668,$A3,'Original Data'!$B$2:$B$46668,B$1) I need the first ... 8 May 2010 04:44
Graphs in Excel 2007 I am new in Excel 2007. In Excel 97' there was an option or using special graphs which allowed you to have dual Y-Axis. You could then graph both $ and % values on the same graph. I am able to find the same functionality in Excel 2007. If someone can point me in the right direction that would be helpful. Th... 7 May 2010 14:32
Select Month, get the dates Hi, I want to be able to select the month from the drop down list and once the month is selected, I want the first date cell to change itself to the first date of the month selected. For rest of the date cells I have just used the formula "First date cell + 1" any help will be appreciated!! Thanks a lot in ... 7 May 2010 15:39
vlookup i need a formula that will look up a word then give me the numbers in a cell next to that word. the formula i'm using (which isn't working right) is =IF(ISERROR(VLOOKUP(A6,'Export 1'!$B$1:$Z$65467,11,FALSE)),"",VLOOKUP(A6,'Export 1'!$B$1:$Z$65467,11,FALSE)) this may be too much formula for what i need but i'... 7 May 2010 16:45
How to know if a worksheet was unlocked Yes I could ask the users, but I doubt I'll have always the truth! I know how to automatically lock and unlock the sheet via coding, but I want to trace if the sheet was unlocked via the menus. I did an excel tool with formulas that I know, but these formulas could be changed if needed by the users, but I need ... 1 Jun 2010 15:19
Excel How do you center information on the spreadsheet? How do you add a sheet to your document ( I have 3 sheets at bottom but need additional ones)? ... 7 May 2010 16:45 |