Search results

hi somendra, the value need to appear in A+,I+ & Z = 25 where A-,I+ & Z need to be the result of combination of the given numbers. regards,

hi excel users, I have attached an excel file for finding out number combination. which formula should i use to find out other combinations. There is combin & permut in excel. Should i use any other formula along with this. The sheet is without formula as i couldn't find the correct formula...

thank you luke and old chippy for the quick response and for your input. I have removed the "spaceOUT". Regards, ganesh

Dear experts, I have used sumif to calculate all recruited people which is denoted as "IN". But sumif formula is not counting all left people which is denoted as "OUT". What is actually am i missing, there? Regards, ganeshm

thank you.

hi xiq, each check box has value on the top say 1st chk box has 25, 2nd has 15 and the 3rd has 5. I would like to calculate for the remaining rows too.

Dear all, i have attached an excel sheet to count check boxes. One sample is done for the first row. what formula should i use to count whole check box Regards, ganeshm

i just didn't realize i should use index formula. Thanks. It works. Finally, something specific is learnt for the day. Regards, ganeshm

Hi Somendra, input cell in B3 in sheet 1 (which is 24816) in cell B4 answer is 29 (calculation: 24816/12 = 2068) - (corresponding range of 2068 is 29). regards,

hi... Is it possible to combine both conditions in one cell. sample sheet is attached for your perusal. regards, ganeshm

Thank you for the guidance. It works.

Hi... I have a sheet where i click say "manager", the value in the corresponding column appears. Likewise if i select the next option "professionals", i would want the value in the corresponding formula to appear. Just guide me what formula should i use in order to complete the table. Excel...

hi ... How to use conditional formatting for hijri dates. The formula i used for Gregorian date is =$C$10-TODAY()<7. How do u use it with the hijri date. Regards, ganeshm

further to the above post the following formula works well, =IF(D2>0,LOOKUP(A2,{49,50,60,75,90},{0,2.5,5,7,10}%*B2),LOOKUP(A2,{49,50,60,75,90},{0,25,50,75,100}%*D2)) and also ABS function. BBD's idea and SirJB7's input was very useful.

can you post a sample file

Thank you BBD & Sir JB7. I at least learned some new function. Also, i just followed positive sign 1st and then negative as suggested by SirJB7. Finally, my work is minimized. Thank you again for the suggestion.

dear experts, i have calculated cell value based on cell color. How can i combine both the formula in one cell. Since the formula differs for both the cell colors. I would like the result to be displayed in positive value. Also, if the cell color changes blue, the corresponding formula need to...

Hi . . . I have a workbook called daily planning. I want to link this to another excel workbook. Like if i type the badge no. it should take corresponding name and its status. Is this possible with the attached workbook, because data is scattered. regards, ganeshm

hi . . . i have posted a sample file where the formula is =IF(A3>=90,(C3*100%),IF(A3>=75,(C3*75%),IF(A3>=60,(C3*50%),IF(A3>=50,(C3*25%),IF(A3<=49,0))))). Note: 1. when column A calculates column C the above formula throws correct value. 2. when column C is empty, the if condition should...

Dear SirJB7, Without using vba code is it possible to use formula in name range? For instance, 1st drop down - i select Finance - 2nd drop down - since finance dept has only two nationalities (reference sheet 1) say "British" and "Jordanian", will the 2nd drop down show only these nationalities.

i am sorry. Actually i got some error 1004 in the beginning, but now works fine.

Dear excel ninjas, if i try to insert a column after "G" it gives error sample sheet is posted. I even tried changing auto filter 8 to auto filter 9 in vba, but i received error. Is this error because of the special cells?

thank you SirJB7 for your quick response. This helps a lot.

hi... can any experts sort out the above excel book "#ref" error.

thank you sirJb7.