Reference through formula

[neeraj2050]

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

 

[bosco_yip]

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

 

[neeraj2050]

Thanks Sir!!

Apart from that formula would there by any formula

 

[Deepak]

Dear Mr. Agarwal,

That seems best one!!
You may discuss any issue on that.

& If you are looking for dynamic sheet name & range consider this...

https://chandoo.org/forum/threads/update-sheet-name-with-reference.37034

Let us know if we fail to fulfill your dreams.

 

[neeraj2050]

Can this part of formula be explained??

ROWS($1:1)),"0;;;@

 

[bosco_yip]

Can this part of formula be explained??

ROWS($1:1)),"0;;;@

=TEXT(formula,"0;;;@") >> using Text function to remove 0 resulted from the formula.

Regards
Bosco

 

[neeraj2050]

Thanks a lot Sir!!