| Thread | Last Post | Replies |
|
| Want to display financial formula result... not the formula | 05 Sep 2007 09:26 GMT | 2 |
When using the Financial Functions, I bring up the function pop-up box, type in my number or cell addresses and hit enter... well I get the result within the pop-up box, but then when I close it all I see for that cell in my spreadsheet is the formula. How the hec do you make ...
|
| How to read the value of a cell | 05 Sep 2007 09:10 GMT | 17 |
Is there a way to read the value of a cell that has a formula in it? I have one cell who's formula reads the value of other cells, but some of those other cells would have formula's in them. Is this possible? Thank you
|
| vLookup from 2 different lists | 05 Sep 2007 09:02 GMT | 3 |
I have a pallet of product to be disposed of and I need to check whether its serial number appears on a "Approved" list or a "Not Approved" list (2 different sheets both lists named). I have currently have 2 colomns (1 for each list) but would like to have only 1 colomn to show ...
|
| auto SUM bottom page | 05 Sep 2007 07:19 GMT | 2 |
on updating microsoft, i lost the auto SUM function that shows up on the bottom of excel page (when you highlight a column or cell and then the total appears in the bottom right hand corner on the tool bar). Also lost the filter indicator on the bottom left side of the screen. I ...
|
| find first and last in row of numbers | 05 Sep 2007 07:04 GMT | 2 |
I have a sequence of up to 4 numbers in a row (Column A to D). Sometimes there are #'s in all spots, sometimes in just the first one, any combination of a random # or blank is possible. Only rule is that there must be a number in the first position (column A).
|
| Date Conversion dd.mm.yyyy to dd/mm/yyyy | 05 Sep 2007 06:42 GMT | 1 |
I have a proprietary program which exports date time values to a text file in this format dd.mm.yyyy and i would like to be able to work with these values in excel, but of course excel likes dates to be in dd/mm/yyyy format. Any ideas on how to go about converting them?
|
| concatenation | 05 Sep 2007 05:36 GMT | 2 |
hi, i would like to have filtered output in concatenate, i don't know how i can do this :( col A has make of Car's and col B has Models and i would like to
|
| formula question | 05 Sep 2007 04:18 GMT | 5 |
I have 5 combo boxes, their default value is blank with a reference of 1. The user selects a size from the list in the combo box. Ie. 11oz 14oz 16oz etc... I want to, lets say the first box they select 11oz which is reference 2 they go onto the second size combo box 2 and select ...
|
| Adding values from a different worksheet | 05 Sep 2007 03:17 GMT | 2 |
I have a budget workbook that includes a breakdown of expenditures (checkbook register style) in one worksheet (worksheet(1)). Each breakdown item includes a location number. There are a total of 20 location numbers. In another worksheet (worksheet (2)) I have a total amount ...
|
| counting the number of times a word appears | 05 Sep 2007 02:49 GMT | 5 |
I have over 1000 entries where one colum contains cells with multiple info such as: Provide professional development opportunities, Subsidise the cost of training courses, Organise social events, such as presentation nights,
|
| How do you truncate 2.22 to just 0.22? | 05 Sep 2007 01:14 GMT | 6 |
Say I have a list of cells with numbers, some even some odd and some with trailing decimals like so. 2 2.33
|
| how do i put color in a cell based on data in a second cell | 05 Sep 2007 00:32 GMT | 5 |
Cell A1 has 8 digit number manually entered each day. Cell B1 has a single letter manually entered each day (same time as A1 entry). The background color of cell A1 will be determined by the single letter in B1. I've looked at conditional formatting, but haven't had much luck. I'm
|
| Time and lunch breaks | 04 Sep 2007 23:42 GMT | 5 |
Is it possible to subtract two times and automatically have it subtract .5 hours for a lunch break if it is over 5 hours? I'd like to do this all in one cell. Any suggestions would be helpful!
|
| click on one cell to locate another cell | 04 Sep 2007 23:12 GMT | 3 |
I want to click on one cell to fine another cell in the same worksheet, like a hyperlink within the worksheet
|
| how do i transfer necessary rows/data from a master sheet | 04 Sep 2007 22:52 GMT | 1 |
i have downloaded a master sheet with info for 10 specific groups. now i would like to set-up a macro in a different sheet to pull only the data related to one particular group. it seems like a easy macro but i can't figure it out. can someone help?
|