Previous Topic Next Topic

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?

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

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response