Search results

thanx a lot friends. It was a great learning

dear all, how can i get comma separation when i am using formula of this type ="diff "&N2-M2 where in N2 say I have 1,52,500 and in M2 I have 11,200. the output should be ------------ diff 1,41,300 thanx and rgds

thanx john and khalid

dear all. is there a short cut to move to the first row of a column. Say I am in cell G153 and I want to quicly move to G1. Also there are some cells in between G1 and G153 which are empty so cntrl + up arrow will not work. thanx and rgds

Thanx for the reply. The data to be copied is not filtered. It is in continuous cells. I want to put this data in a filtered table

dear all, I have some data in a column which I want to paste in a filtered table in different sheet. How can this be done. thanx

dear friends, thanx a lot. Is there any way in which if i write 20 X 40 in the cell, the same cell displays 20 inch X 40 ft.

dear all, say i have got following things in the cells cell a1 20 b1 X c1 40 In cell d1 i want to display 20 inch X 40 ft I can use =a1&b1&c1 in cell d1 and it gives 20X40. Further i can format cell d1 as @ "ft" and it gives 20X40ft. But is there any way where I can also get the "inch"...

dear friends, thanx for the reply. As somendra is saying , i guess this is not possible using CF.

dear all, I want to insert "-" (without inverted commas) in cells which are blank using conditional formatting. I am using the formula =isblank(a4) ,where say a4 is the blank cell , and putting "-" in custom number format but its not working. Same formula is working when i am putting some...

sorry deepak, i am not getting you. I just want to know if I put 3000 i am not getting the result. I have to put 3,000.00 to get the correct result. But with greater than result comes with 3000 (no need to type 3,000.00)

dear friends, just wanted to know why when i put equals 3000 in auto filter ,i don't get any result (shown in screenshot) but when i put greater than equal to 3000 i get the correct result thanx and rgds

dear luke, I guess i have not been able to make myself clear. say in cell A19, i have 2x63 and i want to write a formula to extract 63 (numbers after x) from it. the formula i am writing is =RIGHT(A19,LEN(A19)-SEARCH("x",A19)). Just want to know what will be the best way to write it . (I think...

it becomes easy to write in the function argument dialogue box rgds

dear luke and somendra, actually i want to write a nested formula using function argument dialogue box. So i need to toggle between the dialogue box and formula bar without using the mouse for saving time. getting into formula bar helps because it can open the new function argument dialogue box...

dear all, is there any shortcut to toggle between function argument dialogue box and formula bar withou the use of mouse thanx and rgds

dear deb, this is really a good way. thanx

dear all, I want to insert row after there is change in a data in a column. eg name a a a c c d f g g now after "a" ends i want to put a blank row. similarly for c , d , f . g. I have searched and found vba solution. Is it possible to do this without using Vba. thanx and rgds

dear somendra, this is exactly what i was looking for. thanx a lot

they are same

dear all, say i have some data on a sheet eg ajay maths 70 manoj history 80 ajay english 85 how can i get all data regarding ajay in a new sheet keeping in mind new data will keep on coming in the original sheet

hi all, one of my excel file suddenly is giving the following errror message : excel found unreadable content in ...........xlxs. Do you want to recover the contents of this workbook? what i want to know is what are unreadable content and in future how can i save my files from such error. I...

thanx narayan, this is of great help

thanx somendra for the help. but I would like to do it without using a1="icici" because new names will keep on coming in the list. can we do it in some other way.

dear all, say i have a column with some names eg hul hul brittania brittania ub icici icici icici here i want all the same names with same colour and next set of same names with different set of colours . eg hul will be in blue , brittania say will be in red and ub will be in any other colour...