No Tags Found!

Dinesh Divekar

Business Mentor, Consultant And Trainer

Umakanthan53

Labour Law & Hr Consultant

Madhu.T.K

Seasoned Ir Professional

Vmlakshminarayanan

Sr.manager - Hr&admin

KK

KK!HR

Management Consultancy

Saswatabanerjee

Partner - Risk Management

Drsivaglobalhr

Doctor Siva Global Hr

Nanu1953

Ceo-usd Hr Solutions

AU

Aussiejohn

Workplace Assessment And Training

Rkn61

Sr. Hr Manager

NV

Nagarkar Vinayak L

Hr And Employee Relations Consultant

Alok-singh1

Labour Law & Ir.

NA

Nathrao

Insolvency N Gst Professional

Kumaracme

Hr Manager, A Leading Manufacturing Company

Srivastavacmlal

Master Consultant

NK SUNDARAM

International Corporate Trainer / Hr (od) Consultant

Pan Singh Dangwal

Joint Manager

R.N.Khola

Labour Laws & Ir

Bijay_majumdar

Freelancer In Hr &indirect Taxes For Services Indusrty.

Jeevarathnam

Sr Manager Hr & Compliances

Pvenu1953@gmail.com

Retired Government Servant/advocate

Ommygautam

Plant Hr Head

GL

Glidor

Hr Consultant

Loginmiraclelogistics

Asso.prof.(commerce & Management)

Suresh2511

Labour Consultant

SU

Sudhapradheep

Sr. Executive-hr

Ram K Navaratna

Hr Consultancy

NA

Nani2308

Executive

MA

Mastermined

Principal Consultant

VK

V.K.Dhebe

Hr&admin

RD

Rekha D

Hr Manager

The Cosmogeny

Proprietor

LV

Laxmikant Verma

Deputy Manager-hr

CH

CHERRYTOM

Compliance

AC

Ajithkumar12235@gmail.com

Research Assistant

NS

NAIM SAIFI

Production Incharge

Nayeem Khan

Head Hr &admin

AC

Joshuaalvina
67

Dear Guys, I am ready to serve you. Have You Any Doubt In Excel Formulas? Post your suggestion . Regards, JA
From India, Madras
PROFESSIONALS AND BUSINESSES PARTICIPATING IN DISCUSSION
Jaipreet
Hr Executive
MBA_Viju
Hr & Admin, Pq, T&d
Ramakrishnablue@gmail.com
Senior Hr Officer
Nipunjetley
Strategy And Training Evaluation
+3 Others

prajapatik237
1

yes i am facing so many problem in exel so please give me a Detail information about exel please. Regard Kamlesh
From India, Nasik
jaipreet
2

Hi Would request you to kindly upload the same on Cite HR as all members would be able view the same.
From India, Gurgaon
MBA_Viju
Hi JA,
Glad for your attitide to help in excel forumas. I have a problem where i have to segretate som information on the basis of its contents.
Air - 1
Train -2
Bus - 3
I have cells containing various words from which i have to search above three words in their respective column and write its corresponding value in same row. I have tried FIND and SEARCH Functions, but not succeded. Give me information at my mail ID "vijay_adwade@rediffmail.com".
Regards
Viju

From India, Pune
mukesh_nd
how can we calculate time spent by an employee, in case the company gives the double payment for the over-time. the working hours are "8 hours" per day and more than 8 hours means overtime-hours". how cud we calculate on monthly basis supposing an employee makes some leaves as well in excel. try to extend your supposition to escape each and every doubt for over-time hours-calculation of an employee in excel. thnx
From India, New Delhi
Jasim Baloch
Hi, I just need a salary reconciliation format which must show the last month salary defference and tax format. Regards, M.Jasim Balich
From Pakistan, Karachi
nipunjetley
Hi JA,
This is a good initiative and Excel must be the second most commonly used (if not the most) MS Office application by HR and many other professionals. Thus I would second Jaipreet's request to kindly upload the same on Cite HR as everyone can benefit.
Thanks and regards
Nipun


jagjeet4506
26

Dear Sir
I want to trunc a word for example :
excel coulm.
------------------------------------------------
A | | B | C | D | E | F | G | H |
R ------------------------------------------------|
O 1 | JAGJEET | J | A | G | J | E| E | T|
W -----------------------------------------------|
S 2 | | | | | | | | | |
IN xls can i did it
Please help me
If it is possible in excle please tell me how
please send detail regarding this on my id

with regards
jagjeet singh

From India, Bhatinda
Joshuaalvina
67

Solution

Insert the Match formula in the third argument of the VLookup formula.

Step 1: Define 2 names, see screen shot

  1. Select Row 1, press Ctrl+F3, type the name Row1 in the Names in workbook field, and click OK.

  2. Select the data table by pressing Ctrl+*. Then press Ctrl+F3, enter Data in the Names in workbook field, and click OK.
Step 2: Enter the Match formula

  1. Open an adjacent worksheet, and select cell A1.

  2. In cell A1 type 4/1/2001.

  3. In cell B1, enter the formula =MATCH (A1, Row1, 0).
    (Be careful to enter the value 0 in the third argument to specify the search for an exact value.)

  4. Results of calculation: 7.
Step 3: Enter the Vlookup formula

  1. Enter the account number 201 into cell A2.

  2. Enter the formula =VLOOKUP(A2,Data,B1) in cell B2. In the third argument of the VLookup formula, select a cell which contains the Match formula.

  3. Calculation results: 7,981.
Step 4: Combine the formulas

  1. In the formula bar (Match formula) of cell B1, select the formula without the = sign, press Ctrl+C, and click the Cancel sign (from the left of the formula in the formula bar). Select cell B2, and in the formula bar, select the address B1.
  2. Press Ctrl+V and press Enter.

  3. The final result is a nested formula is
    =VLOOKUP (A2, Data, MATCH(A1, Row 1, 0))

    Screenshot // Combine the VLookup and Match formulas in Microsoft Excel
Regards,
JA

From India, Madras

Attached Images (Download Requires Membership)
File Type: jpg 297-1.jpg (72.4 KB, 84 views)
File Type: jpg 297-2.jpg (29.4 KB, 52 views)

Joshuaalvina
67

Your company doesnt sound very enjoyable.
Can you elaborate on your ask... are you merely asking for a timer to tell you how long excel has been opened?.. what if the user reboots the PC, what do you want then? what if the user goes on break though leaves excel open?....

From India, Madras
If You Are Knowledgeable About Any Fact, Resource or Experience Related to This Topic and Want to Be Part of our support system - Please Register and Log In to CiteHR.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHRŪ

All Material Copyright And Trademarks in Posts Held By Respective Owners.
Members Notified Via CiteMailer.Com