Search results

@ Hui, I M really so sorry sir, actually answer will be 2050...i had mistake in manual totaling....but here all are excel experts....they can read from my brain..what i want.... so thanks to all experts...and thanks faseeh....... and again sorry to @hui..... Regards CA Mahaveer Somani

thank you very much narayank.... really awesome vba code........... much much thanks dear.......its really useful for me......

i want to put a formula in attached file for calculation of profit as per First in First out method...(FIFO) method... if is there any vba module you can provide me then also i can manage that one... any one can help me...? my sample query data and expected output (profit) manually done in...

i did it but is there any way for do it becoz it says i have to make open the source file whenever i want to use the validation....?

thank you shrivallabha it really works gud Thank again dear bro... Regards CA Mahaveer Somani

i have two workbook in D drive path is as follows: D:x.xlsx [have data in sheet1 range(A2:A15)] D:y.xlsx i want to make data validation in y.xlsx sheet1 range("A2:A15") from the source of D:x.xlsxsheet1!$A$2:$A$15 is it possible to make data validation if the source list is in another...

Hi, I have two columns of address, and I need to compare with these two columns and find the difference of the word. Example:- 1105 W Riverside Dr 1105 West Riverside Drive I need the difference between these two columns as est rive. Do we have any functions to do so? I have attached...

put the formula in C1 =If((A1-B1)<0,0,(A1-B1)) Regards CA Mahaveer Somani

actually i have very huge data row wise and column wise so i need a macro for the following:Sheet1: A B C D E F G H I J K L M N LIKE THIS SO ON... 1 J K H K K K J K I U 2 H K U P R G H J K F G B N Y LIKE THIS SO ON... like this so on...row wise too..this is now upto 25000 rows...data...

will you upload the same file with telling us the specified area where you want to fill the value? and i think you should change the title from "hi" to "how to enter value in excel sheet from userform" for fast replies... Regards CA Mahaveer Somani

welcome ran i'll my Pleasure Regards CA Mahaveer Somani

i hope this link will useful to you....bcoz it seems as like you put a query here... http://www.xtremevbtalk.com/showthread.php?t=90357 Regards CA Mahaveer Somani

as per my understanding there is no connection with First name.... you want to make unique id number on the basis of phone number and p.code(pin code)... is it? Regards CA Mahaveer Somani

UPLOAD A SAMPLE FILE FOR BETTER ANSWER

will you please check the following link.... http://www.2shared.com/document/79Kk0BK8/result.html i have put a file on the above link in which there are two sheets Sheet 3 = problem data Sheet2 = you will get there answer...as you required after the above file download you have to open...

can you provide a sample file with problem data and manual solution data... Regards CA Mahaveer Somani

dear lalit232 if there is problem to understand the above step then you can check what i found for you. http://stackoverflow.com/questions/7840327/how-can-i-take-a-large-piece-of-text-in-one-cell-and-insert-carriage-returns-to Regards CA Mahaveer Somani

i assumed that your all data is in Column A like this: A1= abhishak,anurag,deeleep,suresh A2= mohan,sohan,kailash A3= ram,shyam,vimal,kailash,hari A4= ajay,vijay then dear follow the following steps 1. select the coloumn A 2. Go to the data tab... 3. now select the Option "Text to...

yes you can drag dear but first follow the step before drag step1. make filter and select one item from filter step2. press Ctrl + A i.e. select all the cells step3. then press Alt+H+AL (only in excel 2007 i.e. "Left Allignment") step4. now you can drag... step5. now remove the filter and...

ctrl + ; is shortcut key of today @sushanth....

glad to help you aparvez007 enjoy dear Regards CA Mahaveer Somani

i assume your data are starting from A1 then put the following formula in B1 and pull down up to your data... =IF(LEFT(A1,5)="30000",A1,"") hope it will work Regards CA Mahaveer Somani

can you upload a sample file with manual solution?

SELECT THE SAME COLUMN then press ctrl + F then put the value 30000 then select the match case option only remove the tick from the match entire cell contents... then press find all.... Regards CA Mahaveer Somani

faseeh thanks dear its good for me but not best... becoz it shows only one item value while i want to get my all item value therefore i think i have to make so many table like this but it is not possible dear.. is there any other idea do you have for me...? Regards CA Mahaveer Somani