If a cell in column contains "x", return the value

Closed

higgins227 - Dec 10, 2015 at 04:02 PM
higgins227 - Dec 10, 2015 at 04:03 PM

Basically I have a large spreadsheet and I want to pick out the values that I flag with an X. Not all of the rows have an x next to it, but the ones that do have an x, I want to return the value next to it. Like so:
Column A Column B Column C
1 x 1
2 3
3 x 6
4
5
6 x

What do I put in Column C to get what I want?

If a cell in column contains "x", return the value
Conditional formatting if cell contains text ✓ - Excel Forum
What function can automatically return the value in cell c77 ✓ - Excel Forum
Display two columns in data validation list but return only one - Guide
Excel if cell contains date then return value - Excel Forum
If cell contains date then return value ✓ - Office Software Forum

1 response

Answer 1 / 1

higgins227
Dec 10, 2015 at 04:03 PM

The sample I tried to make in the description didn't work :(

higgins227
Dec 10, 2015 at 04:03 PM

Imagine there is a space between the 2 and the 3, then look at each line as its own column. Thanks!

Similar discussions

Excel - IF function with multiple words

Looking For a Value in a Cell

help me to add particular cells

If a cell contains any text then add a value

WOW equipment return

Similar discussions

Subscribe To Our Newsletter!