• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

FORMULA REFERENCING WHILE SKIPING ROWS

Dear Chandoo

i have two set of data in an excel sheet one id detailed one and another data below it which is a summary . i had filled in the data in detailed table and also have linked the summary table first product data with the detailed one but when i am dragging the cell to next product summary data it automatically change reference to the next row above but the data i want is after skipping 3 rows . so how can i do the same as if i mannualy do it it is around 600 products
 
Cabhupenderbhakuni


Firstly, Welcome to the Chandoo.org Forums.


Can you post the formula or data you are using so we can give you a specific answer

Read the post: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Back
Top