Organizing Data For Sorting?

Jun 27, 2013

I'm looking for a opinion on what might be the best way to organize some data for sorting later.

I work for a company and we have a lot of equipment. I have a spreadsheet with each piece of equipment in a row. Column A has the equipment name with all the following columns having info about the equipment. One example would be voltage, some equipment runs at 120v and some runs at 208v, some runs either or and some runs at other odd ball voltages, although this is rare. I am trying to determine what the best way to enter data like this would be. Would I be better off entering one column labeled voltage and filling in the voltage, but this becomes problematic when a piece of equipment can run multiple voltages. The other though is to do multiple columns, one labeled 120v, one 208v, one 480v or whatever and go from there. Than put a "X" or Yes or something in the columns that apply.

I have this same scenario for multiple variables like connectors, hardware accessories and things like that. I am trying to think this through before entering all my data of what could be the negative effects of this.

Would it be possible/make sense to do a radio box?

My end result is hopefully to be able to say I want a piece of equipment that meets multiple scenarios like runs 120v, this accessory and this connector. Ideally setting up some sort of easy sort method in my column headers.

View 2 Replies


ADVERTISEMENT

Organizing Data In Spreadsheet?

Nov 26, 2013

I have a spreadsheet converted from pdf having more than 30 Columns .for Example( name, address, tel. website , products etc).

Problem is that data is not consistent in all columns.Some have full range(all 30+ columns having data) and in some not( only some columns having data )

I want to organize data as per headers and leave cell blanks or fill in (N/A) where data is not available for that field. How can I correctly populate it.I need data as per headers in rows.

Here i am dealing with 2k rows with 30+ columns.

View 3 Replies View Related

Storing And Organizing Data

Jul 11, 2014

I'm setting up a type of form in excel where I have some validated drop down lists and I'm trying to use a macro that will, upon a button click, take the data from the drop down lists that are entered into the boxes, and organize them into a chart on a different sheet of the document. This would be the form with some drop down lists.

Juice Type
Apple

Juice Size
8 oz.

Juice Buyer
Ronald

I want to add it in to a table with every button click filling in a new row in a table like this,

Juice Type
Juice Size
Juice Buyer

Apple
8 oz.
Ronald

View 3 Replies View Related

Organizing Data Table In A Bar Chart Layout 5

Jan 31, 2014

I have a bar chart that monitors month over month activity. I use Layout 5, which allows for the numbers data to neatly be organized in a table below the bar chart. However, i recently started using the data on a secondary axis to accurately reflect trend lines. It works great, but now the data table below displays redundant information. see attachment.

example.jpg

I just want that data in the data table to be displayed once, completely leaving of the axis legend.

View 2 Replies View Related

Schedule, Organizing

Oct 15, 2008

I make our employee schedule at work, and so in Excel I have eight sheets for one workbook. (Employee schedule, then each day of the week) On each day is a table separating the shifts. Morning, Split and Night.

I was wondering if there was a way for Excel to look at the schedule sheet, and then automatically place each employee and their shift on the following day sheets. (example: Joe has 2-10 on Monday, 10-6 on Thursday and Friday) So the Excel puts Joe underneath Split 2-10 for Monday, and Morning 10-6 on Thursday and Friday.

View 10 Replies View Related

Organizing A List

Jun 8, 2006

I have attached a file that I need a little guidance on. The list of information on the left needs to be organized and put in the appropriate tables on the right. Each row represents one person and I need to know how many people from the list fall into each category. For example: The first row has a gender of "1" and the age is "46" and the status is "1". Therefore, this person falls into the category associated with "K11", I filled it in already. My list will vary in length from 20 rows to 20,000. I am not sure how to go about this and have been frustrated by failed attempts.

View 6 Replies View Related

Organizing Files Using Macro

Nov 16, 2011

I have a list of 35k files and the number of files keep changing every week. At the end of the month I manually have to sort the files i.e move files to the respective folders, delete them or take no action. This takes me an entire day. There are useless files which needs to be deleted.

Si NoFile nameFile PathNew PathAction

1Store C:Jay PersonalDesktopRXProjectSix SigmaStore.xlsC:Jay PersonalDesktopNewProjectSix SigmaMove

