| Thread | Last Post | Replies |
|
| IF and AND functions help required | 08 Apr 2007 23:46 GMT | 4 |
I need to set up a formula that will use two separate cells to provide a text result in a third cell. The problem is that the first cell has an upper and a lower limit to the values that influence the text output. Here's what I'm trying to do:
|
| fit multiple values into specific value (combinations?) | 08 Apr 2007 20:32 GMT | 4 |
This one is kinda hard to descibe. I have a list of multiple values. I need a way to display the correct combinations of the values, each in a different series, where the sum of each series is between x and y. :S Two example scenarios:
|
| Copying cell value to master report file which is closed? | 08 Apr 2007 19:07 GMT | 3 |
Could someone please advise how can I achieve following task: We have few guys in office who use excel worksheet to generate invoice for our clients. The format of worksheet is standard for all users but I like to generate the summary of all invoices they make.
|
| Grouping Data in Pivot Tables | 08 Apr 2007 17:42 GMT | 1 |
I have recently started with Pivot tables. Below mentioned table is the one on which I have to create a pivot table such that the average order by a given customer/company for each furniture type in a year. I
|
| How to insert text table in excel spreadsheet | 08 Apr 2007 17:40 GMT | 2 |
I need a section at the bottom of my spreadsheet where I can type text that will auto enter to the next line when you get to the edge just like in a text document. Wrap text in a cell does not work because the column with stays the same as the setting for that column above this ...
|
| deleting takes too long | 08 Apr 2007 17:00 GMT | 1 |
When I delete a line or lines in a spreadsheet, it takes much too long to complete and I am stuck waiting for the computer for 20 to 30 seconds at a time. How can I speed up the process?
|
| assign button for color | 08 Apr 2007 16:04 GMT | 9 |
I have assigned a button with a macro for the color yellow....... Please review the code. Sub allow_highlight() '
|
| How can I create a Drop-down cell? | 08 Apr 2007 08:04 GMT | 7 |
I am creating an Excel worksheet for my hotel that updates the status of Microwaves and Refridgerators in the rooms. We only have enough for 50% of the hotel so they move around often. We currently scribble on a piece of paper which rooms do/do not have micro/fridges. This is ...
|
| Identify last row of populated data | 08 Apr 2007 08:03 GMT | 2 |
Have 12 rows of linked cells, one for each month of the year. End of the month, data for March, for example is updated through a link to another
|
| find replace | 08 Apr 2007 04:50 GMT | 11 |
Sheet 1 contains following data find Replace with krw usd jpy usd
|
| Price List and Quote Form | 08 Apr 2007 02:10 GMT | 2 |
I have a workbook with two tabs, one tab is my spreadsheet with item #'s, prices, etc and the second spreadsheet is a quote form. What I want to do is when I put in a quantity on my price list form and it calcualtes total price, I want it to transfer that information to my quote ...
|
| date series in PivotTables | 08 Apr 2007 01:43 GMT | 4 |
I often use PivotTables to count events that occur on specific dates. The PivotTable only shows those dates that have at least one event associated with them; however, I am also interested in seeing which dates had no events. Is there a way to force the pivot table to show the ...
|
| Updating Data in Validation Lists | 08 Apr 2007 00:22 GMT | 7 |
Is there a way to automatically update data in a validation list when the data changes in the sourced cells? for instance if A1 is the validation list that display data sourced from A2, if data in A2 changes, I would A1 to display the new data. Currently, it does not, and only ...
|
| Time Countif help or convert to text | 07 Apr 2007 22:19 GMT | 3 |
I am trying to count how many times 00:01 are in a column. My formula is =COUNTIF(G1:H679,"00:01") but I get 0 instead of whatever the actual count is. Is there a way to convert the time to text? For now I have put in a new
|
| Present value and future value | 07 Apr 2007 21:30 GMT | 6 |
I can't figure out the formula to get this calculator to work http://www.smartmoney.com/retirement/now/index.cfm?story=moneylast I've tried combining the payment and PV functions and I can get it to work if return is 0% with some inflation rate, but I can't figure out hot to
|