Search results

Thanks guys...but I have already made a checklist with the help of that...I m looking employee in out time at various point for different departments and that is possible to keep a system at main gate of office...

Yes with the help of that tutorial checklist is made. It was awesome. But really looking forward for making some entry form to keep a track of employee in and out times every time they come in office or leave the premises..it would be a great help to have it...

Hii Excel Gurus with the help of time stamp tutorial I successfully implemented the checklist in the department. However taking a step further I want to place a system at entrance of office wherein people coming in the office enters the employee ID and time in gets recorded and when he sign off...

Hii.. I have a query similar to query I have asked earlier. I have a workbook containing sheet "present date " in which customerId & payment made to the parties are mentioned.There are various daywise sheets also in which payments are made by customers to various parties on different days. The...

thanks

I have extracted the part of the formula suggested by you =INDEX($B$1:$B$6,MATCH(1,--ISNUMBER(SEARCH($H$1&"*"&I1&"*",$A$1:$A$6&$B$1:$B$6)),0)) It's working ...thanks

Hii somendra...Thks for revert but can IF ERROR be replaced as I am using earlier version of excel

Hii I have a long list of daywise payment table. Col A contains ID and Col B contains the party name to which payment is made. Sample is attached for single day. Such table is made for 25 days in a month. In successive month I have to check that same payment is made to same party with same ID...

Thanks

Hi I am trying to concatenate the text in ColA with two a number formatted at two decimal place Col B. But the result comes in mis aligned format in Col C. Figuring out how to get the desired returned as given in Col D where the numbers are aligned with decimal

wow...........it's amazing and working..... I have tried something ..pls check once....i have used some key words in Col d which are being matched with col a & colb

formula will do well even with usage of helper column...pls guide

Not actually..i am not that much comfortable in VBA and still learning formulas...please provide vba code..thanks for helping

Yea sure..you are right..attaching a file with sample of 3 records...comparing col a with col b and results are in col c &d

Hi I am trying to compare two lists wherein the common words will get displayed in third column Example Col A Col B ColC ColD Abc medical agency xyz drugs & medical INC Medical Ab books store...

thksssssssss

It's working great.........really u r amazing...no words to explain the knowledge levels u have....Can u suggest some books and sites to study and practice

I have bit a modified file in which the desired solution is in sheet 2 but the red one is still not solved...tried a lot...remaing are solved...i have let the formulas used as guided by you and previous knowledge..file attached to resolve the red one in sheet 2...input is in sheet1

No no...even the VBA code u wrote was amazing....yea thks it's wroking..i am not that gud in array formulas..thks a ton

Hii Shri...the code is working fine..thks a ton...actually i have tried the following code also (But i m trying to figure out some formula for it). My code is as under Sub Test() Dim ShNew As Worksheet Dim r As Long Dim LastRow As Long Dim i As Long Dim Batch As Long...

Hii I have system generated report which i want to covert in the manner so that reasons of return and batch no both appear in the adjacent cells of a invoice. Presently they are appearing at top of invoice and appearing at variable positions. To make it more understandable I have attached the...

wow...wonderful...you are champ guys ...thks Luke and hasseb

Sir, can u please advise the books for excel formulas & VBA. I am trying to gain knowledge but still struggling. Please guide n advice

thanks a lot....but can it be done using formulas instead of code

I have a list as under in column A 40-Present with document 0046DDCENPAY 31-Instrument out dated / stale 0046DDCENPAY 0083DDCENPAY 0083DDCENPAY 1400DDCENPAY 1400DDCENPAY 0286DDCENPAY 34-Cheque irregularly drawn / amount in words and figures differ 0826DDCENPAY 39-Image not clear...