pull data from one row if another row contains certain text

  • Thread starter Thread starter coasterdude
  • Start date Start date
C

coasterdude

Can someone please get me started on this? I have spreadsheet that I want to
pull text in one row of another row contains "Example".

A B C
1 45 Example
2 34 Blablabla
3 56 Example

Would return
45
56
 
Thanks. But I would I output this to another spreadsheet? I put this formula
in another cell and it only returns the first number (45). On another note,
autofilter will not work because I am looking for a string in row C, so I
will be searching for "*Example*"
--
Kevin


John said:
HI
Try this =IF(C1="Example",A1,"")
HTH
John
Click to expand...
 
Hi
The formula =IF(C1="Example",A1,"") is base on your sample.
It's made to be drag down as far as needed.
To do that, move your cursor to the buttom right side of the cell, you will
see your cursor change to a dark cross, click your left mouse button and
drag down. The result should be the same as your example.
Now you say :> But I would I output this to another spreadsheet? !!!
If you like the result on another sheet this maybe what you would like
=IF(Sheet1!C1="Example",Sheet1!A1,"").
This formula is referencing >Sheet1 and you would type this in another
sheet.
HTH
John

coasterdude said:
Thanks. But I would I output this to another spreadsheet? I put this
formula
in another cell and it only returns the first number (45). On another
note,
autofilter will not work because I am looking for a string in row C, so I
will be searching for "*Example*"
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for summing purchases and sales 8
adding rows into the table 1
Exporting to text file in multiple lines 3
Need macro to delete rows not containing certain text 0
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Horserace Form Revisited 2
Grouping in one row 2
How do I move entire row from one excel sheet to another 3

Back
Top