Excel - using Excel worksheet functions

Thread preview

Thread	Last Post	Replies

Sorting Data in Tables	14 Dec 2005 07:58 GMT	2
I have a fairly significant amount of data that I would like to have at least two different methods of sorting similar to, or including a VLookup function. For example, if comparing a widget company to the widget industry as a whole, I would like to compare the subject company to ...
Help with Combination Function	14 Dec 2005 07:26 GMT	4
I want to list down all possible combinations of sizes from a size list. We produce Paper Rolls in a specified size ie; 161 inch. We receive cusomer orders in small sizes. So I want to know which sizes could be combined to slice the Big roll to avoid maximum loss. For eg I have ...
Help with a complicated array formula	14 Dec 2005 06:07 GMT	7
Hi-- I'm trying to sum an array that meets certain conditions into a single cell A B C
Looking up Top N using criteria	14 Dec 2005 06:03 GMT	10
In workbook A, I have a unique list of customer IDs in column A: Cust ID 1 000011 2 000012
Count	14 Dec 2005 05:55 GMT	5
I would like to count the cells of a column which are equal to a specific colour of background. Can someone advise how to accomplish it. Thanks, Ray
INSERT COMMENTS WONT SAVE	14 Dec 2005 03:57 GMT	2
EVERYTIME I ENTER A COMMENT INTO A CELL AND PRESS SAVE ITS NOT THERE THE NEXT I GO INTO THE FILE, I NEED TO KNOW WHAT WOULD BE CAUSING THIS TO HAPPEN SO I CAN FIX IT! IAM USING MICROSOFT OFFICE 2003
How do I unhide a column when format/column/unhide won't work	14 Dec 2005 03:38 GMT	1
How do I unhide a column when the format/column/unhide procedure won't work?
Sum numbers only; no text	14 Dec 2005 02:48 GMT	2
Column V has dates that are manually entered. However, there might be on occasion where the word "cancel" is typed. I have the below formula that sums column V. How can I get it to sum without counting the text? Since it sees the text it is giving me a #Value error.
Need formula for: IF K1 = y then M1= the date in A1 + 15 days	14 Dec 2005 02:23 GMT	2
Can anyone help me with creating a formula for the following: If K1=y, then M1=date in A1+15 days Thanks!
need to remove a comma from end of test in cells	14 Dec 2005 01:25 GMT	4
I have a column of text that has a comma at the end of of the text in each cell. How can I remove the comma from each cell. Is there a formula to do this?? Thank you,
creating a complex cell	14 Dec 2005 01:12 GMT	1
I want to have two colons in a cell as dividers for information to be entered at a later date and manipulated. How can I lock these two colons in so they do not move or are not deleted?
Autopopulate with zero	14 Dec 2005 01:11 GMT	3
Columns V, X, AA, AB, and AD may have dates in them that are entered manually. Sometimes they will be left blank. What I need is a formula that will put a zero in columns V,X,AA, and AB when column AD has a date entered.
Value Return	14 Dec 2005 01:09 GMT	6
In cells from C2:K2, some cells have either a number or a letter. What I like to have is a formula like If(sum(C2:K2) have anything in them numbers, letters, return value 1, otherwise return 0) It's easy if there are numbers in any given row, but the letters are throughing me ...
Formula to compare a cell to find same value in a column in Excel	14 Dec 2005 00:38 GMT	1
I have customer data in an Excel spreadsheet with about 500 customers IDs in one column and a list say 60 delinquent customer's IDs in another. I want a simple formula to state whether a customer on the list is delinquent or not, preferably to put a "1" in the column if the ...
HOW DO I USE TWO IF FUNCTIONS IN ONE CELL?	14 Dec 2005 00:34 GMT	1
I am trying to take one cell and say if my number is greater than 1 then use that cell's number if not use the number 2 and if that number is greater than 13 then use the number 13. If the number is less than 13 then use that cell's number. Can this be done in one cell using ...