| Thread | Last Post | Replies |
|
| Functions expert………numbering ran dom condition in a column | 20 Jun 2007 23:29 GMT | 14 |
I need to number random conditions as they occur in a column. The example show is in its simplest form. Column A is a list of colors that are selected randomly. Column B needs to be the order in which the color was selected relative to equivalent colors.
|
| Looking to add color code alert | 20 Jun 2007 23:29 GMT | 3 |
I have a spreadsheet that has a list of 200 customers, I would like to use the end date of the customers renewal section then subtract it from the current date and if that is less than 130 days I want the cell that has the customers name in it to turn yellow. Can this be done ...
|
| rows 4-15 will not scroll | 20 Jun 2007 23:01 GMT | 1 |
I have a spread sheet that I'm working on and rows 4 -15 will not scroll with the rest of the data in the spreadsheet. I haven't been able to fix this. Thank you for your help.
|
| Copying rows from one sheet to another.... | 20 Jun 2007 22:56 GMT | 1 |
I have a large spreadsheet that I update weekly. Columns a:x and rows going on forever. I need a way of copying rows that match the criteria to a new sheet. i.e if A=dave i need all the information from a:x to go to a sheet called
|
| More specific question about adding color code | 20 Jun 2007 22:20 GMT | 3 |
I am trying to do the following without success 1A = company name 1B = renewal date ex 07/19/2007 1Z (hidden) Has current date which updates to current date each time excel
|
| return TRUE if a date falls between two dates | 20 Jun 2007 22:19 GMT | 8 |
I am looking for an "IF" statement to send back "T" or "F" (true/false), if the date entered falls between two dates from a list, for all 5 rows... The date entered, lets say in A5, of the "Sched" worksheet. On the "Dates" worksheet, Column A are starting dates, Column B are end
|
| Pivot Table Date Format Question | 20 Jun 2007 22:19 GMT | 6 |
The formating of date in the spreadsheet is mmm yyyy and it does display the way I intend at this point, but not the pivot table. When I run a report in the pivot table a date that is supposed to show up as May 2007, shows up as 5/07/07. I even changed the format in the pivot ...
|
| Calculate the difference between two times - getting '#VALUE!' err | 20 Jun 2007 22:18 GMT | 2 |
I tried to use help, it gave me the same formula I was using, but when I try to implement, I get the '#VALUE!' error. Column A: 6/1/2007 9:30:51AM
|
| password problem | 20 Jun 2007 22:18 GMT | 3 |
I started a spreadsheet for a friend a couple of months back and as she is always messing it up I password protected it and now cant get the password correct to update it. It wont be a difficult one as for something like that (not important) I usually use something simple like ...
|
| "manual page breaks error" | 20 Jun 2007 22:18 GMT | 5 |
I am getting an error message when I try to open my excell file saying "this action exceeds the number of page breaks you can manually add to a worksheet. A worksheet can contain up to 1026 horizontal page breaks. This is a file that was developed in 2004 and has been set to ...
|
| Comparing multiple column values | 20 Jun 2007 22:18 GMT | 7 |
I have a grid where the column data is as follows A B C D E Exclude; Status; Property Address; Enter Date; Price I want formulas to calculate the following
|
| linking to other workbooks | 20 Jun 2007 21:53 GMT | 1 |
I am linking cells from one worksheet to another. When there is nothing entered yet in the worksheet that I want the into to carry over from, it is inserting a 0 in the cell (but shows my formula in the top fx box). Do you know how to get rid of that 0 so the cell is completely ...
|
| Movng Data Automatically the Fits a provision | 20 Jun 2007 21:40 GMT | 3 |
Sub versive() Dim myRange As Range Set myRange = Range("D2:D25") For Each "c" c.Select
|
| How do I add " to the right of a number when formatting? | 20 Jun 2007 21:05 GMT | 4 |
I am trying to format a column of numbers example. 0.152 0.025 I have figured out how to remove the first zero now I need to add a single
|
| formula help | 20 Jun 2007 21:04 GMT | 3 |
Hi I am having an issue with the formula below. It is returning a NA value for the cells = to 302 & 366. If it is any other value the formula is functioning fine. Any ideas as to why my formula is not working!! I have try the vlookups on there own & they work fine.
|