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
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 Files (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
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.