Numbering And Sorting The Data
I have a excel file which looks like the following:.............
The file contains more than 25,000 rows. What I need is, I have to give numbering to the above including parent id no as well. The nesting level can go to a maximum of six. The result should be
1 Electronics 0
2 Sound & Radio 1
3 MP3 & Portable Audio 2
4 Mp3 Players 3
5 IPod 4
6 Nano 5
7 5GB 5
8 10 GB 5
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Numbering Blocks Of Data.
I have 250000 lines of data and at the moment they are in seperate blocks of different sizes, and seperated by 5 blank lines. For Example 112 1523 523 1523 *5 BLANK LINES* 12 23 *5 BLANK LINES* 344 4563 etc. What I would like to do is give each block a number. 1 112 1 1523 1 523 1 1523 *5 BLANK LINES* 2 12 2 23 *5 BLANK LINES* 3 344 3 4563 The lines in between will come out eventually I just need them there as they are difineing the blocks of data.
View Replies!
View Related
Auto Populate Data After Sorting The Data
I need to have cell data on sheet 1 to populate cells / rows on sheet 2 when the data is sorted on Sheet 1. So let me explain: I have workloads on each row in Sheet 1. Column A has a list of people that I assign to each workload. After assigning a name in Column A to each row, I sort Column A by the user to print out only their workloads. Currently, we have a paper worksheet where they manually write in their workload. I have replicated this worksheet on Sheet 2 and was wondering if I could use the data in Sheet 1 after being sorted by user, to populate the worksheet on Sheet 2 ?
View Replies!
View Related
Sorting Data Out
I have five columns of data A to E. In each row there can be data in either 2 3,4 or 5 of the columns. What I want to do is essentially condense the data. So in columns, say, G,H,I J,K if there is data in column A then It goes into column g, if not it asks if there is any data in column b and so on. Then for H it does the same but one on. I have attached an example to show what I would like to happen.
View Replies!
View Related
Sorting Out Data
How do I sort this data, such that I just have individual numbers in a row. ******** ******************** ************************************************************************>Microsoft Excel - Neil.xls___Running: 11.0 : OS = Windows Windows 2000 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutU1291= UVWX1291COAL AT 5.82-5.86; 24.16-24.20; 24.64-25.77; 26.30-28.31FALSEFALSEFALSE1292COAL AT 23.52-23.57; 26.12-26.16; 44.58-45.57;46.10-47.85FALSEFALSEFALSE1293COAL AT 23.24-23.27;5.62-25.67; 42.12-43.05; 43.63-45.57FALSEFALSEFALSE1294COAL AT 39.16-39.24; 59.10-59.90; 60.47-62.40FALSEFALSEFALSE1295COAL AT 15.77-15.82; 22-22.06; 39.41-40.52; 40.75-42.80FALSEFALSEFALSE1296COAL AT 14.03-14.08; 16.48-16.53; 34.19-35.32; 35.76-37.81FALSEFALSEFALSE1297COAL AT 15.92-15.97; 35.81-36.85; 37.33-39.33;FALSEFALSEFALSE1298COAL AT 37.30-37.35; 58.09-58.93; 59.41- The problem also arises, when I have data like this as well: ******** ******************** ************************************************************************>Microsoft Excel - Neil.xls___Running: 11.0 : OS = Windows Windows 2000 (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutU1325= UVWX1325APPROX DATE. COAL SEAMS: COAL SEAM 220FT6IN-221FT1IN; ALFRED SEAM 306FT5IN-310FT6IN.ALFRED [UTRECHT (COAL)]93.3994.6401326APPROX. DATE. COAL SEAMS: 47FT9IN-48FT; 185FT10IN-185FT11IN; 217FT4IN-219FT7IN; ALFRED 294FT6IN-296FT4IN; GUS SEAM 312FT5IN-312FT11IN; DUNDAS SEAM 323FT4IN-323FT10IN.056.6456.6701327APPROX. DATE. COAL SEAMS: ALFRED 224FT1IN-228FT1IN; GUS 250FT9IN-251FT8IN.GUS [UTRECHT (COAL)]76.4376.7101328APPROX. DATE. COAL SEAMS: ALFRED 224FT1IN-228FT1IN; GUS 250FT9IN-251FT8IN.FALSEFALSEFALSEKZN Coal Boreholes with Coal In [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR. Those numbers with Feet and inches, I want it to be converted into meters as well.
View Replies!
View Related
Sorting Data In VBA
I am encountering numerous problems compiling a macro to sort some pretty messy data. Hoping some of you could take a look and offer some suggestions.... The Data I need sorting is shown in the 'DATARAW' worksheet, this comes in every day and shows positions for each traded period. Usually 48 periods which I have highlighted although the data download could somtimes consist of 46 or 50 periods. Sheet 1 (DATA RAW) contains data which I download daily. Sheet 2 (Data Sort) is how I need it to look after sorted (I only need the data in DATARAW replacing, not another worksheet creating). So for example: Where column A = SP8 and the adjacent column B = 1 I would need: All values which = ECN to concatenate the value in B to the reference in column B directly adjacent to the value next to it, until the folowing rows are presented: So for instance the first value reported would be 131964, second 131979 etc... until the following text is shown in the rows below IDD CAT ACE ACT ACE ACT When these appear I need the entire rows to be deleted. Then basically the same for the next period where SP8 appears in column A and 2 appears in Column B. also, the final result should contain no formulas so it can be referenced by lookups etc... also, all numeric colums should be stored as number so excel doesn't get confused. This will basically repeat itself until the end of the file showing the same split as aove but with ZZZ as a footer. Which I also need to delete. :-S IDD CAT ACE ACT ACE ACT ZZZ Rows containing the values below also need deleting. AAA NOH DSI AED I've used colours in the attachment but the actual file doesn't have any.
View Replies!
View Related
Sorting Data Into Columns
I need help with either a formula or macro for sorting data into specific columns. I need the entries under the headings Ar,Bj... to be sorted into the correct columns. To add to the problem, the data may not be exactly the same as the heading. Attached is an simple example of a spreadsheet where the top is the original and the bottom is what I need the final outcome to be. The data is pasted from a different spreadsheet and will be changing each time.
View Replies!
View Related
Sorting Duplicate Data
I have an excel spreadsheet containing alot of data which looks something like this: Material Plant 1 ABC 1 DEF 1 GHI 2 ABC 2 XXX 3 ABC 4 ABC 4 DEF 5 DEF 5 XXX 5 YYY 5 XYZ As you can see, one material can exist in more than one plant. What I want to do is to seperate the materials into 'blocks' (with a blank row) so that they exist seperatly. (I can then easily total up someother value in column C). Example: Material Plant 1 ABC 1 DEF 1 GHI
View Replies!
View Related
Sorting Data Into 10% Bins
What I would like to do is for each participants data to be ranked from fastest to slowest, and then sort this array into 10%bins, and then get a mean of the reaction time within each 10% bin. The problem is, that if I have 126 reaction times for each participant, 10% bins would fall every 12.6 scores, so in which 10% bin would I put RT 13? There must be a way that excel can do this instead of me literally counting out all the RTs, then working out the 10% bin criteria, and then counting every 12.6 trials and averaging them. I have included a small sample of the reaction time data from one participant in one condition, I have 78 ish to work through.
View Replies!
View Related
Macro - Sorting Data
I am a mechanical engineer by trade and am working in Excel to manipulate data. I have written macros in the past, but have come to a stumbling block. For simplicity say I have a column of timing information such as: Time Sequence 1 9 15 23 Then I have another column of sequential time: Time actual 0 1 2 3 4 5 etc. I want to be able to take the first two values of the first column, search the second solumn for any values between those numbers, then create a new spreadsheet and copy those rows to a new spreadsheet, then loop back to search for the next two sets of numbers. So I want to search my actual time for values between 1 and 9 and put them all in a new sheet, then search for values between 9 and 15 and put those in another new sheet, etc.
View Replies!
View Related
Sorting Data Within A Cell
sorting a worksheet where the data is within a single cell. For example; Cell G1: "American Express Settlement 090914 0000013" I would like to sort the entire worksheet using this cell and being able to sort by 0000013 and not American Express.
View Replies!
View Related
Repeat Data Sorting
I need to data sort several rows of a worksheet, followed by a different selection of rows, followed by another selection, etc, etc. The first selection is done by highlighting the rows and then following the data sort menu. \ However, if I try to highlight a second selection and use the repeat command, excel repeats the action on the first selection, not the second. As a result, I have to use the data sort menu again. There must be a repeat option which acts on the new selection.
View Replies!
View Related
Roulette Data Sorting
I’m playing European Roulette, 37 numbers 0-36. I making an analysis sheet that shows me which numbers and sectors of the wheel has hit most or not. I just want to type the spun numbers and see them distributed and also see a Pie Chart of the wheel sectors. How do I attach my excel sheet here? I don't see any attachment options. I cannot even seem to attach even an image!
View Replies!
View Related
Categorizing And Sorting Data
Every week I export a payroll report from my payroll provider (sample attached). The report is sorted by employee name. I need this report to be categorized by department and show a subtotal for each department. The payroll provider does not provide a means to put departments in the system. I'd like to find a way to automate this as much as possible. The final report has to have a column that reflects each employee's department and the report must be sorted by dept with a subtotal for each dept. I tried to do this using a second worksheet that lists each employee and the dept they work in and linking it to the payroll summary using =IF; that obviously did not work. Does anyone have any suggestions as to how this can be accomplished? The process would need to be repeated for many clients each week, so I'd like to keep it as simple as possible.
View Replies!
View Related
Sorting Alphanumeric Data
Ok, before any one shoots me down, i have looked around the forum and the internet for a answer, Im im half way there. I have a column in my worksheet which contains alphanumeric data, I also have a Custom menu option to sort the worksheet but 3 columns. No i know if i have a column contains the following ....
View Replies!
View Related
Sorting Data By Date
I have a Column J with Dates formated in the dd/mm/yyyy format how do I used the Selection.Sort key:= xx order:= to sort the rows that have a date in the selected columns. Where J_End in the code below is the Column I need to refer to its sorting to a point but im not sure whats wrong with it. All I really need it to do is group all the ones with a date (completed) and without a date (not completed) thus why im sorting it and the other stuff prioritize it.
View Replies!
View Related
Sorting Data Using Macros
Unsure how to start this off, any help would be great. I have a spreadsheet with raw data in it, and am looking for a way to sort the raw data into separate sheets within excel using a Macro / VBA. Here are the different columns of data I would like to copy into a different sheet. Man Ord No. Product No. Operation Description There is a Work Centre column I would like to use this column as a way to select the different rows of data. So if there are five different rows of data for ACT#01 in the Work Centre column I would like it to copy the rows of data, delete all the columns that are not needed that’s all of them except for the above three, then add three new columns below. Add a column called “Run Time Add a column called “Resrce Name” Add a column called “Available” Work Centre will become the name of the sheet in Excel The titles of the columns will have to be added in also, via the macro. See the example excel file that I have started to make by hand, this is just one part of the process that am looking are automating there are other parts as well but just getting started for now.
View Replies!
View Related
Randomizing And Then Sorting Data
I am trying to make a student sorter using a master class list in Excel. I would like to sort about 900 people randomly into 30 different rooms and then output the data on a summary sheet that has the 30 room numbers across the columns. I am not sure how to approach this. I need the randomization of Column A on the first sheet and then the sorting of the randomized list into lots of 30 on the second sheet by room number.
View Replies!
View Related
Do While Loop Sorting Data
I have a problem in that i am trying to create a do while loop to sort through data and create new sheets naming them and adding the row to them. Or if a sheet exists dumping it into that sheet in new row. I have spent a long time cracking this problem and my progress is shown bellow there are just a few more touches shown by ' that i cannot do
View Replies!
View Related
Sorting Data From Access Db
=COUNTIFS(Table_crimestats.accdb[[#This Row], [station_id]], "station1",Table_crimestats.accdb[[#This Row],[crime_id]],"Assault",Table_crimestats.accdb[[#This Row],[date_occured]]) this works fine until the 3rd criteria, i need to pull the events of a certain month, the date is in ##/##/#### format.
View Replies!
View Related
Sorting Data By Date ..
I Have a daily spreadsheet that I want to sort automatically by date. It has a header in the first two rows ( which shouldnt be a problem as I can sort the data i want from from cell A3 to J100) etc.. Problem 1) Each date is separated by a blank row which I need to retain. Problem 2) some records have multiple rows which are together and need to be retained For example ...
View Replies!
View Related
Sumif And Data Sorting.
I have 3 worksheets in the same workbbook named Payment Distribution, Invoice Detail, and Corporate Phones respectively. Payment distribution has 3 columns (Corp, Dept, Cost). This worksheet is protected against changes. Invoice Detail has 2 columns (Deptartment, Charges). This worksheet is a workable worksheet. Corporate PHones has 4 columns, (Phone #, Dept, Name, charges) with mulitple listings per row. SUMif is used in the Invoice Detail worksheet for the department numbers and the subtotal of those charges for department numbers. The Payment Distribution worksheet contains a reference to a cell in Invoice detail for that department. If I add a new department listing to Invoice detail and then sort the department numbers numerically, how can I get the forumla for SUMif to maintain the same no matter how I sort the data? It is causing issues if I sort the departments numerically if I add the new department to the bottom of the list.
View Replies!
View Related
Data Sorting With Correction
Sub startrd3_click() Range("B5:AY64").Select Selection.Sort Key1:=Range("B5"), Order1:=xlDescending, Key2:=Range("C5") _ , Order2:=xlDescending, Key3:=Range("E5"), Order3:=xlDescending, Header _ :=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom _ , DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, DataOption3:= _ xlSortNormal ' ERROR CHECKING HAPPENS HERE TO MAKE SURE PEOPLE HAVE NOT PLAYED EACH OTHER BEFORE Columns("J:W").Select Selection.EntireColumn.Hidden = True Range("I4").Select End Sub If any of you gamers out there are familiar with the Swiss Pairing System, the goal of this sheet is to perform the pairing functions based on results. The goal of swiss pairing is to partner folks up based on win loss records, however, the players can never play each othe more than once. What i am wondering is how to create the vb code required to make sure the pairings are unique while keeping the rules of swiss pairing together. Here's how it works:.............
View Replies!
View Related
Data Sorting: Find The User Name
I have a excel spread sheet with 2 pages and on the first is where i want the data to populated, sheet1 has 2 columns. The first is blank and the second list a username the first is where i want the data i need entered on the second sheet is a imported txt file broken down into columns and i am only concerned with the first 2 here is how i want it to work sheet 1 column 1 column 2 ??? username ??? username1 Sheet 2 column 1 column 2 testing username testing username1 under username2 I want the code to look into sheet 2 in column 2 to find the username but if column 1 does not have the word testing then i do not want it to show and if the word testing is there I will then want the code to display a "Yes" In column 1 on sheet 1
View Replies!
View Related
Sorting A List From Data In Another Worksheet
I have the attached workbook that contains a list of produce in the Produce sheet and I am wanting to have the Availability sheet show what produce is available each day sorted into Good, Limited and None as per the data on the Produce sheet. I should end up with a list of each type of produce listed under the relevant availability each day. Sorry but I have limited knowledge of VB, I assume that the best way to do this is some code behind the Availability worksheet but I am not able to determine what this code should look like.
View Replies!
View Related
Sorting Imported Data By Invoice
I have imported some files in to excel. I have attached the test document to give you an example of exactly what Im working with. Here is what I need to do. 1) On a separate worksheet I need to sort out the data by invoice number (Column E). In the example I have on the worksheet titled "Main" I have listed what I would like it to look like. The purpose of this is that I don't want any spaces in rows. I just want a long list of invoice numbers and their information (Including the project number & customer on all rows). In long story short I want to erase all the information from A18:A25, and add project number and customer name to all the correlated invoice numbers. The way I think I can do this is that the first 4 digits of the invoice numbers are the same if their in the same project.
View Replies!
View Related
Sorting 2 Different Type Of Data / By Colors
i have a file which consist of sheets called june 2007, color, and report. When i click on the command button on sheet june 2007 the code works and copies some data into sheet called report in that case some of them white color copied over and some of them blue. Since at the actual file there are nearly 500 rows and 32 columns when the report works, i want to sort each colors individually by looking the values at column called ETA (column "E") white rows should be sorted in ascending order in column e wise blue rows also should be sorted in ascending order in column e wise each colors should be sorted individually
View Replies!
View Related
Sorting And Merging Data From Two Rows
I have two rows of data that I need in one row and then sorted, it is possible that the data will be difffering lengths depending on input conditions. I also need the option to sort it either ascending or descending. The data in the two separate rows depend on other parts of the system and in turn this data will be used in another part. So I need it sorted automatically. I have tried ranking the data and then sorting it by rank but for some reason this does not appear to be working.
View Replies!
View Related
Macro- Complicated Data Sorting
here i have results from a race. the racers have numbers in the format of a20,c51 etc then the name of the competitor and car make model. then some times that they run. in the format of 11.80 secs the following times have either thousands or hundredthousths of a second which i only want to comma seperate the 2 decimals before and after so a 12.3456 will be ,12.34,ignoring the 56 then the next result and so on. so i want to comma seperate the a20,andrewspeck,vauxhalltigra,11.27,13.36,12.87,12.91 etc etc now the name and vehicle will cause huge sorting head ache so leave those together i can seperate them manually. . A7,Andrew Speck,Vauxhall Tigra,11.27,13.36116,12.87113,12.91124,12.14134,11.37129,11.27128 2A4Iain BurtVauxhall Astra11.8012.1011311.8811411.8211511.80120 A2Chris SuttonVauxhall Corsa11.9514.1911413.8811212.4612412.1511511.9511814.08112 A17Andy NichollsRover 200 Turbo12.0812.0811612.8211712.50119 1A4Iain BurtVauxhall Astra12.0812.0811212.5812312.4611612.5311712.2910512.18111 A4Iain BurtVauxhall Astra12.1313.5811512.6111712.1811012.4811512.1311112.29113 1A8Gareth BirchVauxhall Nova12.1412.1411612.769912.18119 A8Gareth BirchVauxhall Nova12.1912.9811412.3811012.4111513.009612.4611212.19114 1A7Andrew SpeckVauxhall Tigra12.2612.26131 A10Errol HuellHonda CRX Turbo12.3613.3211513.2912315.726912.3610822.3652 1A14Westan FrickerFiat Coupe Turbo12.7812.78110 A14Westan FrickerFiat Coupe Turbo12.8414.8411513.7411413.4011513.3011513.0511312.84109
View Replies!
View Related
Sorting Data With Locked Columns
I have a spreadsheet on lets say 10 columns, now col 1 and 9 are locked so they cant be selected. Col 2-8 can be sorted by selecting them, but information in col 10 does not sort. Question is there a way of connecting the cells in col 10 to the cell in lets say col 2, so thay when you sort the rows and cols between 2 and 8, the cells on col 10 are sorted as well As i have noticed you cant sort two differenr selections...???
View Replies!
View Related
Sorting Data, Error 1004
I am trying to write in VBA sorting button but I am receiving error 1004. I have recorded Macro while selecting 2000rows and sorting it by B then C then A. Columns go to T and some of the columns are empty. However, first 3 lines are completely filled. This is what I have got from recorder(I have adjusted first 2 lines to suit)
View Replies!
View Related
Sorting Data Based In Word
if there is anyway of sorting data from a word document into an excel spreadheet? I want to sort be able to export the data according to the column on the far left hand side (month), into excel. ideally i would have liked to have all the data in excel as it would make things easier but in this instance i need to keep all the data input in word.
View Replies!
View Related
Sorting: Keep Surrounding Data Intact?
I was given a spreadsheet this morning for sorting and am a little lost. I've attached a sample. I'd like to sort the spreadsheet from high to low in terms of gift amount. The problem is that if I sort the Gift Amount column, all of the surrounding information gets sorted as well, messing up the layout. I know I'm missing something here. Is there any way to tell Excel that if it sorts something, sort the surrounding data as it is? Maybe by giving it a range name?
View Replies!
View Related
Sorting Raw Data Values
I will be inputing raw data (20 digit numeric code) from a barcode scanner into column A. I would like to extract the values from certain groups of those digits (first 3 digits and only those digits moved to C column, digits 4,5,6,7 copied to D column, etc.)
View Replies!
View Related
Sorting Data That Has Blanks In Some Columns
This is driving me crazy. I have a sheet with 5 columns, and 13k + rows of data. I attached an example of how its is formatted... The problem is, in column A "DBA" and D, "Address", some of the data contain 2 rows, and others contain 3 rows. When I try to sort by DATE, for example, it ends up splitting up the addresses alphabetically... How can I sort this data, by any of the columns, while still keeping the ADDRESS together? I hope this makes sense to someone because it is driving me NUTS.
View Replies!
View Related
Sorting Data With Blanks Instead Of Repeats
I have a sheet with 12k plus lines of data... Attached is a sample. I am trying to sort by any one of the column headings, without losing the order of the ADDRESS field.. Sometimes there are 2 lines, sometimes there are 3 lines of ADDRESS... Also, the first column, "DBA" has 2 lines sometimes 3 lines per entry... When I try to sort, it tells me I have to unmerge the cells.. but then when i sort, it alphebetizes everything seperatley so the addresses get splut up...
View Replies!
View Related
Sorting Data Is Changing Formulas
I have a league table (attached) - that contains some formulas for updating various columns when scores are typed in. I have one piece of the puzzle left to do, and that is to have the table sorted by column 'O' (points column) in descending order. ie, the team with the highest points sits on top of the league. The problem is, that whenever I sort the league table, the formulas attached to the 'Plyd' column (column H) get screwed up. This always happens and it doesn't matter if I do it through the use of a macro, or if I sort the league table manually by highlighting and then sorting. Always, the selection boxes in my 'COUNT' formulas seem to shift.
View Replies!
View Related
Sorting Non Unique Rows Of Data Into Another Worksheet
I have one worksheet which acts like a data dump (actuals) where data is just pasted in. This worksheet is sorted and edited on a continues basis. I need this data to be sorted into their respective coded worksheets (110, 120, 130). I would like a function in Worksheet 110, 120, 130 that captures the data for that 'code'. Now the issue is that much of the data is non-unique, dates, codes, accounts may sometimes be duplicated however i still want to display the entries separately in their respective coded worksheets. (I had a solution using column numbers however it isn't viable because the data gets resorted often)....
View Replies!
View Related
Sorting Rows Of Data And Splitting Into Different Sheets
I have sets of data (A1....F50000 or more) that I need to sort out based on the cell value in column F. Based on the cell value I would like the info on the row (A to F) put into a different sheet. There would be 8 different sheets and each sheet would include 1 to 50 different sorts from column F. The macro could start with one material sort each and I could fill in the rest of the sorts. The 8 different materials (one for each sheet to start) could be "34b2p""ptop27""pdw19""p58leg""ppdpts""mirror""Pdoor""bent""p4545".
View Replies!
View Related
Importing A CSV File And Sorting The Data
I have a group of CSV files that I will need to periodically import and sort in Excel. The CSV files will contain one column I wish to use (It is the first one and the rest can be ignored or imported) and sort the desired data based upon the existance of a particular bit of text. Each entry will either be just a username or a username with a '-label' appended to it so for instance each of the CSV files might contain: bob fred mark-label ted angie-label Basically I want to seperate the names with the -label from the ones that do not have the -label. Doing searches, I was able to get part way using the code from this thread: [url] But am running into problems trying to modify it to suit my needs. Is there an easy way to accomplish this? I'm not very good with VB so that hasn't helped me. It would be nice to move the sourted output to seperate columns if that is possible.
View Replies!
View Related
Macro For Sorting Alpha-numeric Data
In column A I have alpha-numeric data similar to: 2 A1 3 A20 A186 B4 B13 1 C5 C3 And I need to sort them so that they are like: 1 2 3 A1 A20 A186 B4 B13 C3 C5 With the numbers first, in ascending order. Then the letters, grouped by letter ascending, and the number following them. But I can't have it where it looks at the first number after the letter (A1,A186,A20). It has to look at the WHOLE number and then sort it.
View Replies!
View Related
Group Data For Ranking & Sorting
I have a spreadsheet with a list of ID's in column A. In Column B I have a list of ratings. Each ID has more than one rating. For example there may be 8 rows with ID 1, 12 rows with ID 2, 6 rows with ID 3 etc...... I want to rank the ratings in Column B with highest being 1 but only when the ID's are the same. For example there would be 8 ratings ranked for ID 1, 12 for ID 2 etc..... The problem is I am running a monte carlo simulation on the rating of around 10,000 simulations. Every simulation the rank for each row will of course change because the rating has changed. The spreadsheet has around 70,000 rows and over 3000 ID's. How can I do this without either the computer becoming a crawl or freezing up and it not taking 30 minutes for each step of the simulation?
View Replies!
View Related
Sorting Data From Olap Pivot Table
i have generated a olap cube and display it using pivot table. But i am unable to sort my data from acsending order. For example: I had right clicked on my pivot table > field settings > Advanced > Select "Ascending". The data (sum of quantity) remains unsort after i have checked ok.
View Replies!
View Related
|
TRACKER
