Advance Search Feature
Available Downloads - Page 1
Search Result For "Employee Data In Excel" - Page 1
I am also very useful for these MIS formats. Thanks, I am an M.Com graduate in India. I would like to thank you, Akansha and Amit. This is very good as it is helping me to develop my future.
Dear Saima,Please refer to the link provided below:[https://www.citehr.com/397346-excel-short-cuts-excel-formulae-2.html](https://www.citehr.com/397346-excel-short-cuts-excel-formulae-2.html)
Sorry,Your question is not clear; there are no numerical data in Q4:Q17 on your sheet 2\. How can you compare oranges and apples?Have a nice day.SimhanLearning and Teaching Fellow (Retd)The University of Bolton, UKChief Advisor, Promentor-Consulting
Possible through the use of VLOOKUP/HLOOKUP function in Excel. For more, please send some sample data.Regards,Amitava9830990154
Hi,Basically, I am trying to manage employees' Annual Leave Record, and I don't want to compare anything. Instead, I want to save time. For this, when I enter data in sheet1, I want the resulting data to automatically enter in the annual sheet in front of the sa...
Dear Amitavamaj,Thank you for the help, but I think that is not what I want. Or maybe I don't understand how to use it. So here is the sample file for what I want… I hope you can help me.Goldeneyes20006 on Yahoo
Please use HLOOKUP and VLOOKUP to bring the data you want to get in the sheet, as advised by Amitava.
Hi, I need some help in Excel.I want to attach 2 or more cells in 2 different sheets. For example, while making an attendance sheet, I have two sheets. What I want is when I write any name in the 1st sheet, it should search for the same in the 2nd sheet and post...
Hi,I hope the attached Excel file is what you require. However, there is a minor issue with the data validation above. The problem lies in auto-refresh. When you make a selection, for example, Sheet1 and then you choose 11, the data validation cell will still di...
Sheet 1 Sheet 2A 11 A 101 B 22 B 202 C 33 C 303 D 44 D 404In Sheet 3, cell A1 has a drop-down list of sheet 1 & sheet 2 names. When any sheet is selected, the table below should have the respective data validation. Try to create an invoice where each customer ha...