| Thread | Last Post | Replies |
|
| Filtering numbers in a column? | 12 May 2006 20:24 GMT | 4 |
I have a column within a spreadsheet that has sets of numbers in it. The numbers are random. For example: 129 245 789 345. What I want to do is filter these rows and pull out the rows that have just the number 245 in it or bring them to the top or seperate them in some way. Can
|
| Finding duplicates in 2 worksheets | 12 May 2006 20:06 GMT | 2 |
I have 2 worksheets of data for a mailing list I'm doing. The first worksheet has criteria pulled from one set of software and the other is from a separate system. What I want to do is find which account numbers from Sheet 2 appear on Sheet 1. Those that match get deleted from ...
|
| Right-click inside of a cell | 12 May 2006 19:28 GMT | 3 |
I can't right-click inside of a specific cell anymore so that I can format. I can highlight an entire column and right-click and it gives me all the format options then, but it won't work if I just right-click to a specific cell. can anyone help?
|
| Choosing data based on Match to several items | 12 May 2006 19:19 GMT | 5 |
I have a range of data that is organized based on 5 data points. I would like to develop a formula the chooses the proper data based on the values in the five data points. Is there an easy way to do that? I have looked at the Choose, Match, and Index functions and none seem to ...
|
| Array formula using two columns and countif | 12 May 2006 19:02 GMT | 8 |
Having trouble getting Excel to compute a value based on two columns on another sheet. What I need it to do is see if column A has the value I specify, then look in column B and see if that date figure is greater than 180 days, and then count it. So I might have 45 that meet ...
|
| Split 2 words | 12 May 2006 18:54 GMT | 1 |
I have 2 words I each cell, I would to put the 2nd word in a new cell, how am I doing it?
|
| Capital | 12 May 2006 18:47 GMT | 5 |
I would like that the 1st letter of each word should be capitalized, how am I setting it up?
|
| SUMIF with 2 conditions | 12 May 2006 18:39 GMT | 6 |
I am trying to use SUMIf with 2 conditions, I see someone else asked this question before but I still can't get it to return anything other than #Value! Can anyone help me? =SUMPRODUCT(--('Raw Data'!F2:F60000="TEST");--('Raw
|
| Validation List | 12 May 2006 18:33 GMT | 3 |
I have a column consisting of Weeks. like this: A | B =============== Week 1 5646.00
|
| Find | 12 May 2006 18:29 GMT | 2 |
I have a worksheet with 100’s of names. The first & last names are on separate cells (in the same row). I am trying to find “JOHN DOE”, how do I search for it?
|
| If's conditions about matching | 12 May 2006 18:27 GMT | 8 |
How can I code these if's conditions: 1) If the first letter of the statement is "A" or number "2" 2)
|
| Is it possible to merge data from two worksheets? | 12 May 2006 18:19 GMT | 2 |
I am wondering if it is possible to merge two worksheets, that have the exact same column headings, into one document, eliminating duplicate data based on a specific column. On a weekly basis I am required to run a report and evaluate it for action items. I am making notes on my ...
|
| COUNT and OFFSET | 12 May 2006 18:10 GMT | 3 |
I have a range of Data: F8:CT8 I need to count the 1st column in this data range with there being 3 columns. I just need to count if there is data in the cell excluding zeros.
|
| Increasing values in Price column | 12 May 2006 17:46 GMT | 3 |
Hi, I run a business and in my spread sheet I have a column for prices - Since gold and silver have risen to all time highs I need to increase the prices by 20% - there are over 24,000 items - is there an easy way to do that ?
|
| How do I create a formula that makes text in a cell = 0 | 12 May 2006 17:20 GMT | 1 |
I working on a complex spreasheet where some of the entries are NA. I need the spreadsheet to perform numerous calculations (add, subtract, multipy and divide). I want Excel to recognize that anytime it sees NA in a cell NA should equal
|