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 strongm 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: *

  1. pro356

    csv file too big for excel

    We have a file in csv format with about 1200 columns and over 2 million rows. It is 3.8 gb and too large to open in Excel. We need to be able to filter on several columns at once to conduct specific searches and are stymied trying to find something that will work. Any suggestions?
  2. pro356

    Excel- Sum only the values in column 3 which meet the exact criteria of colum 1

    That was very helpful. I did misunderstand that. Still think I am missing something. In step 4 there is a question "How many page fields do you want?" which defaults to "0" and I didn't change that. There are options to choose the item labels but when leaving page fields as zero there is no...
  3. pro356

    Excel- Sum only the values in column 3 which meet the exact criteria of colum 1

    To Skip, I entered everything exactly as you had it in your file to Normalize, etc. but it didn't sum they way yours did. I can't see where ZI am making any mistake but who knows. I am at a loss to explain it.
  4. pro356

    Excel- Sum only the values in column 3 which meet the exact criteria of colum 1

    I have replicated what you did but it is still not working for me. I can't post my actual file publicly as it is private company financial information. Is there a way to circumvent this?
  5. pro356

    Excel- Sum only the values in column 3 which meet the exact criteria of colum 1

    Thanks. I didn't get very far trying to recreate this. I am using Excel 2016, and my option for a Pivot Table is thru Insert/Pivot Table but there is no option for "Multiple Consolidation Ranges". It only asks to Select a table or range, then choose where it is to be placed. I see no option to...
  6. pro356

    Excel- Sum only the values in column 3 which meet the exact criteria of colum 1

    See the attached file. The goal is sum the amounts in the Income tab in the cell in the Budget tab for each Income type. http://files.engineering.com/getfile.aspx?folder=545ea17e-15da-4548-a904-7664e029b0e5&file=Budget_2018_Worksheet_Tek_Tips_Help.xlsx
  7. pro356

    Excel- Sum only the values in column 3 which meet the exact criteria of colum 1

    I have a spreadsheet I am trying to build as template for a budget. In one tab I have listed all our customers and the budgeted amount of income per month. Included in that tab is a column showing the type of income for each client (which income account) by month, it could be one of 6 different...
  8. pro356

    Outlook missing text on replies

    This has gotten especially bad since we started using Google Apps and hosted our email on Google. Email replies from some companies do not get coded properly or something and do not show up in Outlook. The header shows receiving the email from the proper party but nothing shows in the text. If I...
  9. pro356

    Outlook stopped sending, still receives

    POP3. I use Google Apps For My Domain but have it set up per their instructions. It has worked fine in the past, just suddenly started this issue of not sending.
  10. pro356

    Outlook stopped sending, still receives

    I'm perplexed. Suddenly my Outlook 2003 won't send my email. I receive everything fine. When it attempts to send it just acts like nothing is in the Outbox, but there are currently 11 emails in my outbox.
  11. pro356

    Outlook error message- Recipients can't be reached

    Never did solve it and it still occurs for me on occassion also.
  12. pro356

    Can't format lap top HD

    I want to wipe my drive clean so I can reinstall windows and start over with a new (ie unclutered and faster) drive. If I just reinstall Windows it won't wipe anything off.
  13. pro356

    Can't format lap top HD

    So is there a way to format this hard drive again or am I stuck with it as is?
  14. pro356

    Can't format lap top HD

    I want to format my hard drive on my laptop. I don't need most of the programs or files and have copied anything I need. I primarily use it only to surf the web or to connect to my pc at work using logmein.com. I open My Computer and click on the "C" drive, than go to File\Format. It keeps...
  15. pro356

    Outlook error message- Recipients can't be reached

    I would accept that if it wasn't also several others and if I didn't have this problem when sending from my Mac. I only included cebridge and Alltel in my question, but my email also had the same rejection from Netscape, Hotmail and SBCGlobal.
  16. pro356

    Outlook error message- Recipients can't be reached

    Using Outlook 2003. For some reason I frequently get the following error message when I attempt to reply to an email. Your message did not reach some or all of the intended recipients. The following recipient(s) could not be reached: 'abc@cebridge.net' on 6/30/2006 7:59 AM...
  17. pro356

    Oops. I deleted a Distribution Group. Can I get it back?

    Thanks for the info...but where do I find this folder? What is the path?
  18. pro356

    Oops. I deleted a Distribution Group. Can I get it back?

    Using Outlook 2003. I accidentally deleted an entire Distribution Group when I meant only to remove one member. Clicked in the wrong place. I don't see the deleted group in my Recycle Bin. I had several hundred members and recreating it will be a major pain. Am I stuck or is there a way to find it?
  19. pro356

    Contacts always opens to Accounts

    Sorry, but I see the Tools on my menu but no Services or Adressing. You are talking in Outlook? Where?
  20. pro356

    Contacts always opens to Accounts

    Using Outlook 2003 with Business Contacts Manager. Whenever I compose a new email and click"To" to select a name, it automatically opens to "Accounts" list on the drop down instead of to Contacts, which is where I have most of the contacts. Is there a way to make the default open to Contacts...

Part and Inventory Search

Back
Top