Required Formula In Excel - Xls Download

pandumanish2011@gmail.com
Dear Members
Please go through the attached file, I required excel formula
somashekhar.b
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
amukam
Hi All,
I am working with a HealthCare company in Delhi as Assistant Manager - HR, Kindly call me at 9560899988 for any job as doctor/Front Office Manager, Accounts etc.
Regards
Minakshi Sharma
sukumarhr
HI
1) Select the row from E 17 to I 17.
SIVA
2) Type "=" & type "Transpose".
=TRANSPOSE'
3) open Bracket & select the row to be transpose & close bracket.
=transpose(E7:E11)'
4) Then Press "Shift +Ctrl +Enter".
Regards,
Ksukumar
uvaraja.vp
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
uvaraja.vp
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)
Dnyan2001
Hi,
I have attached excel file. Check your file and if you want any more changes tell me.
Also You can post your queries in below mentioned forum, in this forum there are many people join.
Forms, Formats & Questionnaires
1 Attachment(s) [Login To View]

sathyaraj-jayapal1
I need excel sheet with all formula with data examples.
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute