General

Combo Box
I want to use a combo box in place of a Vlookup function. I have a list of 2048 possible logical ID's for some equipment. I want the keeper of the record to assign a logical ID for the equipment to a row that has other various identifiers. How do I remove an item from the list after it has been used in a row... 11 May 2010 13:25

2003 Filter and Sort Ascending
I have a database with over 2000 entries. I generated the database in excel 2007, but my clients only have 2003. When they sort the zipcode field in ascending order in 2003 (using the filter drop-down), the database only sorts some of the data and not all of it. How do I solve the problem of the filter sort asc... 11 May 2010 13:25

Input in Column IV if countif satisfied
Hi, I am trying to input "WRONG" in COLUMN IV if the countif changes the cell colour. this part of the code is not working though Range("IV" & ActiveCell.Row) = "WRONG" 'MY FAILED CODE My full code: - OFFICECODESARRAY(1) = "DY:DY" OFFICECODESARRAY(2) = "EL:EL" OFFICECODESARRAY(3) = "EQ:EQ" OFFIC... 11 May 2010 13:25

i want to convert decimals into time format
I have a (time) table with numbers such as: 1.28 , 0.15, etc...where the first digit represents the amount of minutes and the two decimals represent seconds. in the example: 1.28 = 1 minute and 28 seconds and I would like to convert in excel these tabulated times into a 00:00:00 format. So the outcome I'm l... 13 May 2010 09:23

VLOOKUP #REF error
I have a vlookup that works for the first 14, columns I want to reference. But when I get to the 15th column I get the #REF error. This is the formula: =VLOOKUP($A2,$A$1100:$N$7704,14,FALSE) Is there a limit on the number of columns a VLOOKUP array can have? ... 11 May 2010 16:48

decap names from transferred data
Hi, I just gave this a try, but I cant' seem to get the formula to apply. I have a column (C) of names in all caps. In a blank cell, I typed =PROPER(C2:C112) and then hit enter but it keeps giving me error messages. Any help? Thanks! "Gord Dibben" wrote: Once the data is in Excel it is no longer c... 11 May 2010 13:25

Percentage Formula
So here is the situation Currently at 150 and over the next year we want decrease to >24% of that So end result to be 114 How do I show each month as a percentage of that 24%? Meaning if one month we are at 123, how do I show that in comparison to the year end of > 24% ... 11 May 2010 14:33

Preserving date format
Does anyone know how I can preserve my date format (dd/mm/yy) when doing a mail merge from Excel to Word? I would like to show either dd/mm/yy or 10 February 2010, but it keeps being switched round to American format (mm/dd/yy). Thanks! ... 11 May 2010 11:11

Extract Month From A Text String
Good Day, I have a date that I'm pulling from a report that is in a text string format. What i need to be able to do is extract the month from the string so that I can run a script against the month name. The format of the string is as follows. Wednesday, April 14, 2010 Thanks in advance for your help. ... 11 May 2010 21:15

"Hidden" worksheet?
Excel file is in a shared folder. For one user only, the file opens but worksheet is not visible. Blank blue screen, no grid. File shows up in Page Preview and Full Screen View, but in Normal view, there is nothing! "Unhide sheet" is not an available option. Other users view the file just fine. Any ideas? ... 11 May 2010 14:33