| Thread | Last Post | Replies |
|
| Lookup Help | 19 Nov 2007 01:30 GMT | 2 |
I am trying to look up UPC values in column B. If a UPC listed in Column B is also listed anywhere in Column C, then I want to return 'Yes" in column D. If not I want to return 'no". I am sure this is simple, but I can't figure it out from Lookup help. Thanks!
|
| VLOOKUP | 19 Nov 2007 01:25 GMT | 2 |
I am making a billing system which will pick product prices automatically from a price list of products. My prices should change automatically according to latest price. I have products like this column A column B column C
|
| Pivot Table exclude negative values from sum | 19 Nov 2007 01:23 GMT | 2 |
Using Excel 2007: I am using a pivot table to sum staff by department. Some departments have positions shown as a negative (indicates they belong to a different department/budget). When I include the FTE column in my pivot table to
|
| mouse trouble in excel | 19 Nov 2007 00:51 GMT | 4 |
I use excel 2003 at work and when I try to right click on a cell to get the copy paste menu nothing happens in any cell. I checked it in work and it works fine as well as in diffrent programs we use. It only fails to work in excel is there a option that has been disabled?
|
| Protection - Allow Group/Ungroup but lock / unlock some cells | 18 Nov 2007 22:31 GMT | 2 |
I have a spreadsheet which allows people to enter some figures in some cells. Those cells then add together to creat bew totals. I want to allow them to see all the individual lines or allow them to use the group +or - (the rows have already been grouped) to change the views.
|
| Random Number Generation at Interval | 18 Nov 2007 22:18 GMT | 1 |
I could use some help with gernating a random number (between 50~75) in cell A1 at set time intervals (in seconds). The value of the interval would be entered in B1 with a command button for "start number generation" and "stop number generation"
|
| How To Anchor Chart Data | 18 Nov 2007 21:47 GMT | 2 |
I am using this code to add/paste data from another sheet(1) in to column K on sheet2 at 1 minute inertvals. This macro works fine and when it runs it emulates a stream of data (1 min appart) which places the most current value in colum K and the value streams to the right with ...
|
| Value searching in columns - vlookup can not do it? | 18 Nov 2007 19:32 GMT | 4 |
This may not be an easy one to follow, so if you need more information please let me know! I have two columns of original data which are linked. Column A is time and B is acceleration at each time in A. From these two columns of data I need to
|
| COUNTIF limitations, alternatives? | 18 Nov 2007 19:20 GMT | 5 |
I'm entering the results of a survey into Excel. The answer to one of the questions was a number from 1-6. I entered all the data, then used COUNTIF to tell me how many respondents entered 1, how many 2, how many 3, etc. Now I'm getting the next survey coming back, almost the ...
|
| progressive sum | 18 Nov 2007 18:12 GMT | 3 |
dear sir, i want the progressive sum of cell values in one column like this column "a" , "a1"=10,"a2"=15,"a3"=20,"a4"=30 and i want the progressive sum of column A in column B like this
|
| SWITCH NUMBER BY LETTERS | 18 Nov 2007 17:43 GMT | 3 |
i would like to change in excel program number by letters for example: 1245 = mil doscientos cuarenta y cinco
|
| vlookup - matching where codes are not exact | 18 Nov 2007 17:12 GMT | 2 |
I need to match product codes from multiple spreadsheets and am using vlookup. Have been succesful up to now but have now hit a point where the data is not clean. So a product code on sheet 1 = abc1xyz whilst on sheet 2 the same product = abc1(xyz).
|
| numbers rounding | 18 Nov 2007 17:00 GMT | 1 |
been using excell to track orders. i recently upgraded from office 2000 to 2007. all of a sudden when i type in a number like 250, it shows as 3 on the spreadsheet.
|
| Why Cos(45) is not equal 1/Sqrt(2)? | 18 Nov 2007 16:35 GMT | 2 |
Does anyone have any suggestions how to use Cos function in Excel? When I type =cos(45) in cell A1, it returns 0.525322 which is not 1/Sqrt(2). Does anyone have any suggestions on how to use Cos? Thanks in advance for any suggestions
|
| French format | 18 Nov 2007 16:25 GMT | 3 |
I have the need to have 2 cells side-by-side (one in English and the other in French). In the English one, I have =Text('variables'!$B$33,"dddd mmm dd, yyyy") which results in the value 'Saturday, September 01, 2007' being returned.
|