Functions

Thanks
Thank you very much for the quick reply Bernard Liengme wrote: Two ideas:A) VLOOKUPOn Sheet1 make a new A columnIn A1 use =B1&C1 and copy 07-Jan-10 Two ideas: A) VLOOKUP On Sheet1 make a new A column In A1 use =B1&C1 and copy down the column by double clicking A1's fill handle In D1 of Sheet 2 enter =VL... 8 Jan 2010 03:57

count text occurance in range
I am working in Excel 2003 and would like to enter a formula counting the number of times a specific word (sometimes in a sentence) appears in a range of cells. Does somebody know how ? Thank you ! ... 10 Jan 2010 18:35

Match values in more than one column
Hi I have three columns of data and wish to highlight the matches or change the format if there are any duplicates. i.e A B C Apple Banana Cheese Banana Orange Milk Chocolate ... 6 Jan 2010 18:49

VLOOKUP/HLOOKUP Query
Hope I can explain this clearly enough . I have c 50 branches of a retail outlet, each of which have a bank account that is used on a daily basis. The accounts are, however, cleared to a central account at the end of each month by way of an automatic transfer. I need to set-up a monitoring system so that I ca... 6 Jan 2010 09:50

Excel worksheets won't all print
I have an inventory that starts with a summary page and is followed up by the individual inventory types. I have always been able to print all the worksheets or the individual as needed. I am only able to print certain worksheets now and don't see that anything has changed or can be distinguised as a problem.... 6 Jan 2010 09:50

Carriage return in same cell without using alt-enter
I know to insert a new paragraph within the same cell to use the keystroke alt-enter, however, I'm trying to make a usable form for my boss, and I'd like to make it super user friendly and not have to have her use alt-enter every time she needs to create a new paragraph in one particular cell. Any way to use so... 2 Feb 2010 17:31

use Find without hardcoded value but a value from a cell
Hi I am trying to search within Excel VBA a value in a sheet dependant on the entry in another cell. But not sure how to put a paramater as the What part of the Find. Can anyone help please? i.e if cell A1 is Cat then I would search for Cat in the other sheet. Dim Animalname AnimalName = Combo1.Value ... 6 Jan 2010 09:49

CHANGE TEXT DATE TO NUMERIC DATE
The following imported data isn't recognized as a dates: Jul 4 2008 6:30AM Jun 22 2007 5:59PM I have tried both of these formulas found elsewhere in the Excel Community without luck: =DATE(RIGHT(A1,4),LEFT(A1,LEN(A1)-6),MID(A1,LEN(A1)-5,2)) =TEXT(TEXT(A1,"00000000"),"00-00-0000")+0 .................... 6 Jan 2010 09:49

How to insert lines into a workbook without changing references?
WORKING IN A MULTI REFERENCED DOCUMENT TRYING TO ADD LINE ITEMS AND GET REFERENCE ERRORS. HOW DO I INSERT NEW LINE ITEMS WITHOUT CHANGING THE REFERENCES THAT ARE IN PLACE? ... 3 Jan 2010 19:23

cursor changes to arrow dash arrow in worksheet
I''m new and know this question is not related to the previous question. In Excel newest version with Win 7, I'm frustrated with an "arrow dash arrow" symbol/icon that appears at will to replace the arrow cursor. It causes the sheet to shift to the left or up or down. Is there a way to disable the "arrow das... 3 Jan 2010 16:05