Recent content by thifu3

thanks Hui, please find the attached file. the formula would be in "main" sheet and the datas are from "index" sheet. thanks

Is it possible that if i write the room number and extract all the people in that room? for example In one sheet I have Room 123 Alex John Doe Room 124 Patric Mark Roony and in another sheet i want to look who is in 123 and extract all in that room. please help

i want to count leaves as follows A B C Name leave type leave days John off days 10 Jan annual leave 30 John off days 2 Dian sick leave...

i want to count a letter if the next cell is greater than zero. A B 5 years 2 10 years 3 5 years 0 10 years 4 5 years 0 count how many "5 years " are greater than zero.

Hi guys, Could you please help me to create a pop up alert on an excel sheet when the date in one cell is going to due.

Wow. Chandoo org is the best. Thank you all for giving prompt and wonderful answers.

Hi guys, Could you please help me on this. john 25, doe 26, john 35, bon 28, john 35. how do i calculate the total amount of john?

Hello guys! Is it possible that i can count the following using a formula. i want to check how many trousers are in medium size etc and how may shorts are small or medium. Trouser Small Shirt Medium Shirt Large Shirt Medium

i want to have a refresh button in my excel sheet. when it refreshes the formulas get refreshed which is linked to another sheet. for example Vlookup formula in a sheet and when i press the refresh button, values from another workbook have to be updated.

i want to have a refresh button in my excel sheet. when it refreshes the formulas get refreshed which is linked to another sheet. for example Vlookup formula in a sheet and when i press the refresh button, values from another workbook have to be updated.

i want to highlight duplicate values which is less than 1 year. help please

for example A B C 3 9 5 D=A+B+C=17 I want to make highest value of D is 8 and if exceeds, then it should go to like cell E D=8 and the rest 9 in cell E please help

hi everyone. my question is if a cell value is more than some value how i add it to another cell. for example. i can only accumulate 8 off days and if it exceeds the amount it should forfeit. so, if it is 9 then i want it to be added in "forfeit" column.

@ siraj. actually i want a formula that my staffs work for 6 days they can accumulate 1 off day. like that 12 days they can get 2 days. B2 is today's date and C11 is used to enter commence date of employee. i think your simple formula is working. any advise, please give.

Hello I want a formula that if an employee works 6 days 1 off day, 12 days,2 off days. when i use the following formula, it shows 6 days plus then 2 off days. =TRUNC(((D12)+6)/7)+(WEEKDAY(B2)=WEEKDAY(C11)) d12 is total days worked. B2 today(). C11 starting day..