Yes - its the old "Date" management problem. I used to be quite good at excel, but this one has me stumped. The situation is this:
Some data has been imported and the date column has come in as a string in "General" format. The string is:
4/19/07 8:14:14 PM
I don't need the time, so I used...
OK, sounds simple, and it probably is, but there is a small twist.
The entire document is in landscape. The first (title) page has a title that is centred horizontally and vertically on the page. The subsequent pages have 2 columns on each page.
This means that there has to be a page break...
This is a complex(ish) issue. I have got part of the way there, but am stuck. I have 2 columns Group and Dept, each containing various different entries.
I need to "AND" these two values together and match them to some criteria. For example 'GroupA "AND" DeptX'. If these entries exist (i.e...
I am sure that there is a relatively straight forward answer to this, but I can't seem to get it.
The situation
Start End Jan Feb Mar Apr May Jun Jul......Dec
1 5 O O O O O
3 4 O O
I need a formula that will take the start and end numbers...
I have an Excel spreadsheet which calculates resource requirements for projects that my team runs. The resource requirements are based on pretty good estimates of productivity, so I am able to create the spreadsheet for 12 months relatively easily.
Heres the question:
I would like a rolling 3...
Under IE 5.00.2919.6307CO, if I choose the "Enable Folder View for FTP Sites", HELP states you will not be able to create folders. If you do not then all functions (including creating folders, copying and deleting files etc) are available to you.
I have unchecked this option and I get...
I am using IE 5.00.2919.6397CO. If I go to
TOOLS>INTERNET OPTIONS and then select the ADVANCED tab, I have an option for "Enable Folder view of FTP Sites".
I have a colleague who uses EXACTLY the same version, but the "Enable Folder view of FTP Sites" option does not appear...
This questions is related to this thread: thread779-297389
I have a file on a CD which is around 620MB (its a movie file). I wanted to copy it to hard disk, and so I used the following methods:
1. Using Explorer, I dragged the file from CD to a folder on my hard disk;
2. I used the menus in...
I am running XP Home version and have tried to run a .dat file using the standard XP media player (the icon is the circular coloured icon). When I do that I get an error (unrecognised format).
I then used the older media player (mplayer2.exe - icon is the clapper board) and I get a similar...
I think the VBA guys will be pretty happy with this one:
I have an Excel spreadsheet which has a load of data, starting with a single line address and then subsequent columns have a number in them. Theres 8 numbers (one for each day of the week plus a total). There are around 30 addresses in...
Second question - see this thread for related info: thread68-184936
Heres (another) one I have been wrestling with for a few hours. I am using Excel 2000.
I have 4 columns and 4 columns, in (unnamed) tables. They are:
TABLE 1
Column A: Unique (building) key
Column B: Square footage per...
Heres one I have been wrestling with for a few hours. I am using Excel 2000.
I have 4 columns. They are:
Column A: Unique (building) key
Column B: Square footage per building
Column C: A value of either "bid", "contract" or "core"
Column D: A value of either...
I have extracted a load of data from tables within an Access database using ODBC through Excel. I have extracted probably 245 columns by about 400 rows worth of data. this total is made up from several individual extracts.
The data in the Access database continually updates.
The only way I can...
This is (I think) a simple question. I have extracted a bunch of data from an Access database using the "Get External Data" function.
If I want to refresh the data, the query that has been created (through MS Query) to extract the data is run when I click on "Refresh Data"...
...if the cell is selected?
What I mean is that I have in column A a different set of names. In column B, you can put an X in the corresponding cell. What I want to do is pass the name in column A, against which there is an X, to a file name, so that certain cells within that file are...
I need to produce a chart. I have a column of numbers (ranging from 1 - 35, with multiple instances of each).
I am trying to construct a formula with explicit ranges (i.e. 1 - 10, 11 - 20, 21 - 35), to find out how many numbers fall in those ranges.
I have used nested IF functions, COUNT and...
I have checked the net and there are a couple of good ones that I found, but they all cost money. Whilst I am not averse to paying the couple of hundred bucks for the tool(s), they are all license based, so buying say 15 or 20 then becomes difficult.
I wondered if there is anything out there...
I think I am being stupid. I have a range of "lease start" and "lease end" dates in 2 columns (about 250 in each column).
I would like to produce a trend graph of lease dates (showing that lease times have reduced hence financial management is improving). The leases range...
This is a question for Peaslet: What free survey software do you know of?? I need to carry out a questionnaire once only and therefore do not want to spend any money. I am happy to create the questionnaire in Excel, but would prefer to use a package that does some analysis too.
Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.