Excel 2003 - Match Column A with Column B Column C to correspond to Column B

0 votes
The title is confusing but here is exactly what I have and what I need to do:

Column A has a list of numbers.

Column B has the same list of numbers in a completely different order.

Column C has a list of numbers that correspond directly with Column B.

Column B needs to be sorted to match Column A and during the same sort, the contents of Column C need be moved to stay with Column B.

Any ideas?
Mar 11 in Database by Edureka
• 13,640 points
782 views

1 answer to this question.

0 votes

Write a standard IF formula that compares the first two cells in Excel to compare two columns row by row. Copy the formula down to additional cells by dragging the fill handle to another column in the same row (a small square in the bottom-right corner of the selected cell). The cursor will change to a plus symbol as you proceed:

Copy the formula down to other cells to compare two columns in Excel

answered Mar 15 by gaurav
• 22,040 points

Related Questions In Database

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How to convert a column number (e.g. 127) into an Excel column (e.g. AA)

If anyone needs to do this in ...READ MORE

answered Mar 30 in Database by gaurav
• 22,040 points
175 views
0 votes
0 answers

How to display employee names starting with a and then b in sql

I want to display the names of ...READ MORE

Aug 12 in Database by Kithuzzz
• 20,660 points
153 views
0 votes
1 answer

Add a column with a default value to an existing table in SQL Server

Syntax: ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT ...READ MORE

answered Sep 12 in Database by narikkadan
• 37,660 points
217 views
0 votes
2 answers

Write a SQL query to find the names of employees that begin with ‘S’

Select ename From emp Where ename like"s%"; READ MORE

answered Oct 7, 2021 in Database by anonymous
16,095 views
0 votes
1 answer

Disable Sorting in excel

You may discover that adding a filter, ...READ MORE

answered Apr 5 in Database by gaurav
• 22,040 points
1,341 views
0 votes
1 answer

Disable Sorting in excel

To quickly sort, select the Sort A ...READ MORE

answered Apr 11 in Database by gaurav
• 22,040 points
127 views
0 votes
1 answer

EXCEL How to check if Column A contains specific value and Column B contains 2 specific values?

If you're looking for the string CHECK in cells ...READ MORE

answered Apr 6 in Database by gaurav
• 22,040 points
97 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP