Sorting/Function Help

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Embed Map I have loads of data in excel of which I would like to plot on a map. I have MapPoint and it is possible to embed a Map using the mapping icon which appears after downloading the MapPoint SDK. The problem I have is it will only embed a european map, i can't get it to open a custom map of the UK which is split into territories. Also, it automatically imports the data but only asks a small amount of information before plotting and doesn't plot the pushpins as I would like. I can't choose my pushpin colours and shapes as I would if I was to import the data from an open MapPoint application. Does anyone know how to change the settings for this embedded map? Its a lot easier than opening mappoint and importing the data each time I renew the SS. Please Help! Ron Tag: Sorting/Function Help Tag: 100050
  - 2
    - removing filters If i use one filter on my spreadsheet and then use the data - filter - show all feature it works ok but when i have used more than 1 filter and try to show all after finishing using the filters Excel freezes on me - i am using Excel 2000. Thanks Tag: Sorting/Function Help Tag: 100048
  - 3
    - Formula to reduce balance monthly Hello I have a figure in E30 which I would like to reduce by a set amount each month, is it possible to write a formula to do this? Thank you Tag: Sorting/Function Help Tag: 100040
  - 4
    - Excel security update causes system to label Excel files as damage After the recent installation of the KB918419 Security Update for Excel update on our network, problems occurred with a number of reports that we run regularly. These reports are coded in Perl and generate formatted Excel spreadsheets from a database. On opening the spreadsheets Excel claims the file is "damaged" and must be repaired. Repair seems to involve the removal of all formatting. Removal of the security update from our system caused the problem to stop, but this is a temporary solution. Removal of the code from the reports that sets the column size also solves the problem, but does not do much for the appearance of the spreadsheet. I am somewhat puzzled as to why a security update should have problems with the formatting of columns. Has anyone else encountered this problem? Tag: Sorting/Function Help Tag: 100030
  - 5
    - Comparing Column B to Column A Ok... say I have like 1,000 records on column A and column B ..is there a way to write a formula say... going down column B and compare to column A and tell me which number or char. is not in colum A but is in column B ..or vice versa .. ie A B C 12 12 13 14 13 14 15 15 18 18 16 16 17 17 I tried write an if statement .. if true =1 false = 0 ...but that doesn't work.. :( -- TaGY2K ------------------------------------------------------------------------ TaGY2K's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1861 View this thread: http://www.excelforum.com/showthread.php?threadid=564993 Tag: Sorting/Function Help Tag: 100028
  - 6
    - Adding Streaming video to your web-page is as Adding Streaming video to your web-page is as simple as a few clicks of the mouse with this amazing tool. http://www.ebvalues.com Tag: Sorting/Function Help Tag: 100025
  - 7
    - Excel Problem It's for a Nested Function. Enter this function in cell B1 and then use the fill in handle to copy the function down through cell B7. Enter the following data in the cells in the range A1:A7 and then write down the results in cells B1 through B7 for each set. Set 1: A1=IL; A2=IN; A3=IN; A4=OH; A5=IN; A6=OH; A7=IN Set 2: A1=WI; A2=KY; A3=IN; A4=IL; A5=IN; A6=IN; A7=OH not sure how nested functions work, if someone could tell me how to do this one i should be ok to figure it out from here. thanks -- Angell ------------------------------------------------------------------------ Angell's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36782 View this thread: http://www.excelforum.com/showthread.php?threadid=564952 Tag: Sorting/Function Help Tag: 100015
  - 8
    - Counting Cells with odd and/or even values Lets say I have range A1:A5 containing values 1,2,3,4,5 respectively. I would like to count how many of these cells are odd and place that value in A6. The same for even numbers as well (in A7). Any help would be appreciated. -- yungexec ------------------------------------------------------------------------ yungexec's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22593 View this thread: http://www.excelforum.com/showthread.php?threadid=564950 Tag: Sorting/Function Help Tag: 100014
  - 9
    - Ardus Petus: Ran in to a problem with the formula Please Help =VLOOKUP(TEXT(F5,0),Jobs!A:B,2,0) The formula you gave me above worked great until I added a few more rows of data to the Jobs worksheet. Any entry that was added past the original entrys will not lookup. Did I loose the formula referance? should I rename the worksheet? What do I need to do to get this to work again? It works down to row 50 but after that nothing is returned I check to make sure all cells were formated the same and I also tried sorting the list ascending didn't help. I will need it to search at least 100 rows Thanks Charles -- mrdata ------------------------------------------------------------------------ mrdata's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17899 View this thread: http://www.excelforum.com/showthread.php?threadid=564937 Tag: Sorting/Function Help Tag: 100011
  - 10
    - Filtering one column based on multiple arguements I want to filter my spread sheet with a macro based on the information in one column, the catch is that I'd like to hide anything that is one of 5 different entries. From my initial testing I concluded that Excel might not support more than 2 arguements per column in a filter. This is a problem as I have thousands of entries with about 15 different codes, but 5 of the codes are different ways of saying that something didn't happen (each for a different reason which is important, otherwise I could just use find/replace to code them all the same) I want to view only the rows containing entries that did happen using a filter, but the only way I have to do this is to write a macro that checks each entry in the column to determine if it was one of these codes and then hides them, stepping through a loop as it goes. Here is what I've written for that piece: Sub Operational() Dim ColOTP As Integer ColOTP = 7 For i = 2 To Worksheets("Data").UsedRange.Rows.Count With Worksheets("Data").Cells(i, ColOTP) If .Value = "Cancelled" Or _ .Value = "Weather" Or _ .Value = "Mechanical" Or _ .Value = "None" Or _ .Value = "Not Initialized" Then Worksheets("Data").Rows(i).EntireRow.Hidden = True End If End With Next i End Sub While this is functional as itself, it is not functional if I apply this and then try to filter based on a quality of something in a different column, doing so unhides all the entries that were hidden via the above macro that meet the quality of the filter. Tag: Sorting/Function Help Tag: 100010
  - 11
    - How to change the color of default letters in the labels? My friend asked me how to change the color of the default letters, such as the color of the labels (sheet 1, sheet 2) at the bottom of spreadsheet? The default is black. He wants to change it to any other color. Thanks. Tag: Sorting/Function Help Tag: 100005
  - 12
    - pdf file conversion probs in 2007beta When i convert an excel page into a pdf i get corrupted scripts etc ie italic changes completely. Does anyone else have the same problem? Is it because it is a beta version? Is there a cure? When using excel 2003 i have no problems. Ta Tag: Sorting/Function Help Tag: 100002
  - 13
    - Excel Not Seeing User-Defined Functions Does anyone know why Excel sometimes does not see user-defined functions, and instead fills the cell with "#NAME?"? (I have run across this problem before, but I do not remember what smack-in-the-head Excel requires.) Tag: Sorting/Function Help Tag: 100000
  - 14
    - excel file will not open Someone gave my a floppy disk with an excel file on it and it will not open. He told me that the computer that he was working on it froze-up and he rebooted the pc and known it won't open. Try repaired it through excel but had known success with it. Does anyone known of any repair program that will fix it thanks Bri Tag: Sorting/Function Help Tag: 99997
  - 15
    - columns and tabs in excel can I get the first two columns to be the same regardless of which tabs I click on? E.g. the first two tabs are for what will remain constant. Clicking on the tabs at the bottom will change what columns appear to the right of the first two columns. Tx Tag: Sorting/Function Help Tag: 99995
  - 16
    - find matches in a column I am using excel to add users to AD, I need to have a function that will look through my username column and find matches and highlight them, can anyone advise? Regards Mark Tag: Sorting/Function Help Tag: 99990
  - 17
    - Basic Excel help for beinnger Is there anyway to automatically update a spreadsheet when my client updates a different spreadsheet (within the same workbook) and on the same network. I need to have a COUNT function to add up the total number of comments. But these comments are long strings and the count function doesnt work. Anyone have any suggestions. I figure I could use a macro but I have no idea how to use them. So any guidance would be greatly appreciated. Thanks. Paul -- pscoln1 ------------------------------------------------------------------------ pscoln1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36702 View this thread: http://www.excelforum.com/showthread.php?threadid=564812 Tag: Sorting/Function Help Tag: 99985
  - 18
    - Create a pivot from CSV or access I have a CSV file and I wish to create a Pivot out of this.I am converting it in to access and then planning to create a pivot from access.I am converting it in to acces so that no of rows do not do not become a limitation in excel . Some body with any idea or VBA code to automate this? Tag: Sorting/Function Help Tag: 99982
  - 19
    - Numbers Organized As Data HI, When I download financial numbers from a database to an excel spreadsheet, the numbers are automatically organized like if they are data ex. 1.28000000 into 128.000.000. I would like to have them as numbers no data. What do I have to do in order the permanently fix the problem? Thank you. air -- campione ------------------------------------------------------------------------ campione's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36758 View this thread: http://www.excelforum.com/showthread.php?threadid=564773 Tag: Sorting/Function Help Tag: 99975
  - 20
    - Removing rows based on prescence in another sheet Hello, I have a large sheet using columns A-E and I need to remove certain rows from it. I need to remove any row where cells A and D of that row occur together in columns A and D of another sheet in the same row as each other. I hope that makes sense and someone can suggest a way that I can do this... -- ianwitt ------------------------------------------------------------------------ ianwitt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36697 View this thread: http://www.excelforum.com/showthread.php?threadid=564755 Tag: Sorting/Function Help Tag: 99971
  - 21
    - Inserting a Drop down Menu Very simple questions so I'll keep it short. How do I insert a drop down menu into Excel? Thanks for any help. -- matt_the_brum ------------------------------------------------------------------------ matt_the_brum's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5751 View this thread: http://www.excelforum.com/showthread.php?threadid=564747 Tag: Sorting/Function Help Tag: 99969
  - 22
    - formatting i am creating a spreadsheet with a lot of cell references for billing of insurance purposes. Basically, what i want to know is this: I have formatted cells to be referenced to another worksheet in the workbook, and right now, if there is no value for the date, it shows 1/0/1900, but if there is a date, then it shows the correct date. I want to know if there is a way to make an IF statement for formatting so that if there is a date it shows it, and if not, it shows a dash or 0 or nothing at all. please let me know:cool: -- pioneermusic55 ------------------------------------------------------------------------ pioneermusic55's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36756 View this thread: http://www.excelforum.com/showthread.php?threadid=564728 Tag: Sorting/Function Help Tag: 99962
  - 23
    - how to auto copy excel cells to outlook email hi, great site. not sure if this is the right place to post this: here's what i'm trying to do: i have to send daily emails to a list of people. the info on the email is in an excel doc (eg cells A1 to e5) i manually copy-paste the cells on my daily emails. (not as attachment just ctrl C crtl V) is there a way to automate this process? i.e. a form to get the info from the excel sheet and display it on th email template? hope someone can help, thanks -- asdfasd ----------------------------------------------------------------------- asdfasdf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3675 View this thread: http://www.excelforum.com/showthread.php?threadid=56470 Tag: Sorting/Function Help Tag: 99959
  - 24
    - Excel can't find file I had an Excel file on my desktop, but when I moved it (cut and paste, copy and paste, or move with mouse) I get the following error (No Code) when I try to open the file. -'C:\file location.xls' could not be found. Please check the spelling of the file name and verify that the file location is correct. If you are trying to open the file from the list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.- I have tried the following with no success. 1) Sometimes one of these works: Tools|Options|General|Ignore other applications (uncheck it) 2) Close Excel and Windows Start Button|Run excel /unregserver then Windows Start Button|Run excel /regserver The /unregserver & /regserver stuff resets the windows registry to excel's factory defaults. 3) The XLStart by default is on your PC. If you don?t show any path in the At Startup box (or in Alternate Startup Folder in prior versions), then somehow you?ve placed files in your XLStart folder that don?t belong there. Do a search on your hard drive, and find XLStart, and move the files back out of there. 4)The At Startup folder line is empty in my Options/General section I've also made sure the Ignore other applications box is UNCHECKED. (It was to begin.) I've also done a Repair/Reinstall with my Office 2003 Disk. Any Help??!!?? -- deaconswin ------------------------------------------------------------------------ deaconswin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36750 View this thread: http://www.excelforum.com/showthread.php?threadid=564696 Tag: Sorting/Function Help Tag: 99958
  - 25
    - Conditional formating Need help figuring out a formula please. If "date entered" in cell exceedes todays date by 4 days, then format the cell background "Red". Thanks so much for any help you can give. -- Unplugged ------------------------------------------------------------------------ Unplugged's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36751 View this thread: http://www.excelforum.com/showthread.php?threadid=564685 Tag: Sorting/Function Help Tag: 99951
