search function

N

Nitya Satheesh

Hi!

I have data across the worksheet that I need to consolidate into one row.
For eg:

Column1 column2
sp a act a
sp b act b
act a sp c
act b sp d

I need a column to show the digit 1 for every cell that has "sp" in it. Basically i need to group the data which contains"sp" into one column.

Any ideas?
 
N

Nitya Satheesh

Hi!



I have data across the worksheet that I need to consolidate into one column.

For eg:



Column1 column2

sp a act a

sp b act b

act a sp c

act b sp d



I need a column to show the digit 1 for every cell that has "sp" in it. Basically i need to group the data which contains"sp" into one column.



Any ideas?

sorry I need to consolidate data into one column not row.
 

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

Top