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
87 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
• 13,460 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
• 13,460 points
34 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
13,013 views
0 votes
1 answer

How to drop all tables from a database with one SQL query?

Use the INFORMATION_SCHEMA.TABLES view to get the ...READ MORE

answered Feb 4 in Database by Neha
• 8,560 points
117 views
0 votes
1 answer

How to rename a column in a database table using SQL?

For SQL Server, use sp_rename USE AdventureWorks; GO EXEC sp_rename 'Customers.CustomerTerritory.TerritoryID', ...READ MORE

answered Feb 9 in Database by Neha
• 8,560 points
67 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
• 13,460 points
138 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
• 13,460 points
49 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
• 13,460 points
35 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP