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 :(
0
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!
0

Similar discussions

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

20 responses
If cell = date return yes or no.
JD -
ndwebb -

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

2 responses
Excel "IF" function w/ date in test cell
Mike in PA -
salim -

6 responses
Excel: If Date =, then enter a value
JerrySD -
BrianGreen -

4 responses