Microsoft Excel

  • Microsoft Excel

  • Sorting by street address
  • Sat, 30 Dec 1899 00:00:00 GMT
  • can anyone tell me how to sort a column by street name when the street name is precided by the street number?
  • Data Manipulation
  • Sat, 30 Dec 1899 00:00:00 GMT
  • Would like if the below result can be achievable and what method..Sample data:2003 sanny sony2002 sanny sony2002 sinsing pansonic2002 dee tee2003 dee tee2004 dee tee2005 ada hoa1995 kii kiwiDesired Result2003 sanny sony2003-20022002 sanny sony2002 sinsing pansonic 20022002 dee tee2004-20022003 d
  • Removing Macro Virus Warnings Upon File Open
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I've got a file where upon opening it, it always gives the option to enable or disable the macro. It has a macro I created that is safe, so I want to remove this option. I've tried to: 1) Change the macro security (It's on Medium) The file won't save when I select anything el
  • Multiple cells in to one cell x times
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I have a list of keywords with names:Something oneSomething twoSomething2 oneSomething2 twoSomething2 threeI need to put keywords to one cell but for every group i need newcell.I have something like this:Sub CosTam()IleSlow = Worksheets("to").Range("G1").ValuePierwsza = 1Druga = 0Sheets("to").Se
  • Excel file won't open, read only not checked.
  • Sat, 30 Dec 1899 00:00:00 GMT
  • Student saved Excel worksheet to floppy. Error message stating that it cannot be accessed. "Read only" not checked. Help!
  • Crystal report loading problem
  • Sat, 30 Dec 1899 00:00:00 GMT
  • Every time ..I try to run crystal report..it ask for server name and password and database name etc...but i have given initialy all information at the time of report design...please help me... Is there any free e-books for crystal report in .net please give me the URL thanks every body
  • form.show switches to debug mode
  • Sat, 30 Dec 1899 00:00:00 GMT
  • Hi all, I'm hoping you might be able to help me. I have a button on a worksheet then runs a small macro with the text usrSlctEng.show where usrSlctEng is a user form. When I click on the button I am taken into the VB editor and the line usrSlctEng.show is highlighted in yellow. When I click
  • Combine an OR condition with an & condition
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I need to incorporate both an "AND" and an "OR" condition within and IF statement... is that possible. I need to say... IF the cell above is "ON" or IF the Cell above is "OFF" and the record is the last of the day, then... I hope you can understand that...
  • matrix size
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I have a 2 dimenisonal matrix. I want to find the size of the different dimensions. I know how find one dimension by using the Ubound. This gives me x=3. However I would like to know the other dimension also, ie 5. Can yuo please help me? Thank you very much! Option Base 1 Dim strRatingMatrix()
  • Formula with 2 unknowns
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I have the following formula: 100=(D9+D10)-(0.15*D9)-(0.05*D10) Cells D9 and D10 are unknown. Is there a way to find out what they ca be to make the equation true -- Message posted from http://www.ExcelForum.com
  • Audible alert for cell condition...
  • Sat, 30 Dec 1899 00:00:00 GMT
  • Has anyone created or know of a bit of code that would audibly alert me to a cell condition having been met, say for example if a cell's value is greater than or less than a value? I suppose since I could be away from my desk briefly, it would be best if it repeated the sound until I could
  • how to allow macro to write on a protected sheet
  • Sat, 30 Dec 1899 00:00:00 GMT
  • without using unprotect/protect way.. is there a way to allow program to write in certain ranges while users can't write. Thanks for all the help you provided. MVM
  • Conditional formattig
  • Sat, 30 Dec 1899 00:00:00 GMT
  • Hi to everyone in the N.G., I was looking for a way to highlight the cells of a column if they meet a criteria in column 'B'. In other word I have to see highlighted each cells in column A that meet the lowest value of column B. How can I do? Many thanks to everyone will help me! Stefa
  • I need to create a data input screen on excel wher...
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I need to create a data input screen on excel where multiple usersat the same time will use them & input data.This data then needs to be stored as a database as well, where i canuse it to understand trendsThank you.
  • revised: help with calculating 3 part function in excel
  • Sat, 30 Dec 1899 00:00:00 GMT
  • i forgot a few things to add: i need help trying to make a function to calculate a few things. here is the problem: need to calculate 3 functions from 1.5million apples. first: need to multiply 0.00001 fot the first 300,000 apples over 500,000 apples. second: need to multiply 0.00002 for the nex
  • Can you use a vlookup to bring in a picture?
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I have a form template where in the first column I choose an option from a drop down box. Each of these options has a picture. Is it possible to use eg a vlookup function to bring in the correct picture based on what I choose in the drop down box, or would I have to copy and paste these in manua
  • ASAP Utilities
  • Sat, 30 Dec 1899 00:00:00 GMT
  • How do I get the latest version of ASAS utilities downloded please also supply ip address
  • How can I lookup cells that match a specific value & return all.
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I have a table that contains several pieces of information on each row. Twocolumns of this table include a date and a part number. In a column on aseparate sheet I need to be able to search through this table and return acolumn of part numbers that all have a specific date. This is basically afi
  • Ampersand in front of font name
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I have a ampersand ".excel.itags.org." in front of the font name in with Office 2000 with SP-2. Only the font "arial unicode MS, Batang, MS mincho and simsun". What is the meaning of the ampersand' Thank you
  • Map Add-On?
  • Sat, 30 Dec 1899 00:00:00 GMT
  • I am looking for an Excel Chart add on so that I can take numerical data and display it on a geographic map of states or zip codes for example. Even better I could color or shade a state based on the values in my spreadsheet. Any suggestions would be appreciated. Mark
  • Blogs
  • Open Questions
  • Multiple cells in to one cell x times
  • I have a list of keywords with names:Something oneSomething twoSomething2 oneSomething2 twoSomething2 threeI need to put keywords to one cell but for every group i need newcell.I have something like this:Sub CosTam()IleSlow = Worksheets("to").Range("G1").ValuePierwsza = 1Druga = 0Sheets("to").Se
  • Sorting by street address
  • can anyone tell me how to sort a column by street name when the street name is precided by the street number?
  • Conditional formattig
  • Hi to everyone in the N.G., I was looking for a way to highlight the cells of a column if they meet a criteria in column 'B'. In other word I have to see highlighted each cells in column A that meet the lowest value of column B. How can I do? Many thanks to everyone will help me! Stefa
  • Run-time error 1004 with sort
  • Hi, The code below works fine on my computer which has Excel 2003 but is coming up with a Run-Time error 1004 on my client's computer which has Excel 2000. The actual line being highlighted by Debug is surrounded by << >> below. Any help is appreciated! Also, is it possible to h
  • Concatenate a selected Range?
  • Hi All......... With a UDF or a macro, would it be possible to CONCATENATE all the cells in a selected Range, say A1:a7 without having to type each cell address.......something like =SpecialCONCATENATE(A1:A7), or =SpecialCONCATENATE(MyRange), of course those don't work, but that's the
  • How can I lookup cells that match a specific value & return all.
  • I have a table that contains several pieces of information on each row. Twocolumns of this table include a date and a part number. In a column on aseparate sheet I need to be able to search through this table and return acolumn of part numbers that all have a specific date. This is basically afi
  • form.show switches to debug mode
  • Hi all, I'm hoping you might be able to help me. I have a button on a worksheet then runs a small macro with the text usrSlctEng.show where usrSlctEng is a user form. When I click on the button I am taken into the VB editor and the line usrSlctEng.show is highlighted in yellow. When I click
  • Excel to My Favorites
  • I have rebuilt a machine and failed to backup My Favorites. I had previously used a utility (sorry, forgot what it was) to export all my Favs, all 1334, to a spreadsheet. The Excel spreadsheet has 3 columns, a title, a URL and the parent directory. These were straight out of the My Favorites fol
  • ASAP Utilities
  • How do I get the latest version of ASAS utilities downloded please also supply ip address
  • matrix size
  • I have a 2 dimenisonal matrix. I want to find the size of the different dimensions. I know how find one dimension by using the Ubound. This gives me x=3. However I would like to know the other dimension also, ie 5. Can yuo please help me? Thank you very much! Option Base 1 Dim strRatingMatrix()