- Next
  - 1
    - Workbook linking Is there any way of linking individual worksheets in a workbook to separate workbooks so that they will automatically update? Just cutting and pasting messes up the formatting and loses the charts. Thanks -- sanders ------------------------------------------------------------------------ sanders's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36745 View this thread: http://www.excelforum.com/showthread.php?threadid=564678 Tag: Sorting/Function Help Tag: 99949
  - 2
    - writing values in to excel Hi, I have got a script which gets all the groups associated with a particular user. im able to refer the user name from the excel. How can i write groups names (multiple values) in to excel. *************code************************ Set Wshshell = wscript.createobject("Wscript.Shell") Set WshNetwork = WScript.CreateObject("WScript.Network") Set oGroupDict = CreateObject("Scripting.Dictionary") 'set fso = createobject("scripting.filesystemobject") Set excelapp = CreateObject ("excel.application") Set openexcel =excelapp.workbooks.open ("mypath\groups1.xls") k=2 While openexcel.worksheets(1).range("A"&k).value <> "" strusername= openexcel.Worksheets(1).Range("A"&k) wscript.echo strusername PopulateGroups(strUserName) k=k+1 Wend '---------------Function to populate the user's domain membership -------------' ' The group name is passed as an arguement ' '------------------------------------------------------------------------------' Function PopulateGroups(userName) Dim sAdsPath, oUser, oGroup If IsEmpty(DomainGroupsForUser) Then Set DomainGroupsForUser = CreateObject("Scripting.Dictionary") DomainGroupsForUser.CompareMode = vbTextCompare sAdsPath = WshNetwork.UserDomain & "/" & userName Set oUser = GetObject("WinNT://" & sAdsPath & ",user") For Each oGroup In oUser.Groups DomainGroupsForUser.Add oGroup.Name, "-" wscript.echo oGroup.Name Next Set oUser = Nothing End If End Function '---------------Function to check if the user is a member of the group---------' ' The group name is passed as an arguement ' '------------------------------------------------------------------------------' Function IsMember(sGroup) isMember = CBool(DomainGroupsForUser.Exists(sGroup)) End Function Tag: Sorting/Function Help Tag: 99944
  - 3
    - Replacing a comma ( ,) with a new row Hellol everyone, I have being working ont this spread sheet for a long time because my work requires that I incert a number in a single cell in a new row. But some of the cells containt hundreds of numbers separated with a comma and this makes my life hell. I would like to know if there is any way I can automatically replace the comma with a new row. If anybody can help me out please email me at spiderweb14@gmail.com. Thank you very much. -- spiderweb ------------------------------------------------------------------------ spiderweb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36746 View this thread: http://www.excelforum.com/showthread.php?threadid=564657 Tag: Sorting/Function Help Tag: 99943
  - 4
    - MS Query. Can you use parameters with LIKE and % wildcards? Please help! I have (what I thought was) a very simple single table query, but I am struggling with it in MS Query. I can do it using stored procedures and ADO, but that would probably be overkill for such a small query and I will only resort to that if somebody confirms that is impossible to achieve using MS Query My problem is that the parameter that the users will enter (location code) is a substring of item code in the table. There can be more than 1 item code with the same location code embedded in it and this is what the report seeks to identify. However the location code substring will have varying start points and lengths so I don't think I can use substring in this context. I can get results for a single location code by using LIKE eg dxobv1 LIKE '%GBWA10%', but am struggling with the syntax of replacing GBWA10 with an input parameter. Something like dxobv1 LIKE '%[Please input location code]%' Can anybody confirm whether or not this is possible to do using MSQuery, and if so, could they confirm the syntax for me to use. including the parameter prompt. Many thanks in advance! Tag: Sorting/Function Help Tag: 99941
  - 5
    - Message Box On One Sheet Only I have a large spreadsheet with multiple worksheets in it. When one specific worksheet is selected (it does the calculations used on the other pages) I would like a pop-up text box to appear warning the user not to print it. Is there a relatively easy way to do this given that I can't write VB (though I can follow it in the VB editor)? I have been able to create a pop-up that appears on every page by putting an Auto_Open Msgbox in the ThisWorkbook module, but can't figure out how to get it to work on only one worksheet - is this a syntax probem or can't it be done?. Another option would be to completely hide the tab, but when I do this, the macros that refer to the page from other worksheets fail to function correctly. Is there a way around this? Any help/suggestions/sample code gratefully received. Tag: Sorting/Function Help Tag: 99940
  - 6
    - Transposing problem - please help if you can Hello, I have been puzzling over this for some time now and am sure a seasoned excel person will have a solution. ----------------------------------------------------------------- First let me explain the spreadsheet. ----------------------------------------------------------------- It is a list of customers, and purchases that each customer has made. every purchase has a unique row. for example: - CUSTOMER ITEM customer a someitem customer a someitem2 customer a someitem3 customer b someitem4 ------------------------------------------- What I want to end up with ------------------------------------------- customer a someitem someitem2 someitem3 customer b someitem4 etc ... the problem is that the number of purchases varies between customers, some have fifteen or so whilst some have three so i'm having trouble figuring out a way of automating it. I've simplified the example but in reality there are about 10 columns which belong to each purchase, and these are what I need to append to the end of the customer row. I hope someone can help because there are over 4 thousand rows - so to do this manually is going to take me a week of sundays Thanks, Gary. Tag: Sorting/Function Help Tag: 99937
  - 7
    - Help on Lookup I have a spreadsheet that contains two worksheets (a & b). In worksheet b (which is hidden) all of the data is kept for a test that is run each day. (user form is used for data entry). from this data, a total is calculated (nothing serious, just =sum function). The data is entered in columns and the total is calculated at the bottom of every other column (i.e every day data is entered into two columns, C&D, with the total being calculated at the foot of column D and so on). On Worksheet (a) I want to create a summary of the days data - including the total result. Can I make a cell show the latest total without having to manually tell the cell in WS (a) where to find the data every day? i.e. can I make a cell lookpup data in the last unavailable cell across a row? Tag: Sorting/Function Help Tag: 99933
  - 8
    - Worksheets to workbook Hi I have a excel workbook containing 20 different worksheets. Is there a quick way to make each worksheet a separate workbook? -- Patsy Rogge Tag: Sorting/Function Help Tag: 99932
  - 9
    - absolute formula in Excel Hello all we need to use absolute formula in most cells, the way that we know is that use the normal formula and then add $ sign before cell ref. It is a nightmare to correct all cells manually. is there any way to make it fix? Thanks Tag: Sorting/Function Help Tag: 99920
  - 10
    - Converting Dates between Gregorian to Afghani Calendar Hello, I need your help in creating a calendar that converts the dates fro Gregorian Calendar to Afghani Calendar. Afghani Calendar is sola calendar which mean it has 365 days. It is not Lunar Calendar. So yea 2006 = 1385 afghani calendar. So this mean that G= A + 621 and A= G 621. The problem I have is converting the months and days. The new year fo Afghani Calendar is march 20 or 21 (depends on which day is the firs day of spring). So the new year 1/1/2006 is 3/20/1385. I would like to create a excel file that does this conversion and a well show the month and days graphically. :rolleyes -- kjaa ----------------------------------------------------------------------- kjaan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3673 View this thread: http://www.excelforum.com/showthread.php?threadid=56457 Tag: Sorting/Function Help Tag: 99918
  - 11
    - About procedures in microsoft support Hi. Is it possible someway to save (or print) all the answers of a newsgroup of Microsoft support (for example EXCEL team), without going question by question? Thank you. Tag: Sorting/Function Help Tag: 99914
  - 12
    - Averaging compound numbers, e.g. Blood Pressur How does one average blood pressure readings? Please give an actual example, such as 152/65. Tag: Sorting/Function Help Tag: 99894
  - 13
    - Sumproduct I heard that sumproduct is very useful. Can I know the functions of it. Thank you Tag: Sorting/Function Help Tag: 99893
  - 14
    - Best Cheap Deal for All Hi All ! BEST PRICE FOR YOU HEALTH LIFE : 'tramadol' (http://tramadol.knopkabablo.info/) 'phentermine' (http://phentermine.goodpharm.info) 'tramadol' (http://tramadol.goodpharm.info) 'ultram' (http://ultram.goodpharm.info) 'valium' (http://valium.goodpharm.info) 'xanax' (http://xanax.goodpharm.info) 'ambien' (http://ambien.goodpharm.info) 'carisoprodol' (http://carisoprodol.goodpharm.info) 'cialis' (http://cialis.goodpharm.info) 'cheap phentermine' (http://cheap-phentermine.cheapills.info) 'cheap tramadol' (http://cheap-tramadol.cheapills.info) 'cheap valium' (http://cheap-valium.cheapills.info) 'hydrocodone' (http://hydrocodone.cheapills.info) 'phentermine online' (http://phentermine-online.cheapills.info) 'valium online' (http://valium-online.cheapills.info) 'viagra' (http://viagra.cheapills.info) 'xanax online' (http://xanax-online.cheapills.info) _******Best_Travel_Deals*******_ 'adventure travel' (http://adventure-travel.globaltr.info) 'airline ticket' (http://airline-ticket.globaltr.info) 'business travel' (http://business-travel.globaltr.info) 'calgary travel' (http://calgary-travel.globaltr.info) 'cheap travel deal' (http://cheap-travel-deal.globaltr.info) 'cruise travel' (http://cruise-travel.globaltr.info) 'islands tour' (http://islands-tour.globaltr.info) 'overseas adventure travel' (http://overseas-adventure-travel.globaltr.info) 'travel' (http://travel.globaltr.info) 'walt disney world travel' (http://walt-disney-world-travel.globaltr.info) bye.. -- Fox Kimpbell ------------------------------------------------------------------------ Fox Kimpbell's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36725 View this thread: http://www.excelforum.com/showthread.php?threadid=564526 Tag: Sorting/Function Help Tag: 99891
  - 15
    - Show parentheses in Accounting Format I have Excel 2002 (XP) and want to display negative numbers in parentheses in ACCOUNTING FORMAT instead of with a minus sign. I know this is possible as a standard feature (I have done it before on a previous machine) and I think there was a KB patch for this flaw. Anyone know of where I might find the fix? Tag: Sorting/Function Help Tag: 99879
  - 16
    - Automatically create hyperlinks My workbook contains about 50 worksheets. I want to allow the user to select which worksheet they want to look at from the first worksheet in the file. However, I really don't want to create 50 seperate hyperlinks by hand! Is there any way to automate this process? Furthermore, can I create a drop down menu with the worksheet names which are hyperlinks? Thank you. -- aposatsk ------------------------------------------------------------------------ aposatsk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36709 View this thread: http://www.excelforum.com/showthread.php?threadid=564431 Tag: Sorting/Function Help Tag: 99870
  - 17
    - How to sort with fractional Hi, I am just wonder how to sort the colum with all the fraction on top or bottom ...ie.. 54.375 377 21.75 87 to be like this.. 377 87 21.75 54.375 -- TaGY2K ------------------------------------------------------------------------ TaGY2K's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1861 View this thread: http://www.excelforum.com/showthread.php?threadid=564424 Tag: Sorting/Function Help Tag: 99868
  - 18
    - Sort Order is Mixed-Up I use an Excel 2003 worksheet for storing the results of my medical lab results. One of the columns is labled "Component" and contains the names of the tests. I have formatted the cells in this column as text. I also have a column for the dates of the tests. When I try to sort by Component, the rows don't end up in alphabetical order. Rows 2-13 are sorted alphabetically from CORTISOL to SODIUM And then it starts over and rows 14-70 are sorted alphabetically ADDITIONAL FINDINGS to VITD-25 OH I'd be grateful for some ideas on how to troubleshoot and solve this problem. Tag: Sorting/Function Help Tag: 99858
  - 19
    - Not dropping down after enter: what did she do?? My daughter was poking around in Excel, "working" through John Walkenbach's "Excel Bible", including all the little fun stuff (like rewriting my menu names backwards!). Now when I type in a cell and press "Enter", it doesn't drop down to the next cell. She doesn't remember all the things she played with, and I can't find the setting that was changed. Can someone help me here? Ed Tag: Sorting/Function Help Tag: 99855
  - 20
    - Hyperlink to a chart worksheet I have a "table of contents" worksheet. It lists a number of other worksheets in the spreadsheet and provides hyperlinks to those sheets. However, I can't find a way to provide a hyperlink to a chart worksheet. The chart worksheet is not listed in the bookmarks, and there doesn't seem to be a way to name a range in a chart that I can point the hyperlink to. Can anyone suggest a solution please? Tag: Sorting/Function Help Tag: 99853
  - 21
    - Placing filtered rows into spreadsheet Question: Once you've applied a filter to a spreadsheet, is there an easy way to save the filtered results into another workbook (so that the hidden rows are deleted in the new sheet)? I basically need to create a new file, and I don't want to jump through the hoops of linking to Access if I don't need to. Thanks, Eric Tag: Sorting/Function Help Tag: 99852
  - 22
    - Question about Paste Special Hi, I have a problem sometimes with the paste special options when goin from one excel workbook to another. For example, sometimes when I cop data from one workbook and then paste special into another, I get th options that include: All, formulas, values, formats, has the option t transpose the data and paste link among other options. And the sometimes I try and paste data to another workbook and I end up th paste special options: Bitmap Image Object, picture, bitmap, and I als lose the ability to paste link. Well you can do it, but it puts it i as an object. What I want is the first paste special option I described. Is there setting to change? The data is nothing special I'm usually copyin over, just normal excel entries. Thanks in advance +------------------------------------------------------------------- |Filename: Paste_2a.gif |Download: http://www.excelforum.com/attachment.php?postid=5084 +------------------------------------------------------------------- -- Mike100 ----------------------------------------------------------------------- Mike1000's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3670 View this thread: http://www.excelforum.com/showthread.php?threadid=56437 Tag: Sorting/Function Help Tag: 99851
  - 23
    - Workbook import In Workbook 1, I am running a macro that uses this code to select a file and copy A:Z on the main worksheet: Dim myBk As Workbook Set myBk = Workbooks.Open(Application.GetOpenFilename _ (, , "Select the file")) Sheets("Main").Select Range("A:Z").Copy Next, I want it to switch back to Workbook 1, insert a new worksheet, paste the data, and name the worksheet "rawdata". Any suggestions for me? I basically have a workbook I'm starting from, I want to open a dialog box to allow the user to select another excel file (filenames can be different so I want user to select), and then import a specific worksheet from that workbook into my starting workbook. Any help would be greatly appreciated, Thanks! Dan Tag: Sorting/Function Help Tag: 99843
  - 24
    - Is thre a way to use a multi-area selection in SLOPE() formula I want to use a multi-range selection as arguments for known_x and known_y in the SLOPE() function. If i am on, say, the known_y argument, and select a range, and then press CTL and select another non-contiguous range, Excel simply produced two ranges separated by commas, and this means that the second selection is treated by Excel as the second argument ot the slope function, i.e. the known_x argument, and not as a multi-area seleciton for the frist argument to the function, the known_y argument. Is it possible in some way to accomplish this? Thanks, tom Tag: Sorting/Function Help Tag: 99842
  - 25
    - new line in mail in notes from VB Hi, I have set up a bit of VB code send automated mail from Excel..... however i dont know how to start a new line in the mail.... everything I enter goes on the same line. Does anyone know how i can put tables into my automated mail, or even just copy a range of cell and have them inserted? any help would be greatly appreciated, thanks. Tag: Sorting/Function Help Tag: 99837

I need help on excel.
I need to find a easy way to sort.
I'm trying to find out how to take out dates that are more than 10, 15
20, and so on days.
Say you have a list of dates:
How do I pull out the dates that are 10 days or 30 days past?
I tried using sort but that don't help.
I tried using If and Countif functions. I don't get how it works. I'
stuck.
Please help. Thank You.

1-Jun
2-Jun
3-Jun
4-Jun
5-Jun
6-Jun
7-Jun
8-Jun
9-Jun
10-Jun
11-Jun
12-Jun
13-Jun
14-Jun

Top

Re: Sorting/Function Help by Dave

Dave
Wed Jul 26 06:39:58 CDT 2006

You could add another column with a formula like:

=today()-a2
Format it as General
and drag down the column

Then apply data|filter|autofilter to that column and show the dates that are old
enough (greater than 10, greater than 30, ....

saboolla wrote:
>
> I need help on excel.
> I need to find a easy way to sort.
> I'm trying to find out how to take out dates that are more than 10, 15,
> 20, and so on days.
> Say you have a list of dates:
> How do I pull out the dates that are 10 days or 30 days past?
> I tried using sort but that don't help.
> I tried using If and Countif functions. I don't get how it works. I'm
> stuck.
> Please help. Thank You.
>
> 1-Jun
> 2-Jun
> 3-Jun
> 4-Jun
> 5-Jun
> 6-Jun
> 7-Jun
> 8-Jun
> 9-Jun
> 10-Jun
> 11-Jun
> 12-Jun
> 13-Jun
> 14-Jun

--

Dave Peterson

Top

Re: Sorting/Function Help by saboolla

saboolla
Wed Jul 26 08:27:29 CDT 2006

Thank You So Much Dave.
That helped me a lot.
Wish I found this forum sooner.

--
saboolla
------------------------------------------------------------------------
saboolla's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36797
View this thread: http://www.excelforum.com/showthread.php?threadid=565096

Top