Sorting Info In A Column
Apr 17, 2009I need to sort information in a column containing both numbers and words. In the "asending" & "desending" it only gives two options to choose from. (none) & PartNum.
View 14 Replies
ADVERTISEMENT
Sorting! I Have 1 Column W/all The Info. Together. To Make It Into Separate Tables
Sep 22, 2009I have 3 status sheets (about 300+ ea.) that I was given to sort out.
Information:
1) Column A: Number of items (i.e. 1 )
2)Columbe B: Rec'd Date + initials + no. of copies received, followed by notes (i.e. 021709,akb,01)
Since there is only one column with all the information together, is there a way to sort the attached sheet by initials? I don't know how to create a formula to pull all the date,mjg's; date,jac's; date,akb's; etc... into a separate table.
A: No. of items
B: Date,mjg... = Total no. of items
C: Date, abk... = Total no. of items
D: Date, akb... = Total no. of items
Keeping Info Together While Sorting
Oct 24, 2008I have groups of information I need to stay together, but I'd like to be able to sort them by last name. Today, Tomorrow and Long Term are conditionally formatted (=ISBLANK is green and =ISTEXT is red). As long as the information stays together in a group, that won't be a problem. I have a hidden column A where every cell next to the form refers back to the cell with the last name in it. But when I tried to sort by that, it still seemed to mangle my form. There are no merged cells here. There will eventually be dates, locations (booked) and absent, etc.. filled in. I just want to be able to sort this entire block, without changing anything in it, by last name. There are about 100 of these blocks of info.
LAST NAMEFIRST NAMETodayTomorrowLong TermDATEBOOKEDReason for SubAbsent EmployeeHours is WorkingDayHappyPhone Number:555-5555Cell Number:555-1234Special Skills:Notes:
Sorting Info From A WS To Multiple Worksheets
Sep 30, 2009Here's the issue: I have a spreadsheet with 12,000 contacts in it (name, email, phone number, country, industry, etc etc). The sheet is kind of messy, and I want to clean it up. One way thing I want to do is organize it. I want to sort the Master sheet into other worksheets, and I would like to do this Industry.
Is there a way to make excel register when a contact is in a certain industry, and then subsequently move that contact into a sheet? I tried playing around with If/Then functions, but I think this is a job for a macro/VB expert.
Match Names In Two Separate Column If Equal Then Pull Info In 3 Column?
Dec 6, 2013I need to look up the name in E2 in the list in column A and if it matches then lookup name in F2 in list column b, if it matches then the corresponding number in column C is displayed in column G. If neither names are in the 2 columns the words"Not on lists" is displayed in cell in column G.
The other problem is one name is spelled two different ways I want it to look for both spelling before moving on to looking up the second name.
I started with this formula but I'm getting #N/A or "not on list" when they are on the list. I'm using ranges prod_sum is columns AthruC, Last_name is range BthruC. =IF(AND(VLOOKUP(F4,prod_sum,3,0),VLOOKUP(I4,last_name,2,0)),"not on list")
Move Info In One Column Based On Data In Another Column
Aug 28, 2012I am trying to move a column of numbers based on the information in another column. I've been looking for about a week and find macros that are close but not quite.
In one column it reads Mobile, Home, or is blank. If the number is a Mobile (column R), the area code (column P) needs to move to column S and the phone (column Q) needs to move to column T and the primary phone (column R) needs to move to column U. Home and blank cells remain as they are.
area (P)
phone (Q)
primary phone (R)
col S
col T
col U
[code]....
Removing Information From Column A With Associated Info From Column B
Jan 17, 2008I am attempting to Organize some data; however, I have run into a problem. I will paste a sample of the data that I have and explain the situation....
View 9 Replies View RelatedPulling Info From Column
Jul 8, 2014I'm copying and pasting data from a PDF and need to eliminate some unnecessary data. The original .pdf has 4 columns: Account, Dollar Amount, Name, Notes
When I copy this to an excel document, it copies the row from all 4 columns into column A. The two columns I need are Account and Dollar Amount. All account numbers are 8 digits so I was able to create a formula to weed that out with this: =left(A1,8)
The problem I'm running into is obtaining the dollar amount within the cell. For example:
A1 contains: 11112222 $1234.56 Sample, Name Sample Note
I pull the 11112222 with =left(A1,8) in column B but not sure how to pull dollar amount to column C.
Further, the dollar amount varies from $1.01 to $10,000+
Fill Info In Sheet One And Have Same Info Appear In All Sheets That Follow
May 12, 2014I would like to fill in a a form on page /sheet one and have the same info on every sheet that follows is it possible?
View 3 Replies View RelatedHow To Fill Vertical Columns With Info From Horizontal Info
Aug 22, 2014I have attached a spreadsheet and I am trying to capture the info in lines 2,7,12,17 and return the info into column d,e,f,g
The info in these columns at present has been manually entered but I am sure it could be automated.
OOL Roster Final 18-31Aug14.xlsx
How To Find Where Info In Column A Is Repeated
Apr 9, 2008I have three columns
"A" is item number: "B" is sales Date: "C" is sales price.
What I would like to do is search column A and when there are two of the same item numbers know what date they sold and for what price. I would prefer to build another table that has only this data.
Extract Row And Column Info From .address
May 21, 2009The following code sets foundcell.address
View 2 Replies View RelatedHow To Split Info In Cells / Column
Feb 13, 2012I have data that I've converted from a different source, and the formatting doesn't always come out as I'd like it. For example, I have data that has two different values, and I need to split them into different columns. Is there an easy/quick way to do this?
15* 27016* 1324517* 2086518* 24943
Formula To Move Info From One Column To Another
Nov 13, 2006I need a formula that will take the value of one cell and put it in another cell other than the one in which I am typing the formula. I can't think of how to do this.
I have two columns, A & B (no headers), of information. The columns are not identical, and column B has empty cells scattered throughout the column. For each empty cell in column B, I want to copy the same row of information into it from column A, as if I'm just scooting the information in column A that's on the same row as the empty cells in column B.
This is simple with a cut/paste, but when there's thirty empty cells, cutting and pasting takes time. (What's really frustrating is that I've figured out a few formulas that will copy the information from column A but all the information gets pasted in the column in which I'm creating the formula (say, column F, for example). THAT doesn't help me because the empty cells in column b are still empty!)
Sort Info In Column Into 50 Row Blocks
Jul 20, 2007I have a sheet with about 1000 rows of data filling 40 columns. the data is the same in column 1 for a random number of rows between 2 and 40. ie as here...
2
2
2
2
33
33
33
4
4
4
4
4
4
etc.
Is it possible with a macro to divide the sheet into blocks of 50 rows each with just the data before it changes to a different no.
so that it looks like this
2
2
2
2
46empty rows here.......................
Moving Info From One Column To Two Separate
Jun 10, 2009I have:
A1: Ph#
A2: Name
A3: Ph#
A4: Name
etc
I would like:
A1: Name B1: Ph#
A2: Name B2: Ph#
etc.
This is a large spreadsheet so I was hoping there was an easy way to make this change.
Show Info In Column C, If A & B Match Criteria
Aug 20, 2009What I'm having a hard time is trying to get information from column C to pull into a cell, for a specific student (column A), but only when the entry happens between two set of dates (column B).
Column A = Student Name
Column B = Entry Date
Column C = Entry
So in a different worksheet, the names of the students will already be on the report and each column following will have a date range of a week. So for column B I want the entry that only happened between "09/07/09-"09/13/09". No student will have more than one entry a week so I just want it to locate the entry and fill in automatically. This will repeat for each week after as well.
Convert Binary Info In A Column To Decimal?
Mar 17, 2014 I am trying to convert 14 to 15 digits lengthy Binary value to number.
The formula =BIN2DEC(A2) is giving error #NUM
101111100001010
101111100001010
101111100001010
101111000011100
101111000011100
101111000011100
110001000001010
Formula To Copy Info In Column To Rows?
Mar 20, 2014In column A I have Product Codes, They start at A3 and go down to A169.
I need to have a formula which i can drag across from CQ3 to DH3 which corresponds in the following manner.
CQ3 = A4
CR3 = A5
CS3 = A6
etc etc.
I then want to be able to copy the formula into another place, eg CQ20 = A21, CR20 = A22 etc
I have attached a screen shot.
Untitled-1000.jpg
Import Comma Delimited Info In A Column
Mar 4, 2006I have hundreds of email addresses listed in a Wordpad file- entries are
separated by a comma. When I use the Excel Import function, all data is
successfully imported into an Excel spreadsheet- BUT in a single row. I would
like to have this info in a single column (A)- then I could easily
alphabetize the entries and eliminate duplicates.
VBA To Capture Info Using Filter On Specific Column
Jan 30, 2014I'm trying to add code to an existing macro that is working well to add a feature.
As it sits now, my code produces a worksheet tab called "Matrix" that has headers in row 1, a variable length list of employee names in column 1, and then a variable number columns with data crossreferenced by name in the body of the spreadsheet. Not every row/column intersection has data, some are blank if the ItemXname does not apply to that individual.
What I want to do is select all the cells on this spreadsheet, apply a filter, and then filter based on the selection of names in column 1. But I want to do this using VBA, where the macro runs, it asks the user if they want to filter on one or more names. If no, then it skips this part. But if yes, then the next thing they see is the filter window like they would see if you did this manually. After making their selections and hitting ok, the VBA routine would then take their selections (some finite number, but could be 5 -10 names) and process the rest of the macro accordingly.
Find Value And Then Copy Info From Previous Column
Feb 15, 2010I have a spread sheet with bunch of rows and columns. Columns goes all the way from A ... BB and rows from 1 to 40,000
The main focus is column Y and AC
If there is a value of FALSE found in column Y then macro should go to previous row and copy the value that contains in column AC and then move down to the next row, , where the value FALSE was found and that's in column Y and paste that value in column AC the NUMERIC VALUE
Below is the data ...
Match Data From Another Column And Populate Info
Mar 21, 2007I am trying to match info from one column with another column and if it matches, I need the formula to populate the relevant data from the adjacent column. I using Vlookup and I am not sure why it does not work. I have attached a simple example.
View 2 Replies View RelatedConditional Formatting - Use Info From 2 Columns To Format 3rd Column
May 24, 2014conditional formatting in Excel. I have two columns with pertinent information. I need to know the following and format accordingly:
1. Is the number in column A positive or negative?
2. Is the number in column B less than 0.05 or 0.10?
I would then like Column C to just be highlighted a certain color depending on the combination... there are 5 possible combinations and I would like the cells to be formatted so that:
1. Positive and less than 0.05 - Bright yellow
2. Positive and less than 0.10 - Pale yellow
3. Negative and less than 0.05 - Bright green
4. Negative and less than 0.10 - Pale green
5. This "combo" just means the criteria wasn't meant... which is possible b/c sometimes Column A may have text instead of a number of b/c the number in column B is not less than 0.10. If either of these is true, I want the cell to remain blank.
Scan Row For Text - Return Row And Column Header Info
Jun 2, 2013I've been using a nice colorful spreadsheet to use to schedule rooms for an organization. Visually it has worked out well but now I need to automatically generate a 'report' using that data. So...
I want to scan each row of a table and create another table with that data transformed.
That is, scan each row and whenever I find any text in a cell I want to return that text (the room being used) as well as the row and column header information (who is starting to use that room and on what date). I've attached a jpeg to show the example.
Ideally, when I scan the row and find text to return the headers I'd like the row scan to also find when the fill color changes and return that column header, too as that that would be the date that the room stops being used.
Formula To Match A Date And Once It Does The Info Stays In That Column
Mar 9, 2008I would like for the result of a formula to stay in the cell even after the first cell changes.
in cell G1 I use this formula, if(C1=D10,A1,""), I would like result of formaula to remain in G1 even after C1 is changed.
Find SUM Of Parts Of A Colum That Relate To The Info In The Column Beside...
Nov 26, 2008I am using Excel 2008 for Mac. I have a spreadsheet that I am essentially using as a simple cheque ledger so that I can keep track of who I have written cheques to, for what amount, and what has already cleared. I have a the following columns:
Name
Date Written
Cheque Amount
Cleared?
In the 'Cleared?' column I mark an X when it has cleared the bank. I'm trying to find a way to get the SUM of the whole 'Cheque Amount' column that hasn't cleared (ie: has nothing in the 'cleared' column).
VLOOKUP - Copying Info From One Workbook To Another And Populating A Column
Feb 18, 2014I am working on two worksheets, in different workbooks. They are both lists of customers and Worksheet 1 is 2500 rows & contains up to date data & Worksheet 2 is 20000+ & includes some that is outdated. Worksheet A data is all contained within worksheet B but I need to be able to update/compare them.
Each customer in worksheet A has two unique identifiers but in B there is only one. I want to be able to add in the missing unique identifier (numeric) from A to B, which will identify which customers are still active from worksheet B.
I have been trying to do a VLOOKUP so I can insert the relevant data from the cell from A to B but I'm getting a N/A error. My formula looks like this:
=VLOOKUP('[Netsuite customer details 17feb14.xlsx]Customers'!$B$2,'[Netsuite customer details 17feb14.xlsx]Customers'!$A$2:$BE$2549,2,FALSE)
Lookup 2 Criteria And Return Info In Specific Column
Feb 8, 2008I've got a database that is sorted by date...
I need a formula that will look for 2 criteria and once it finds those 2 matching criteria, I need it to return the information on that line that's in column 6, let's say.
so in one column I have the date, the next column I have the sales persons name, 4 columns over I have their order number.
In cell a1 of worksheet 1, I have a drop down ready that has all my sales persons listed. In cell a2 I will manually enter the date that I need to reference.
I need the formula to then look for cell a1 and a2 in worksheet 2 where I have my spreadsheet with the info I mentioned above, match that criterium in worksheet 2, and return the info in column 6.
Excel 2003 :: Selection Column To Transfer Info To Another Workbook
Sep 14, 2012I have a workbook that has multiple functions. One of these function is that when the user select a key word from a drop down validation list, a VB code transfer all information from that row from Column A to column W to the next available row on another tab.
VB:
If Not Intersect(Target, Range("X:X")) Is Nothing And Target.Cells.Count = 1 Then
Application.EnableEvents = False
If LCase(Trim(Target.Value)) = "yes" Then
[Code] ....
Is there a possibility to transfer this information into another workbook. Instead of transferring the info to a tab name "Archives" to transfer in another workbook. This workbook will only have one tab called "Archives".
This will minimize the information within my Initial workbook in project.
The path in the new workbook where the information should be transfer should be in:
"C:Documents and Settings"username"My DocumentsMy Data Sources" to an excel workbook that will be named Archives.
I know that the "Archives" workbook need to open then close after the information has been inserted...