Summary: Hi I'm trying to work out how to devise a formula in Excel 2003 which does the following ... Searches a range of cells for a certain text value 'False...
Summary: I have two columns of information. Column A represents original customer names and Column B represents new/updated customer names. I need a formula ...
Summary: Thanks mike, I tried that and nothing happened, that i think was for numbers. What i am looking for is like the post "compare two columns in excel" h...
Summary: You don't say where you are getting your lookup values from, so follow this example: - I put your table in A1:E6 - I put 1:00 in G1 - I put 25 May 200...
Summary: Hello, I am a self taught Excel user so I apologise if the answer to my query is a simple one. I can do basic things but one simple calculation is el...
Summary: Hi, I have got two columns in excel table. Both columns contain names of companies in Croatia. My task is to compare those columns to see if there are...
Summary: I need a formula & a macro which compare the values in two cells and f the values in two cells get matched then the value in 1st cell should be copied...
Summary: I want to sample a cell in Excel and if it is empty, I want to delete that row. I can delete a row using the row number but can't do it using a variab...
Summary: hello.is there any way i can scan a plain text document to my computer.then open it in excel,and configure it to be in an .xls format.which will allow...
Summary: Hi, I couldn't think of a way to do all of this with formulas. Maintaining a list of unique referent names on the referent worksheet seems to require...
Summary: I do a lot of work with Excel and Powerpoint. I use spreadsheets to show the data in Powerpoint. Is there a way I can update the data in excel and it ...
Summary: Matt, It's too large for a Pivot table. Insert a row at Row 1 and then add titles to the columns in that row. Hotel, Location, Bookings, whatever Then...
Summary: I'd like to use a watermark on a sheet in excel. I can create one easily in word, however, there seems to be no way to do the same in excel and no way...
Summary: is there a way to format a cell so that you can put multiple values in it? for example 1,2,3,4 1,3,4 1 2 1,3 then i can search for those values/ filte...
Summary: I often need to retrive info from SAP and fill in an excel document with it. Is there a book or a web page where I can find macros that will help me d...
Summary: My wife is a teacher and i have helped her create a grade book and attendance sheet. In the attendance sheet she wants to use 1=unexcused absence, 2=t...
Summary: I recently did a survey for a grad school project, and my results were rolled up in Excel. For questions where more than 1 answer could be given, the ...
Summary: Should be a pretty simple question for an Excel guru. I have two columns of text that are nearly identical except a few entries. I need a way to pul...
Summary: When you have a long value in one cell and the cell(s) to the right has no value, Excel displays the text overlapping the blank cells. You can set the...
Summary: This is all I could find in Excel help. Hope it is of some use. M Create a custom number format Select the cells you want to format. On the Format m...
Summary: Hi I'm not sure about other versions but in Excel 2000 the following works. Use arrows to move to the cell then press F2. It will place the cursor at ...
Summary: Not guaranteeing anything, but what program are you useing for your Database? I do it all the time in Lotus 123 and Approach. I don't convert the time...
Summary: You can write a formula (called "mySum" in my example) with Visual Basic in Excel: 1) Open the VBE by clicking Tools / Macros / Visual Basic Editor ...
Summary: Hello, I have column of numbers. I would like to replace each number according to its value. So for example my column of numbers is: 2,4,7,12,90,23,12...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
