No Tags Found!


pandumanish2011@gmail.com
5

Dear Members Please go through the attached file, I required excel formula
From India, Guntur
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
From India, Bangalore
amukam
1

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
From India, Delhi
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

From India, Jalandhar
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

From India, Madras
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)

From India, Madras
Dnyan2001
62

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

From United Kingdom
Attached Files (Download Requires Membership)
File Type: xls required formula in excel.xls (25.5 KB, 3172 views)

sathyaraj-jayapal1
I need excel sheet with all formula with data examples.
From India, Chennai
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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.