search function
On Monday, November 18, 2013 12:34:11 PM UTC+5:30, Nitya Satheesh wrote:
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.
|