Have You Doubt In Excel In Formulas? - JPG Download

Joshuaalvina
Dear Guys,
I am ready to serve you. Have You Any Doubt In Excel Formulas?
Post your suggestion .
Regards,
JA
prajapatik237
yes i am facing so many problem in exel so please give me a Detail information about exel please.
Regard
Kamlesh
jaipreet
Hi
Would request you to kindly upload the same on Cite HR as all members would be able view the same.
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
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
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
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
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
[Login to view]
with regards
jagjeet singh
Joshuaalvina
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
2 Attachment(s) [Login To View]

Joshuaalvina
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?....
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