• 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.

Reference through formula

Greetings!!


I have data into “Raw Sheet” and the desired result into “Result” sheet

I want to develop a formula to do so.

Please suggest

Regards

Neeraj Kumar Agarwal
 

Attachments

  • EXCEL QUERY.xlsx
    10.1 KB · Views: 8
Try,

In H1, formula copied across right and all copied down :

=TEXT(INDEX('RAW DATA'!$A$7:$C$12,COLUMNS($A:A),ROWS($1:1)),"0;;;@")

Regards
Bosco
 

Attachments

  • EXCEL QUERY(1a).xlsx
    10.3 KB · Views: 7
Back
Top