Recent content by gizmo1973

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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