2AppointmentC:Jay PersonalTeam QualityAppointment.pptC:Jay PersonalTeam QualityAppointment.pptDo Nothing

3QualityC:Jay PersonalDesktopRXProjectSix SigmaQuality.docDelete

The format is as follows. File name is the file which I intend to move, File path is the current file path, New path is the path where I want the file to be moved, Action (Move, Do nothing, Delete) is the action i intend to take on the file.

View 3 Replies View Related

Organizing Worksheets In A Workbook

Apr 19, 2007

Is there a way to sort the worksheets in a workbook after they have already been entered. My clerk put 200+ worksheets in one workbook....out of order.

View 7 Replies View Related

Organizing Cells From Lead Sheets

Sep 11, 2013

I have a question on how to organize cells from lead sheets that I load inside excel, when it loads it shows as is:

Name, Last, Address, City, State, Zip, Phone #

I need it to be organized so when I print they read:

Name
Address
City, State
Phone#

Instead Of them All together in a landscape view.

View 1 Replies View Related

Organizing Numbers From Column Into Sum Table

Dec 31, 2011

I'm looking for a formula that would arrange the numbers from column K into the sum table, according to their sum total from column L, the formula should begging in cell P3 to maybe T3 and down to T30 I suppose ?

KLMNOPQRSTU1NumberSum Sum Table     2 
30235 0       40246 1       50279 2       602810 3       702911 4       80347 5 023     903710 6 024     1003811 7 034     
1103912 8       1204711 9 027234    1304812 10 028037    1404913 11 029038047   1507815 12 039048237   1607916 13 
049238247   1708917 14 239248347   182349 15 078249348   1923712 16 079349    2023813 17 089278    2123914 18 279     
2224713 19 289478    2324814 20 479     2424915 21       2527817 22       2627918 23       2728919 24 789     2834714 25       
2934815 26       3034916 27       3147819         3247920         3378924         34

View 9 Replies View Related

Organizing Multiple Excel Sheets?

May 13, 2014

I am in process of making an appraisal system for my organization through excel templates .Each employee will Have 2 KRA templates .One specific to their roles and other in the area of their interest.

So while rating i will select role of the person and his interest area.Then the comprehensive template integrating both templates should be generated from the master templates which are in place.If i make any edits in Integrated template,it should not be reflected in master templates

View 2 Replies View Related

Inserting Blank Row And Organizing Time-column

Jan 31, 2009

I'm a novice in VB and can't work out how to solve the following problem:

I have imported NMEA-data in text format from a GPS into Excel. This data is acquired in real-time at 10Hz, which borders what the GPS in capable of calculating. As a result the data isn't quite reliable enough - there are strings missing and some lines have been skipped by the GPS. This is a typical example of what sometimes happens: ...

View 15 Replies View Related

Code For Organizing A Worksheet By Rows: Not Running

May 13, 2009

Sub SplitOut()
Dim DataSH As Worksheet, OutSH As Worksheet
Set DataSH = Sheets("Input")
DataSH.Activate
lastrow = Cells(Rows.Count, "D").End(xlUp).Row
For Each ce In Range("D2:D" & lastrow)
Application.StatusBar = "Actioning " & ce.Row & " of " & lastrow.............

I am working on this spreadsheet that has a lot of information that will only get bigger as time goes on. I would like to organize the contents of one column into separate spreadsheets. So if I have "stacking" in one cell of that column, the whole row associated with that cell will go to a new spreadsheet labeled "stacking".

I have attached the sheet. I would like column D (Type_Code) to be organized by the words in that column. So I would have 5 or so worksheets labeled stacking, cartoner, wheel, inspection, etc. The data here is input by a machine.

View 3 Replies View Related

Excel 2010 :: After Applying A Data Filter And Sorting The Data / How To Revert Back To Original

Dec 20, 2012

I'm using Excel 2010 and I applied a Data Filter to a simple table. I then messed around with the drop downs in each column, sorting the data by different criteria. After doing this, is there a simple way to get the table to revert back to its original order/form?

View 3 Replies View Related

Macro - Sorting Data To Other Worksheets / Update As New Data Entered

Jan 30, 2014

