I have a list in rows where I have a ranking formula =COUNT($G$5:$G$81)-(RANK(G5,$G$5:$G$81)+ COUNTIF($G$5:G5,G5)-1)+1 When I sort the rank, ascending. All of the unique numbers sort ascending, but the non-unique numbers sort descending
I am looking for a VBA to sort rows which include actual numbers and text representing decomposed CTQs (or procedures in IT development)
Col A Col B 1Billing Accuracy 2Billing Time 3Credit Check Accuracy 4Credit Check Time 2.1Bill preparation
This is the order in which the data is copied and saved from worksheets in which they are developed. Note that 3 rows (126.96.36.199 through 188.8.131.52) are below 8.1.3 (because the three come from Worksheet 8.1.2 which came after worksheet 8.1). The first four rows came from a Top Level Worksheet. I would like to see them intermixed but in proper order.
in the attached WB you'll find a Source Table that should be duplicated and in the same time sorted as per the Points. The task should be accomplished with NO VBA, NO Helper Columns and NO Manually Copy+Sort.
Column "H" formula was no problem but I'm stuck with the "G" formulas as you can see in cells G5 and G7. I found it difficult to handle two different names with the same points. What would be the correct formula for column "G" ?
I realise there are a few threads on similar topics but I can't seem to get any of them to work for my scenario. I have two columns with a list of numbers in each. I'm after a function that will scan column A and identify any numbers that also appear in column B. If possible I would like it to then generate a list of these in say, column C.
I have in my sheet from C13 to C350 many serial numbers which I manually type them in. These serials are 5 digit numbers, and I was just wondering if there's a function or formula that will not allow duplicate numbers in that column.
I have 2 columns I need to compare, in column A a list of ref numbers aprrox 62000 rows, with some duplicates. In column C a list of ref numbers 38000 rows again with some duplicates.
I need to be able to compare Column C to Column A. I need to identify the first instance of a ref number that matches from C to A so that I can delete it. The second instance of this ref number I would like keep. I have tried the following with no luck.
I need to remove duplicate Part Numbers where other information in the cells will not match. In the following two examples, the only difference is that the COMP_ID: number is different, but for my purposes, the second example is a duplicate and needs to be removed. I have hundreds of rows of this type of information with various part numbers: ...
I have a column where i have to put document numbers, Column A, i want to avoid accidently capturing something twice, so the only thing thats unique is the document number. Can i get an error if i try to enter the same number twice?
I have 3 columns; A:Name, B:Debit & C:Credit. There are multiple row (approx 15,000) where I have a customer name and then a debit at one date, and a credit at another date. There is a debit to match every credit.
I would like to some how sort the sheet so that I can make sure each credit matched the debit. That way I can find what debit's don't match the credits. This is an example of how this looks. http://i303.photobucket.com/albums/n...kejoe/sort.jpg. I would like to sort it like the example on the far right (see attached picture)
I have a column of data that contains alphanumeric ID codes, some of which contain no alpha characters (i.e., Excel treats them as numbers). When I do a data sort, Excel puts all the purely numeric codes first, then the alphanumeric codes. I want to sort the numbers among the alpha codes.
I have a 1x20 array with the numbers 1 thru 20 inside. I want a piece of vba code to randomly sort them. I will do this in a loop to create different "starting arrays" for an optimization code. I just need to be able to randomize the beginning. How is this done? I cant have duplicates.
I have a list I want to sort containing both letters and numbers. Right now the regular sort sorts like this ABC-1 ABC-11 ABC-12 ABC-2 I want it to sort like this and don't have a clue how to do it ABC-1 ABC-2 ABC-11 ABC-12 I am using excel 2003
I have data in column C of rows 25 to 45. The data varies in number form.
What i would like to do is have some VBA code that i can place into a macro which will sort the numbers in column C of rows 25 to 45 putting the highest number at the the top (C25). But i need to move the complete row.
I have unit measures that are converted across four columns (FT, SQFT, SQM and SQY).
THere are three units in rows (BOX, Skid and Roll). I am trying to identify in a column labeled "Duplicate Volume" with a formula stating "YES" if there are duplicate numbers (volumes) in any of the four conversion columns listed above. I tried to attach an excel file here but the system will not accept it. Hopefully the diagram i make below will be enough to understand the concept:
Attempting to do a spreadsheet for my golf club, to record scores, etc...
Managed to get it to pretty much what I want despite some very extreme looking formulae! So for some scores such as 56,56,57,57,54,54, Rank would just give me 3,3,5,5,1,1, so I have put a second column next to 56,56,57,57,54,54 where I input scores to seperate ties (better back nine scores), so in the above I would have for example 30,29 next to the two 56s, 27,29 next to the two 57s, and 27,28 next to the two 54s, so the rank would return 4,3,5,6,1,2. I have gone three stages further, so if, the back nine score was also tied, I have a column for the last 6 hole score, the last 3 hole score and even the last hole score. This is some serious formulae at this point. However, I now want the OPTION to rank the original data as 2,2,3,3,1,1 if I don't put any data in the back nine column.
This is so that I can input doubles scores on the same spreadsheet as singles scores, so if two people shoot the same score in singles I can input the back 9 scores etc to decide who comes out ahead, but in doubles I would just leave the back nine score blank, and then two people would share 1st in the rank, but then I need two 2nd ranks NOT 3rd ranks as it currently is.
Just so you can see how complex it is the current forumlae in the rank is here is an example: