Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search function
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search function
Den torsdag den 21. november 2013 06.42.52 UTC+1 skrev Nitya Satheesh:
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. Hi. the formula could look like this: =IF(AND(ISERROR(FIND(LOWER("SP"),A3)),ISERROR(FIND (LOWER("SP"),B3))),0,1) https://dl.dropboxusercontent.com/u/28273423/Book1.xlsx Steffen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search function | Excel Worksheet Functions | |||
Search function | Excel Worksheet Functions | |||
Search function | Excel Worksheet Functions | |||
How do I add a search function? | New Users to Excel | |||
Search function | Excel Discussion (Misc queries) |