Search results

sorry bro here is the correct one . please do for me!!! here is the link: http://speedy.sh/rz7Fz/Book2.xlsx

PLEASE KINDLY DO FOR ME I M SENDING ma file. here is the link http://speedy.sh/BxAfz/Book2.xlsx

I could not understand where (index no ) is formula is to put ? =IF(COLUMN()-COLUMN($A$2)+1<=COUNTIF($B$8:$H$8,"<>"),INDEX($B$8:$H$8,SMALL(IF($B$8:$H$8<>"",COLUMN($B$8:$H$8)-COLUMN($B$8)+1),COLUMNS(A$2:$A2))),"") please help!!!

here the logic is ist row has numbers and i want to take the header name ( ie ti , E-125 , etc) from ist row which has value ( number) grater than zero in a column . example : T1 T2 T3 T4 T5 T6 T7 E-117 E-120 E-125 E-124 0 2 0 0 0 0 0 2 0 0 3 0 2 0 0 0 0 0 0 0 6 3 0 3 0 0 0 0 0 0 0 5 4...

it show the head name of the 1st row (with value grater than zero) in 1st coloumn t1 t2 t3 ... are the head names lalit

thanx bro

PLEASE HELP

T1 T2 T3 T4 T5 T6 T7 E-117 E-120 E-125 E-124 0 2 0 0 0 0 0 2 0 0 3 0 2 0 0 0 0 0 0 0 6 3 0 3 0 0 0 0 0 0 0 5 4 this data is to arranged like this: T2 T2 T2 E-117 E-125 E-125 E-124 E-124 E-124

please help me

different names were arranged after commas and i want to seprate them ie. abhishak,anurag,deelep,suresh to abhishak anurag deelep suresh and should be saperated to beside colomn index.

please help

DAY1 DAY2 DAY3 DAY4 DAY5 DAY6 A r 3 0 0 0 0 0 B p 17 0 0 0 0 0 B k 4 1 0 0 0 0 C g 0 1 0 0 0 0 D g 0 22 5 0 0 0 A h 0 0 3 0 0 0 F i 0 0 2 0 0 0 G e 0 0 3 0 0 0 PROBLEM IS TO ARRANGE NON ZERO VALUES IN ONE COLUMN DAY WISE WITH THEIR ALPHABETS i.e 1 A r 3 1 B p 17 1 B k 4 2 B k 1 2...

datatable is like this:- DAY1 DAY2 DAY3 DAY4 DAY5 DAY6 A r 3 0 0 0 0 0 B p 17 0 0 0 0 0 B k 4 1 0 0 0 0 C g 0 1 0 0 0 0 D g 0 22 5 0 0 0 A h 0 0 3 0 0 0 F i 0 0 2 0 0 0 G e 0 0 3 0 0 0 PROBLEM IS TO ARRANGE NON ZERO VALUES IN ONE COLUMN DAY WISE WITH THEIR...

yes , entry against day 3 also appears on the result i write is there so on...

if its possible to arrange data without using macro then its great for me .

its quite lengthy data , so its difficult to show here !! please help.

i do not know macro please do create a macro as like i want in my excel sheet. here is the link http://speedy.sh/JH72Y/help.xlsx