| Thread | Last Post | Replies |
|
| Hide values in a Drop Down list | 24 Aug 2008 07:02 GMT | 1 |
I have followed the contectures website to no avail. I am trying to creat a fantasy football draft wroksheet and I have 7 drop down options: Top200, QB, RB,WR,TE,K, DEF
|
| reverse cursor/text direction within cell | 24 Aug 2008 06:12 GMT | 4 |
I'm trying to enter text within a cell from right to left instead of the default left to right. For example, if I type "jason" I normally see "jason" in the cell. What I would like to see is "nosaj" instead of "jason". I'm not looking for a reverse text macro since I want the
|
| Formula Correction | 24 Aug 2008 03:17 GMT | 5 |
Can you help me correct this formula. =IF(New_Table!D2=TRIM(SUBSTITUTE(A1,MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),SUM(LEN(A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},"")))),""))"LT","Part Time, or Temp Student",IF(New_Table!D2="DLT"=TRIM(SUBSTITUTE(A1,MID(A1 ...
|
| How to multiply column and rows | 24 Aug 2008 01:15 GMT | 13 |
Hello friends i know how to multiply a single row or column that if i want that Multiply A1 and A2 then i write in my desire box "=A1*A2" thats it. But the problem is this that i want to multiply all data of the A row with B
|
| macro wich saves files | 24 Aug 2008 01:02 GMT | 5 |
I would like to set a macro which automatically saves every 10 minutes a file which is open 24/7. Could anyone help me with it. Thanks in advance for your help.
|
| Counting texts | 24 Aug 2008 00:56 GMT | 2 |
From A1 to A1000 my list has names that I add and erase depending on something else. It is possible to keep update counting of how many names I have in that mention range ? Which formula ? THANKS
|
| Percentage Breakdown Formula Help? | 24 Aug 2008 00:16 GMT | 5 |
I have a spreadsheet that I'm using to record statistics. I grab those statistics from another sheet entitled "Raw Data". The following fomula provides me with raw score data for all outcomes in Column V that are 91% or greater:
|
| if formulas | 24 Aug 2008 00:02 GMT | 10 |
I'm trying to create a formula that does the following. Can you help me put it in the right format? if E8=X, then G8=G4*m8 and if E* is blank, leave blank
|
| IME MODE FOR EXCEL 2007 (URGENT URGENT) | 23 Aug 2008 23:16 GMT | 1 |
How can we use for IME MODE FOR EXCEL 2007 in Windows Vista? THANK YOU SO MUCH FOR YOUR HELP IN ADVANCE. STELLA
|
| copy last populated cell (moving) to another cell | 23 Aug 2008 22:16 GMT | 1 |
I need a formula to copy the running balance in a column to another cell. The running balance cell moves up/down
|
| count characters | 23 Aug 2008 21:14 GMT | 2 |
is their a formula to count how many times a character appears in on cell thanks ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the
|
| Average rating by name. | 23 Aug 2008 18:26 GMT | 7 |
I am creating a spreadsheet for one of my favorite shows that includes director name and rating for each episode. What I want to do is show the average episode score for each director. In a sense it needs to find each row with a certain directors name in the director column, ...
|
| how do I compare versions of an Excel worksheet | 23 Aug 2008 17:06 GMT | 3 |
I have a worksheet file (of contacts information) from 1998 and another from 2006 which are the same size (25kb). I now need to update the data. I suspect there's no change in the data between the two versions, just a change in the way I have coded file names, but I need to be ...
|
| A bit of a complicated Array that I can't figure out! HELP! | 23 Aug 2008 16:16 GMT | 6 |
Not exactly sure how to come up with the proper formula, but I do know the requirements that I'm looking for. If anyone could help I'd appreciate it. I have two columns of data, and 5000 rows. The Columns are (M) and (AC).. Each cell in Columns (M) and (AC) have numerical values ...
|
| linked cell to change another cell | 23 Aug 2008 16:02 GMT | 5 |
I have a checkbox linked to cell A1. In the cell B1 I have a number which could be (say) 1 or 2. When the checkbox is "unchecked" and therefore A1 = FALSE I want to clear the contents of B1. I can't do it by a formula in B1 because the number has been entered manually.
|