Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Hasit
  • Content: Threads
  • Order by date
  1. Hasit

    How do I convert a "General" format date string into a date?

    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...
  2. Hasit

    How do I remove the page number on the first page of a document?

    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...
  3. Hasit

    Excel: Multi lookup and match to criteria

    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...
  4. Hasit

    Excel: Hiding Worksheets in an Excel File

    I have around 7 worksheets in a single Excel file. Is there a way to hide 6 of the 7 worksheets and only have 1 worksheet visible? Thanks!
  5. Hasit

    Conditional Formatting Question.

    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...
  6. Hasit

    Excel question on rolling months

    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...
  7. Hasit

    FTPing using IE with "Enable Folder View for FTP Sites" unchecked

    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...
  8. Hasit

    Enable Folder view of FTP Sites - option missing.

    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...
  9. Hasit

    XP will not complete file copy - results in an error.

    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...
  10. Hasit

    Media player will not play.

    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...
  11. Hasit

    Transferring data between applications based on certain criteria

    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...
  12. Hasit

    Second question - see this thread f

    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...
  13. Hasit

    How to count based on several checks.

    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...
  14. Hasit

    Access extracts into Excel - is there a way to automatically update?

    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...
  15. Hasit

    Broken Queries in Excel.

    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&quot...
  16. Hasit

    Can I pass a string in a cell to construct a filename ....

    ...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...
  17. Hasit

    Working out the number of same numbers in a range.

    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...
  18. Hasit

    Does anyone know of a (free) corrupted Excel file recovery tool

    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...
  19. Hasit

    Blocking together a range of dates after performing a test on them.

    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...
  20. Hasit

    Advice on free survey/questionnaire software pls.

    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!

Part and Inventory Search

Back
Top