| Thread | Last Post | Replies |
|
| How to sort without automatic renumber of rows? | 05 Nov 2006 20:54 GMT | 4 |
I need to sort my spreadsheet in a particular way for a certain task, but when I do, it renumbers the rows entirely! I want to be able to sort without excel automatically renumbering the rows. How do I do this?
|
| Create Funtion | 05 Nov 2006 20:42 GMT | 3 |
Using this formula how can I create function "pastevalue" This formula would be in cell B5 =IF(ENTRY!$B$1=2,pastevalue(ENTRY!$C$2)-B4,0) ENTRY!$B$1 is the week of the year
|
| UK Redundancy | 05 Nov 2006 20:23 GMT | 4 |
I have the unpleasant task of calculating redundancies for employees and since the rules have changed to the UK statutory calculations and I'm in need of a new spreadsheet. I have searched the web for such a file in Excel but come up blank - does anyone know where I might be ...
|
| Need organize numbered order | 05 Nov 2006 20:10 GMT | 1 |
I need to highlight & organize in numbered order for the shock my store handles,Can someone help me please
|
| A couple of questions | 05 Nov 2006 19:01 GMT | 5 |
Time Calculation What calculation do I use to find how many hours have past between say ? Cell A1: Friday 20:00PM to Cell B1: Monday 06:00AM for instance Also
|
| poker sheet | 05 Nov 2006 18:03 GMT | 4 |
I have alll my dates in column A and the winnings/losses for individual sessions in column K and would like to know my winnings for each month. So for example dates between 1/09/06 and 30/09/06 would add up or subtract any totals played on that day in column K.
|
| Cells are Merged. How to know where to where??? | 05 Nov 2006 17:17 GMT | 2 |
i have a merged cells say (a1 to b5). Now i am trying to know, 1) whether the cell is merged or not 2) if merged, where to where, from which cell to which cell Your help will highly be appreciated.
|
| Numbers are changed in Excel? | 05 Nov 2006 13:22 GMT | 3 |
I created a spread sheet of some stuff. I entered some serial and account numbers. For some reason that everyone but me probably knows the numbers are changed by Excel by inserting a ., a + sign, etc. hat are not as I typed.
|
| Workdays | 05 Nov 2006 11:06 GMT | 1 |
I am looking for a way to add workdays to a start date. As a result I would like to have an end date. Thanks in advance Bikash
|
| Sorting a Pivot Table | 05 Nov 2006 04:04 GMT | 1 |
Is there a way to sort a pivot table based on the total column?
|
| Summing with Spaces | 05 Nov 2006 03:32 GMT | 2 |
If I have a column of numers like this: 3 4 4
|
| Macro help | 05 Nov 2006 02:02 GMT | 1 |
Hi I am trying to create a macro that converts data on a worksheet. All o that goes well but it says to use print preview to view results centere horizontally on the page and a header and footer and that closes th
|
| Formula to convert Fahrenheit temperatures to Celsius | 05 Nov 2006 00:57 GMT | 5 |
Hi I need a formula that says to enter the following formula in cell C and copy down the column:=5/9*(C2-32) When I put this in it doesn't work. Please help. Thank-Yo
|
| Missing fields when I import from Access to Excel... | 04 Nov 2006 23:38 GMT | 2 |
Hi!, I have an auto update import on a access table, it works mostly ok, it update all user entered fields ok, but the fields that come up automatically when you make a selection somewhere else on the form don't. For example, when I select member # from a drop down, the First
|
| how I can sum or subtract 2 or 3 field in access in any record | 04 Nov 2006 23:27 GMT | 1 |
I want know that why there is NOT any relationship between access and excel and how I can sum and subtract 2 or 3 filds in access in any record thanks hadi_khodaparast@yahoo.com
|