Great solution Sandeep.I'll make good use of that going forward.
I did a work-around using VBA before I noticed this reply... I made 3
clear columns at the front of the spreadsheet and pasted the data I
needed there. With everything sorted the same way, I then ran this bit
of code:
Sub Tmp_BumpDown()
Dim iRow, iColumn As Integer
iRow = 2
iColumn = 1
Do While Cells(iRow, iColumn).Value <> ""
If Cells(iRow, iColumn).Value <> Cells(iRow, iColumn + 3).Value
Then
Range(Cells(iRow - 1, iColumn), Cells(iRow - 1, iColumn +
2)).Select
Selection.Copy
Selection.Insert Shift:=xlDown
End If
iRow = iRow + 1
Loop
End Sub
The vlookup method is a lot simpler, more reliable, and more flexible
to different situations though.
Thanks!
On Oct 6, 7:59 pm, Sandeep Kumar Maurya <sandymau...@gmail.com> wrote:
> Hi,
> I used vlookup( ) for this. See the attached solution.
>
> Regards
> Sandeep
>
>
>
> On Wed, Oct 7, 2009 at 2:34 AM, HumanJHawkins <jhawk...@locutius.com> wrote:
>
> > I have a list of 15000 rows of response data about questions that
> > showed up on a series of tests. There is often more than one row for
> > each test question, because each question was used in more than one
> > event.
>
> > So the data may be like:
> > 1 A 3.33
> > 1 B 2.99
> > 2 A 1.11
> > 2 C 1.13
> > etc.
>
> > Unfortunately, I need to match up a different type of ID to each row.
> > I have a table of ID translations that looks like this:
> > 1 N23
> > 2 O12
> > etc.
>
> > What is the easiest way to relate these two sets of data so I get a
> > table like this:
> > 1 N23 A 3.33
> > 1 N23 B 2.99
> > 2 O12 A 1.11
> > 2 O12 C 1.13
>
> > Thanks in advance for any suggestions.
>
>
>
> Solution_using_vlookup.xls
> 24KViewDownload
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
