| Thread | Last Post | Replies |
|
| In a column of numbers I need a function to find the last entry | 13 May 2006 21:05 GMT | 4 |
For example I have a column that shows the running balance on a bank account.
I want to find the latest balance which will be on the last populated row of
the spreadsheet
|
| How delete formula bar and retain the computed number in a cell? | 13 May 2006 20:50 GMT | 3 |
Example:
The number in C10 is 12, as computed by a formula in the function bar (such
as =C8+C9). How do you delete the formula and RETAIN the number 11? Thanks.
|
| Formula for totaling column | 13 May 2006 20:26 GMT | 3 |
Have 13 column by 10,000 row spred sheet. column A represents a salesmans
number while column B thru M represent different products that the sales
person can sell and the quantity that's sold.
Sp Prod Prod Prod etc
|
| How to make only the cells i need active | 13 May 2006 19:49 GMT | 3 |
I have always seen this on spreadsheets (making only cells in us
active), the cells in active are normally grey. I need your help
Thanks
Debbie:confused
|
| deconcatenate | 13 May 2006 15:56 GMT | 1 |
How can deconcatenate string in excel.
Regards
TP
|
| How do I get a line break when using a formula to combine cells | 13 May 2006 15:15 GMT | 5 |
I want to combine names and addresses into single cells, but I want a line
break so that the name is on one line and the address on the next line within
a cell. When manually entering data to a cell ALT,ENTER gives line break. I
want the formula to give the same effect as ALT ...
|
| Is This Possible? - Data matching | 13 May 2006 14:50 GMT | 4 |
I have a 3 columns of data:
INFORMATION | TYPE | MATCH
Jim Firstname
Jack Firstname
|
| easy | 13 May 2006 09:20 GMT | 10 |
hi. this is probably an easy question, but please could someone giv
some help.
I have a list of names in a column..
in another column i want a list of a website URL, forward slash th
|
| COUNTIF Formula in Excel with two conditions | 13 May 2006 07:00 GMT | 3 |
Okay I give up! I have tried COUNTIF, SUMPRODUCT, IF, COUNT, and I cannot
get this to work. I have a spreadsheet that if the following two criteria
are met I want to count it.
Column D - "ASA-2"
|
| Formula Help | 13 May 2006 05:56 GMT | 1 |
Column B, C and D contain values
I need a formula that will look a each value in those columns and post the
result in Column E
Please and Thanks
|
| if column 1=>3 then column 2, if not return no value-Help? | 13 May 2006 05:37 GMT | 1 |
I have been given the assignment to devise the following formula in an Excel
Spreadsheet:
Mean Average Value
Formula: if column 1=>3 then column2, if not return No value.
|
| Count ; in cell | 13 May 2006 02:39 GMT | 9 |
I've got another software program that will be filling a cell in Excel based
on a multi-select drop-down list. The Excel cell could read
Algonquin;Bloomingdale;Burr Ridge
I'm trying to count the occurrences of ; in that cell then add 1 to get a
|
| IRR for 2 cash flows | 13 May 2006 01:40 GMT | 1 |
I have the monthly closing prices and dividends of a stock in 2 separate
column. I want to calculate the IRR for a seven year period, i.e the investor
bought the stock and held it for 7 years and received the dividends. I am
able to calculate it , but the thing is that I have to ...
|
| can you count data in a cell to give a value? | 13 May 2006 01:16 GMT | 3 |
Anybody with assistance please.
I want to calculate the data in cells to provide a value for a second
calculation.
Example
|
| help for RAND | 13 May 2006 00:13 GMT | 3 |
when i use RAND() to choose no between 1-15, every time i do it, no
changes, how to stop that happen?
Example: A1-1,A2-3,A3-12,but when i do A2, A1 change to different no.
and what can i do if i want to pick random no between 1-15 but i dont
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread