| Thread | Last Post | Replies |
|
| Calculating Dates | 07 Feb 2008 00:56 GMT | 6 |
Need to a run adhocs on the 1st and 15th of each month to find individuals who will reach the age of 59 1/2 two weeks prior to the reaching the 59 1/2 age, bascially the 15th adhoc run is to cover the first half of the next month and the 1st adhoc run to cover the second half of ...
|
| Date/time increment specifier | 07 Feb 2008 00:38 GMT | 4 |
Date + 1 increments the date. How do you increment date at year, month, hour, min, or second? Ex: Is there anything more compact for “Date + 1 year” than DATE(YEAR(Date) + 1, MONTH(Date), DAY(Date))?
|
| Reconcile Inventories Using excel | 06 Feb 2008 23:55 GMT | 10 |
I have two inventories downloaded into Excel and need to reconcile them. There 500 items in each worksheet. Is there some kind on add in or function to use that will compair them and tell me what the differences are.
|
| PDIFF , DDIFF | 06 Feb 2008 23:38 GMT | 1 |
What do these mean and how do they work? Thank you, Steven
|
| automatically copying cells | 06 Feb 2008 23:23 GMT | 1 |
Can excel automatically copy the content of one cell to another cell? For example, if I want the contents in say column L, row # 10 to automatically copy to column E, row 10 when I type the info into column L, row # 10 ... how do I do that?
|
| I want brackets around my math equation answer? | 06 Feb 2008 23:20 GMT | 7 |
I am putting together a equipment table that has to have entries in metric. I would like to set it up so that you type in the english units and it would the convert into metric on the next line. However i have to have Brackets around the Metric numbers...is there a way to do ...
|
| Formula editing | 06 Feb 2008 22:49 GMT | 2 |
I usually edit complex formulas in a text editor, especially if I want to replace constructs, ex: replace string check for “PROD_1” with “NPRODX_2”. Is there a way to extend the Excel Find/Replace to formulas? This would be very helpful in replicating entire sets of formulas for ...
|
| {=SUM(ABS($Q$5:$Q$651))} | 06 Feb 2008 22:44 GMT | 3 |
I am looking at spreadsheets someone else built and seeing cells with formulae like what's shown in subject. I can see what it is supposed to do which is to sum the absolute value of each cell referenced, which is something I want to duplicate elsewhere.
|
| recall cell value in hyperlink | 06 Feb 2008 22:30 GMT | 2 |
Thanks for taking the time to read and hopefully help me come up with a solution... Cell A1 = 1234 cell A2 =hyperlink("http://www.website.com/" & "A1" & ".aspx","name to
|
| find last row value in column when using MATCH to find column | 06 Feb 2008 22:16 GMT | 6 |
I have a problem where I use MATCH to find a column with a specific heading and then I want to find the last value in the column. I would like to achieve this just using formulas in the worksheet if possible All the solutions I have found require the Column letter ("B") instead ...
|
| change font color on search | 06 Feb 2008 22:11 GMT | 2 |
Hi, I need to do a search and replace in a worksheet. When I match a string, I want to change the color. For example, if the string is "Hello everyone!"
|
| Search and calculate formula | 06 Feb 2008 22:09 GMT | 4 |
I am working on a project and trying to figure out a formula. What I want to have happen is in the A column I have different project codes and in the H column I have the cost of the task. I would like to have a formula that will find a specific code in column A and then add the ...
|
| Sumproduct syntax when using AND, OR | 06 Feb 2008 22:04 GMT | 3 |
I have a list of trouble tickets with ticket#, open and close dates recorded like this: A B C 1234 05/01/07 06/15/07
|
| Formula Help | 06 Feb 2008 21:27 GMT | 2 |
I am really computer (dumb)! I want to create a formula so when I type in the #1 John Smith will be entered into that cell.
|
| enter if less than | 06 Feb 2008 21:10 GMT | 4 |
i am trying to get the sum of two cells or $30, whichever is less g98*3<30 if g98*3 is more than $30 i want it to return $30 otherwise return the sum of G98*3
|