N neeraj2050 Member Jan 19, 2018 #1 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
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
B bosco_yip Excel Ninja Jan 19, 2018 #2 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
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
Deepak Excel Ninja Jan 19, 2018 #4 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.
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.
B bosco_yip Excel Ninja Jan 19, 2018 #6 neeraj2050 said: Can this part of formula be explained?? ROWS($1:1)),"0;;;@ Click to expand... =TEXT(formula,"0;;;@") >> using Text function to remove 0 resulted from the formula. Regards Bosco
neeraj2050 said: Can this part of formula be explained?? ROWS($1:1)),"0;;;@ Click to expand... =TEXT(formula,"0;;;@") >> using Text function to remove 0 resulted from the formula. Regards Bosco