Recent content by Ajinkya

Hi, I want to create MLM binary tree fro left & right partner in excel, every person will refer 2 person below his down-line at left and right side and down-line again refer 2 member there down-line etc. and new people keep adding.. Sample data file is enclosed, looking for vba codes with...

Thanks Narayan, let me check, hope it will work Ajinkya

ok Narayan, i have file A where i have kept some important details. on daily basis i have to use that with the help of vlookup but every time i need to open that file and map with required criteria, here i want to avoid that exercise to search that file then open it and then map it. can we...

Hello, pls let me know if any unclear thing. thanks

Hi, I have stored master sheet in that model wise updated purchase cost, landed cost, dp price, last sold cost , profit and loss such type of details are kept in separate master sheet and seperate folder. in a day many times i want to use that master database for multiple purpose and every...

Hi Sajan and Ajit, Thanks, your also tricks are working :-)

Thanks Faseeh, its works Hi Sajan, Tried but nt getting exact output. Rgds, Ajinkya

Thanks for your valuable guidance and suggestions dear :-) Rgds, Ajinkya

Hi Faseeh, Congratulations for 1K milestones. thnaks for ur formula, but it is slightly matching with my requirement, because im looking for "Gain/Loss comment and numbering, should come automatic with formula or something..." like, 1 Loss 2 Loss 3 Loss 3 Gain 2 Gain 1 Gain

Dear Frineds, I were been trying to mark a numbering for top 3 highest and lowest value with loss and gain comment. Coloumn B having following data B2= -78% B3= -75% B4= -61% B5= -58% B6= 43% B7= 44% B8= 47% B9= -16% Comments are in coloumn C (want a formula) C2= 1 Loss C3= 2...

Hello friends, gud morning. Thanks, just saw your guidelines, as per latest of Faseeh's formula have tried, Thanks dear its working. also thanks Kaushik, Sir Luke M and nazmul muneer for your valuable help, let me go through it, dam sure these also definitely work, but sure these all...

Dear Friends, I have sample sheet which is uploaded on following path.... https://hotfile.com/dl/179686300/89b7266/fetch_data_if_cell_value_specific.xlsx.html where i am looking to fetching data from "data sheet" into the "report sheet" if the data sheet's "column R" met with value "1" as...

Thanks Kaushik, Suresh Kumar,nazmul_muneer and finally Faseeh, its done thanks again for your guidance :-)

dear friends, thanks for your amazing formulas. on the similar criteria , i have uploaded sample file.... https://hotfile.com/dl/178746079/40480b6/Book3.xlsx.html where in Sheet2 model like M35 available in sheet1 item list and its qnty i wants in sheet2 as like as mentioned. pls help

Dear Kaushik, pls gimme some time, i will have words with you on the same....