| Thread | Last Post | Replies |
|
| VB in Excel | 21 Oct 2006 02:25 GMT | 10 |
What I have is a list of names, and a value beside it. Each name has it's own sheet within the workbook. I'm trying to call a macro/VB script in order for it to go to the worksheet I need, pull the info and put it into the value beside the name in the list. If I hard code the ...
|
| how do i link up 2 sets of data into 1 set of data in excel | 21 Oct 2006 01:52 GMT | 2 |
i want to concatenate 2 sets of data into 1 set. how do i line up like rows. the basic dat sort doesnt work as not all of the data are the same in the 2 sets. i know you use concatenate somehow. the example is data set 1 is name and phone numbers , data set 2 is names and ...
|
| Using the current row in a formula | 21 Oct 2006 01:33 GMT | 3 |
This is probably a simple question :) I have a formula where I would like to reference a different column in whatever row the formula is in. Something along the lines of
|
| conditional formula | 21 Oct 2006 00:40 GMT | 2 |
I need to sum cells based on color coding. I am unable to determine how to do this in the conditional format. Thanks for your help Rose
|
| Date Range displayed in header | 21 Oct 2006 00:24 GMT | 6 |
I am attempting to put the range of MIN and MAX dates pulled from a column. I would like it to look like: Date Range: 9/6/2006 - 10/26/2006 from a column like this:
|
| CAN'T INSERT SYMBOL? | 21 Oct 2006 00:23 GMT | 4 |
In Excel 2000, under XP SP2. I lose the insert symbol function at odd times. Some times if I shut the file down and re-open it comes back other times not.
|
| Wireless Network Use | 20 Oct 2006 23:56 GMT | 2 |
Can an Excel worksheet be SHARED to wireless networked laptop
|
| 256 ways to make hamburger | 20 Oct 2006 23:50 GMT | 2 |
how to I input into excel to do a spreadsheet on 256 ways to make a hamburger
|
| average low 10 of last 20 entries | 20 Oct 2006 23:36 GMT | 9 |
I have a continuing list of numeric entries. At any one time I want to be able to cvalculate the average of the lowest 10 of the most recent 20 entries. I'm using Excel 2002.
|
| how to split abc123 into abc 123? | 20 Oct 2006 23:32 GMT | 3 |
i need to sort by 4th char. or split the data into two different colm.
|
| Return Numeric Values Matching EXACT Date for Criteria | 20 Oct 2006 23:20 GMT | 4 |
I would like a Formula that returns numeric values ONLY if they MATCH the EXACT date. The Formula below does work in part. But when the actual date does not exist or a value for that date does not exist, the Formula returns a value nearest
|
| Function is displayed as text rather than giving a value | 20 Oct 2006 23:19 GMT | 2 |
Ever since our company switched to Office 2003 (about a year ago), I've been having a problem when entering functions. They show as text in the cell rather than giving me the answer/value [ex: =IF(BF2=S2," ","XXX")]. I then end up having to do a text-to-column in order to fix ...
|
| Solver whole numbers | 20 Oct 2006 21:38 GMT | 2 |
In Solver, if my changing cells are percentages does solver have a way to only use whole numbers with no decimal places?
|
| Why isn't Excel dragging the right value? | 20 Oct 2006 20:41 GMT | 6 |
I am using SUMIF and have been able to drag the formula down the column and the right values pop up. Now, when I drag, the column is filled with the value in the first cell in the column. After dragging, I can double click the cells or hit F2 (to edit) then hit
|
| vlook | 20 Oct 2006 19:54 GMT | 6 |
Hello I have a formula in a cell and the response is #NA. Here is the formula =VLOOKUP($J33,'2006 Discount Grid'!$A$1:$O$386,12,FALSE) the reason I'm getting the #NA response is that $J33 is also a Vlookup. but I don't know
|