- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Excel question: How do you compare values in two columns?
Posted on 1/26/17 at 7:31 pm to euphemus
Posted on 1/26/17 at 7:31 pm to euphemus
Sort both A and B by value.
Create column C that is A - B.
Sort all 3 columns by column C value.
Duplicates will have a value of 0 in column C so delete all rows that have a value of anything other than 0.
Create column C that is A - B.
Sort all 3 columns by column C value.
Duplicates will have a value of 0 in column C so delete all rows that have a value of anything other than 0.
Posted on 1/26/17 at 7:34 pm to euphemus
If you just want to see the rows that have values in columns A & B use filters. Filter out blanks in both columns
Posted on 1/26/17 at 8:22 pm to euphemus
Vlookup and reverse Vlookup. What in column A that is in column B and vise versa. Hold your values absolute with dollar signs.
=vlookup(cell to lookup,table array,expected column output,false)
1 2
2 1
3 5
This would return a result for 1, because you based the formula on column A, and it found 1 in column B.
=vlookup(cell to lookup,table array,expected column output,false)
1 2
2 1
3 5
This would return a result for 1, because you based the formula on column A, and it found 1 in column B.
Posted on 1/26/17 at 8:25 pm to euphemus
If I have your question correct...
Column C: =IF((A2 <> "") && (B2 <> ""),A2 & " " & B2,"")
then drag down
Column C: =IF((A2 <> "") && (B2 <> ""),A2 & " " & B2,"")
then drag down
Posted on 1/26/17 at 8:26 pm to euphemus
Anytime I come across something in Excel I don't know, I use the help feature in Excel.. More times than not it helps me out.
Posted on 1/26/17 at 8:57 pm to Chinese Bandit
quote:
Chinese Bandit
Thank you. That worked our perfectly.
Popular
Back to top
Follow TigerDroppings for LSU Football News