- Excel question, if cell contains certain word
- Conditional format based on another cell containing part of text (Solved)
- Excel - IF function with multiple words
- Excel - Using IF statement to add 1 to total
- Copy data onto sheet only if cell has text [Solved] (Solved)
- If a cell contains any text then add a value (Solved)

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.

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Kym- Dec 29, 2015 at 11:55 AM