Cant fill formula down in a search engine sheet

Thanks for changing the title.

Post #15 in the thread that you have linked to points out that the formulae in cells C:K of the Search sheet have been copied down to row 100 as an example - you will need to copy these formulae down further if you have more data.

Hope this helps.

Pete

I can't tell what's wrong from a picture - please attach the Excel workbook (or a small version of it) instead.

Pete

Here it is

There are formulae all across the columns in the Search sheet - you had just copied the formula in column A down a few rows. I have copied them down to row 150 in the attached workbook, by highlighting row 100 then < copy >, then selected rows 101 to 150 and pressed < Enter >. You can repeat this if you have more data.

Note that you are using the XL2003 version of this file from the link you provided earlier, although you are using formatting that was not supported in that earlier version. You will find the formulae more efficient in the .xlsx version of the file (using IFERROR rather than IF(ISERROR... ). I have saved the file as an .xlsx, though I have not changed all the formulae.

Hope this helps.

Pete

Originally Posted by Pete_UK

There are formulae all across the columns in the Search sheet - you had just copied the formula in column A down a few rows. I have copied them down to row 150 in the attached workbook, by highlighting row 100 then < copy >, then selected rows 101 to 150 and pressed < Enter >. You can repeat this if you have more data.

Note that you are using the XL2003 version of this file from the link you provided earlier, although you are using formatting that was not supported in that earlier version. You will find the formulae more efficient in the .xlsx version of the file (using IFERROR rather than IF(ISERROR... ). I have saved the file as an .xlsx, though I have not changed all the formulae.

Hope this helps.

Pete

Thanks alot

You're welcome - glad to be able to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete