Search results

Try this one .... https://rapidshare.com/files/609232834/Scoring_File.xls

Hi guys, Thought I would check back with you all to see if anyone has had any ideas or thoughts on this. You know I like to challenge you :-). Let me know if you need more info, I am sure there is a way to do this, with my workings I got most of them right,, but not all sadly. Thanks

Let me know if this helps ... https://rapidshare.com/files/2143673292/Scoring_File.xls

Hi guys, Poser for you, I have a scoring sheet where contestants in a competition are given a placing by judges ( there will be 5, 7 or 9 judges ). The result of the judges placings for the contestants will then determine final placings as follows. Each judge must place each contestant in 1st...

It's ok guys ,, I managed to find a solution, but thanks for looking :-)

Hi, I am looking for a little help with dates .... I am creating a new spreadsheet and I want a date to appear in three separate cells ( which will be then be shown in rectangle shapes ), I can easily get the day of the week in one cell, the month in another and the date ( e.g. 17 ) in a third...

It's ok guys ,,, found out what I was doing wrong in my original formula ,,,,, thanks anyway

Should have said, I can use conditional format to highlight cells that appear in Col A and Col B using the Conditional Format, but need to be able to highlight using 3 columns.

I have a file which has part numbers in three columns, I need to highlight those parts which appear in more than one column, e.g. a part 1234567 appearing in column A and column B, part 2345678 appearing in column A, B and C.

Sorry , I should have said, this needs to be Excel 2003 version. Thanks

Hi everyone, Poser for you ... I have a spreadsheet I'm using to keep track of course material and updates. However as this sheet contains hundreds of entries, I wish to automate it a little bit more, and add a macro to automatically send a notification to the owner via e-mail if the last update...

Hi Hui, understand the way the rank is working, maybe I need to look at the scoring system instead. The reason I say that 14.014 should be higher in rank to 14.017 is that if we look at the judges placings, the contestant with a score of 14.014 has 2x 9th placings while the contestant with...

Hi Hui, yes, data is copied down ,, and I get the same result as you ,, if you look at the results, 14.014 should be ranked 8th and 14.017 should be ranked 9th.

Hi Hui, thanks for the feedback, appreciate it. In my example though, with the changes made as per your post, there is a tie break ( rows 14 and 17 ) both with scores of 14 and based on the judges scores, row 14 should be in 8th place and not 9th. I guess I could sort the data based on column X...

Hi guys, I've been asked to create a file for a contest. There are five judges giving nine contestants scores. It's simple enough to count the scores and rank the results based on the scores, but having a little difficulty with tied places. I am using =IF(COUNTIF to break the ties, which works...

Thanks Hui, I will have a closer look at this, appreciate your insight as always. Thanks again.

Hi Hui ,,,, I don't have Excel 2007 or 2010 ( yet ), neither does the user of this report unfortunately, but feel free to pass on the solution you found with the better versions of Excel. However, your solution using Dupe with Advanced filter seems to work, I have tested it on the example file...

Hi Hui, Yeah, but a unique list of the order numbers will include those which only appear once as well as those which appear multiple times ..... there must be a way to do this, but perhaps it can only be done with VBA code ( which I am not good at ).

Hi Luke, some good tips in the link, thanks for that. Not sure it entirely helps me, I had hoped there was a way to set up a distribution list in Excel containing a list of emails i.d. which I could attach to a button perhaps and have that populate an email with a message ,,, i guess king of...

Hi, I am looking for a solution to a small problem. I have a list of data, name, address, email i.d. etc in a spreadsheet, which records who attended which meeting group ( group on and group two ). Is there a way to send an email to those groups separately ( I may want to add a personal note...

Hi Hui, thanks for the reply, I don't think this is going to help me solve the problem. The solution of using the advanced filter relies on knowing the criteria, in this case knowing the order numbers which appear more than once, however, the user will NOT know which order numbers appear more...

Example file posted in the URL below ... Fileswap. http://www.fileswap.com/dl/fNf3yP/Return_Mulitple_Entries.xls.html

Hi guys ,,,, Had a look at Advanced Filter and it's a good tool to have,however I am either doing something wrong or it's not quite what I am looking for. Yes I can filter the report to show the relevant data for specific order numbers, but the user will not know what those order numbers are...

Hi Hui, Not sure that would work, the order numbers are numerous and are random throughout the report. The criteria I have is to show the ship status, order number, product and qty. Ship status contains various stages, build, shipped, on order and In Mfg.

Hey Luke ,,,, I've tried a few things, including using a Pivot Table, but the report is so large pivots can only cope with a portion of the data. I can post a sample of the data if you wish, just let me know where to post ,,, Rapid Share etc etc.