5
Select the cell where you want to paste, Go to Paste special , choose value in paste section and select Transpose in operation click on ok
From India, Bangalore
From India, Bangalore
Dear Friend,
If you have that solution in forumal or Pasting Option, Becuase , some time the name can be shuffeled, that time the paste special option cannot be applicable in case if you do that it come wrong output
Jus Put Sum if Formmula for the each Row
=SUMIF($D$6:$D$13,E16,$E$6:$E$13)
Now automatically the exact amount will come, but one thing the same name cannot be repeated
From India, Madras
If you have that solution in forumal or Pasting Option, Becuase , some time the name can be shuffeled, that time the paste special option cannot be applicable in case if you do that it come wrong output
Jus Put Sum if Formmula for the each Row
=SUMIF($D$6:$D$13,E16,$E$6:$E$13)
Now automatically the exact amount will come, but one thing the same name cannot be repeated
From India, Madras
Normal V Lookup formula
or our friend says the same method Transpose method
1. First copy the Required Data
2. Go tp Paste Special option
3. below there have option Transpose
4. just Select and enter (now your requirement is over)
From India, Madras
or our friend says the same method Transpose method
1. First copy the Required Data
2. Go tp Paste Special option
3. below there have option Transpose
4. just Select and enter (now your requirement is over)
From India, Madras
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
EXCEL FORMULA.xls