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!

Register Log in
  • 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: *

  1. gizmo1973

    Remove XLS duplicates but leave a fixed amount instead of just one

    It's all in the translation! Cheers Skip, worked a treat Please remember that with all my answers there most likely is a better way to achieve your results but I prefer the quick, simple and down right dirty approach!! Regards, Phil. www.mmse.co.uk
  2. gizmo1973

    Remove XLS duplicates but leave a fixed amount instead of just one

    Skip, It's something external to the data as the UNIT_ID is going to be linked back to another table to provide analysis The UNIT_ID will be handled externally to provide algorithmic data and it is that data that ultimately is being tested it's just we need 10 of each record to test the...
  3. gizmo1973

    Remove XLS duplicates but leave a fixed amount instead of just one

    HI Andy, Sorry I didn't reply however the reason I didn't was that a VBA solution wasn’t okay for me as I have no experience of anything more than very basic macros and I didn’t want you going off to do something that would work for someone experienced however thanks for your code but as I knew...
  4. gizmo1973

    Remove XLS duplicates but leave a fixed amount instead of just one

    I would expect to be able to be left with 10 of each rows based on the duplicate CONCAT column As you can see from the above there are multiple occurrences of the CONCAT column but the UNIT_ID column is not the same so they are not unique values for the row of data I would expect to see the...
  5. gizmo1973

    Remove XLS duplicates but leave a fixed amount instead of just one

    Hi Skip, Thanks for your reply, long time no speak! What you say is correct and the data as below, I've left all four original columns in but am only working with cols A & D (as D is a concat of B&"_"&C) I'd want the first 10 of the UNIT_ID of the first 19 based on the CONCAT then when the...
  6. gizmo1973

    In Power Point, how to create links to other applications?

    You don't say which PPT version you're on so the below relates to 2010 From the main set up screen click INSERT Then OBJECT from there you can chose CREATE FROM NEW or CREATE FROM FILE via the radio buttons and MS EXCEL and WORD are both options there as well as many other things like PDF...
  7. gizmo1973

    Remove XLS duplicates but leave a fixed amount instead of just one

    Okay, we all know in XLS you can easily remove duplicates by sorting and using the IF statement and in XLSX they've even added a little tool for us to do this but herein is my dilemma… Both these operations assume I only want to be left with a clean list of data i.e. only one record from the...
  8. gizmo1973

    Display of Appointments in a Shared Calendar

    You could ask all recipients to set an automatic preference of tentatively accept all meeting invites This way at least the meeting will be shown in a calendar (I think! It's been that long since I dealt with shared calendars for call centre and field sales but I am 99% this was our solution)...
  9. gizmo1973

    Weekly Totals into Monthly Totals

    You could format the date as MMM and then use the subtotals system based on the change of month to give you a total for each month (based on change of month column) That's how I've done similar in the past or if the date is important to be preserved introduce a new column with either the...
  10. gizmo1973

    Sort Excel (2003) Sheet By Color

    I think there is a VBA way to do this but I'm not that good at it so I bought a system called ASAP utilities which lets you sort by colour as well as other things, always worked for me P.S. I am in no way connected to the app. just use it as an end user myself...
  11. gizmo1973

    Increse number on Print

    Cheers Geoff, Searching for BEFOREPRINT brought up many solutions but for some reason I could not get them to work though it did lead me to a very nifty Macro Sub PrintCopies() Dim i As Integer Dim iCopies As Integer iCopies = Application.InputBox("How many copies?") For i = 1 To iCopies...
  12. gizmo1973

    Increse number on Print

    Hi all, Quick on for you; I'm sure I have seen this before but I cannot find it. In Excel 2003 I have a cell which says MMS/000001 and what I am after is for this cell to increase by one every time the sheet is printed. ie MMS/000001 MMS/000002 MMS/000003 So on and so forth, I was going to...
  13. gizmo1973

    Backward culculating percentages in excel

    I'm on the bus now!!! I was Gross'ng and Net'ng away without a care in the world forgteting that when a % is taken off you simply can't add that % back on to come back to the orignal figure! Regards, Phil. www.manchester-medical-services.co.uk
  14. gizmo1973

    Backward culculating percentages in excel

    I still get it to be 201.25 230 / 100 = 2.3 (which we can see is 1%) If we then say 2.3 X 12.5 That equals 28.75 (or 12.5%) 230 - 28.75 = 201.25 Am I going mad? I was taking it that 230 USD was the gross figure and Karl neede the Net figure Regards, Phil. www.manchester-medical-services.co.uk
  15. gizmo1973

    Backward culculating percentages in excel

    Couple of ways you can do this assuming your gross price (230 USD) is in cell A1 =(A1/100)*12.5 This will give you the 12.5% then take the starting price of 230 USD from the result of the equation to equal net price (handy if you want to also know how much the agency charged you) or...
  16. gizmo1973

    Using BCC in Outlook

    Sent items, Right click on any of the current headers such as "To" and then choose Customize Current View, click on the fields box and then in the drop down box change to address fields, BCC should be there to choose to add to the view Now it doesnt actually show you in the sent items the names...
  17. gizmo1973

    Office 2007 UI

    Do you have the authority to make the decision about which version you use? If so go out and buy a copy of 2003 otherwise it looks like you are stuck with your companies decision to move with the times as other than the answers you already have been given it appears to be that you do not have...
  18. gizmo1973

    Excel: Filter PivotTable

    I have tried this before and the work around I came up with was to put a date range within the data itself before you Pivot it ie all dates in January have a new column with a date range of January etc etc that works but may not be what you are looking for, the easy way to do the range within...
  19. gizmo1973

    Excel Replace digit with Text

    Do you have all three numbers in the cell or just one of three? An IF statement needs to refer to a cell and it looks like you aren't doing this just now? Regards, Phil. www.manchester-medical-services.co.uk
  20. gizmo1973

    remove space and hyphen from number

    shebang, now there's a word I've not seen or heard of in a while Regards, Phil. www.manchester-medical-services.co.uk

Part and Inventory Search

Back
Top