| Thread | Last Post | Replies |
|
| Counting number of cells that contain certain text but not cell tw | 11 Sep 2006 21:50 GMT | 1 |
How can I count cells that contain certain words without counting same cell twice. e.g. Column A
|
| How do i increase the height of the worksheet tab in Excel? | 11 Sep 2006 21:46 GMT | 6 |
I really would like to increase the height of the worksheet tab at the bottom of the screen. I have so many tabs and hate scrolling. Would rather have the width of that bar be 2 or 3 rows in height. Is there a way to do this. I thought for sure i had seen this done before, ...
|
| can excel calculate time increments in a formula? | 11 Sep 2006 21:39 GMT | 2 |
I want to have a formula in my time sheets that calculate the incriments of time. For instance: If the time on a project site is: Start Time End Time Project Hours
|
| how to automatically number rows in an excel worksheet | 11 Sep 2006 21:32 GMT | 5 |
I am trying to automatically number rows in a worksheet. I have used the =ROW(A1) function and that works alright, BUT it doesn't re-adjust automatically after a row has been deleted or inserted. I also tried selecting the range and creating it as a LIST, which works when we ...
|
| IF statement | 11 Sep 2006 21:24 GMT | 3 |
Can anyone help me, please? Need an IF statement that would go like this: If L8-M8=0,"",if E8 has TBG or PL in it, then calculate the difference between L8 and M8 only when it exceeds 7 days Thanks a bunch
|
| how to get the column number from the corresponding column name denoting initial..??? | 11 Sep 2006 21:17 GMT | 5 |
i want to recieve the column number ( ranging from 1 to 256 ) while the input will be the column name (ranging from A to IV ). please provide me a macro solution to reach the above mentioned requirement. Thanks and Regards
|
| Concatenate Doesn't Work for this | 11 Sep 2006 20:23 GMT | 3 |
On a labor time spreadsheet, The date is in one cell and the time is shown in successive cells for each record. I need to be able to merge the date (5/11/2006) and the time (11:00 am) in order to get (5/11/2006 11:00 am).
|
| Adding/Analyzing Data From One Worksheet to Another | 11 Sep 2006 20:22 GMT | 1 |
I am making a report to track the sales steps and processes for a car lot. The log has been set up with all of the different columns that I need. I would like for the second page of the workbook to analyze/add the data and statistics that will be entered into the log. My ...
|
| disk storage number format in excel? | 11 Sep 2006 20:21 GMT | 1 |
I am creating a sheet in excel to track disk usage, does anyone know of a way to format the numbers in the cell to appear as common disk space nomenclature? I would like to see something like 54GB, 54k, 125mb..
|
| Fill in if.. | 11 Sep 2006 20:12 GMT | 3 |
I HAVE TWO SHEETS ONE FOR MASTER INFO AND ONE FOR MONTHLY ORDERS I NEED TO HAVE THE MONTHLY ORDERS SHEET TO GRAB INFOR FROM MASTER SHEET IF IT MATCHES.
|
| How do I assign a numerical value to a textual entry to calculate percent completion? | 11 Sep 2006 19:58 GMT | 2 |
Hi guys, I have a spreadsheet that looks as follows Packslip | Text | Photo | SEO | % Complete 440158 | 1 | 0 | 1 | 66% 440159 | 0 | 1 | 0 | 33%
|
| Networkdays plus Sundays | 11 Sep 2006 19:53 GMT | 4 |
I need to calculate the number of work days between two dates that includes Sundays as a workday. So only Saturday would be excluded. Is there a way to count the number of Sundays between two dates? I could then just add that to the result of the NetWorkDays function.
|
| Why would a pivot table lose its character? | 11 Sep 2006 19:19 GMT | 1 |
I have been using a Pivot table to accumulate data. I opened the file and input my data. I went to my Pivot summary and it wouldn't allow me to "refresh my data". In other words, the PT command to refresh my data was "greyed out".
|
| Troubleshoot horizontal scrollbar | 11 Sep 2006 18:27 GMT | 1 |
Why do my arrows disappear on my horizontal scrollbar when I'm working in a worksheet? And, how do I get them back w/o closing the document and reopening it? Thx! Diane
|
| tricky search and replace | 11 Sep 2006 16:41 GMT | 6 |
I need to search for a particular string in a very large spreadsheet, and when I find it I need to replace it with the contents of, or a reference to, the cell 3 to the right and 2 above it. For example... Let's say the string is 'XXXX'. Lets say the 1st instance of
|