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

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

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

20 responses
WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response