I am trying to create a "Master Sheet" where I enter in the column data and after I have entered my data for each row, I can select the button which toggles the macro to run. I have it built to build new sheets as new clients are obtained. My problem is after I have a sheet that has client's data I cannot get new data to add itself below the data that is already there. I want each client's sheet to keep adding rows as more data comes in. My current macro is :

[Code] .....

Attached File : Data Entry Macro.xlsx

View 3 Replies View Related

Sorting Pasted Data By Recognizing Data As Dates

Oct 26, 2013

I copy/paste the data from this website [URL] ........

How I can sort all the data based upon the "Date"? The date data is not recognized when I copy/paste.

View 1 Replies View Related

Auto Populate Data After Sorting The Data

Sep 26, 2009

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 10 Replies View Related

Sorting Data Out

Jan 12, 2008

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 9 Replies View Related

Sorting Data In VBA

Mar 14, 2009

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 11 Replies View Related

Sorting Data Using VBA

Jun 30, 2009

I use my VBA code to sort the data in certain columns. I have been doing it with the following

View 4 Replies View Related

Sorting Out Data

Nov 16, 2006

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 9 Replies View Related

Sorting Data In A Table Using VBA

Aug 14, 2012

I am trying to create a macro where users can rearange data in a table. I used the macro recorder to sort the data in colmn C in descending order and this is the code that I got:

VB:

ActiveWorkbook.Worksheets("By Client").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("By Client").Sort.SortFields.Add Key:=Range( _
"C3:C176"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("By Client").Sort

[Code]...

This works for the table as it is but the range may change as more rows are added to the table. I want it to start at row three as the first two rows are headers but in future tables the bottom row may not be 176. I dont want to include all rows as row 177 contains totals that I dont want to be included in the sort. what I should put as the range so that this macro will work regardless of how many rows are in the table?

View 3 Replies View Related

Sorting Increments Data?

Mar 19, 2014

I attached document, in that document I made formula in Pressure cell which is INDEX MATCH MATCH to get the result.

But what I wanted is, when I type 10.4 in Temperature cell, the Pressure cell will show the result which is 1261.24 directly without I have to fill in two temperature cell to make it 10.4.

View 11 Replies View Related

Subtotals And Sorting Data

Apr 24, 2014

I have sorted my data by three layers. First by Budget Center, then Invoice, and then Account. I am having trouble writing a formula that will total the amounts by account with respect to its invoice and budget center.

excel forum2.xlsx

View 4 Replies View Related

Data Consolidation And Sorting

May 15, 2014

I have A spreadsheet.

The spreadsheet contains 8 worksheets, of which I am only concerned with 7 as the 8th merely presents a graph.

The first 6 worksheets all contain raw data exported from BMC Remedy indicating the names of users who logged incidents to have their passwords reset or their AD Accounts unlocked over a 6 month period, hence 6 worksheets (per month basis).

The 7th worksheet contains raw data from another application known as FIM (A MS based interface which allows users to reset their own passwords) indicating all users who are registered to utilize this functionality.

The goal of my exercise is to consolidate the data and sort it to such an extent where I can ascertain which users phoned the service desk to log an incident for a password reset, even though they are registered to do it themselves via FIM ... I have been going through the list manually and it took me 10 solid hours to go through 265 ... ... ... ... I have 3'900 to go through!

View 1 Replies View Related

Sorting Data Into Several Columns?

Aug 14, 2014

I have an issue with some data that I need to sort into several columns. Basically, I have a column that has data listed in each cell like this; A 567 T 1 D3. What I want to be able to do is sort that data into several columns. I am not sure how to do this at all. I have attached my data to be looked at. I have already started the process but manually, and I don't feel like having to do this manually as this is very time consuming considering I am trying to sort the data into ~1927 rows and 5 columns.

View 2 Replies View Related

Separating Or Sorting Data

Sep 22, 2008

for example:

Column A.

@yahoo.com
@hotmail.com
@live.com
@msn.com
@yahoo.com
@hotmail.com
@live.com
@msn.com

how can i separate all datas by domain without having to cut and paste them manually.

View 7 Replies View Related

Repeat Data Sorting

Nov 24, 2008

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 12 Replies View Related

Categorizing And Sorting Data

Jul 3, 2009

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 7 Replies View Related

Sorting Data Into Columns

Aug 5, 2009

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 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved