Ask a question
Report

# Excel question, if cell contains certain word [Solved]

Christin - Latest answer on Sep 23, 2010 09:49PM

Read more

Ask a question
Report
# Excel question, if cell contains certain word [Solved]

Christin - Latest answer on Sep 23, 2010 09:49PM

Read more

- Excel question, if cell contains certain word
- Excel - Sum value in column when cells contains certain text » How-To - Excel
- Excel - IF function with multiple words » Forum - Word
- If a cell contains any text then add a value (Solved) » Forum - Excel
- If cell contains certain text, add certain text in cell adjacent » Forum - Excel
- Conditional format based on another cell containing part of text (Solved) » Forum - Excel

suppose data is like this from A1 down to A9

a

ad1

1

s

ad2

2

d

ad3

3

now in sheet 1 in A1 type (or copy paste this formula)

**=(IF(ROW(A1)<=COUNTA(Sheet1!$A:$A)/3,OFFSET(Sheet1!$A$1,(COLUMN(A1)-1)*3+ROW(A1)-1,0,1,1),0))**

copy A1 both down and to the right till you get 0

delete 0s. do you get what you want?

In sheet1 now you are having 3 sets of data. you can have as many sets as you like but in each set the first is name, second address and third phone no;.

a

ad1

1

s

ad2

2

d

ad3

3

now in sheet 1 in A1 type (or copy paste this formula)

copy A1 both down and to the right till you get 0

delete 0s. do you get what you want?

In sheet1 now you are having 3 sets of data. you can have as many sets as you like but in each set the first is name, second address and third phone no;.

there was a typo in my answer. the formula is to be copied in A1 of SHEET2 repeat sheet 2 .

I have parked this file )"christin.xls" in the following web page. download the file and see.

**http://www.speedyshare.com/files/24385259/christin.xls**

see sheet 1 for data and sheet 2 for results. see the formula in A1 of SHEET2 IN THE FORMULA BAR.

I have parked this file )"christin.xls" in the following web page. download the file and see.

see sheet 1 for data and sheet 2 for results. see the formula in A1 of SHEET2 IN THE FORMULA BAR.

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.