Search results

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....

Hi Friends, cell B2=M2MEM555CFGL (item) cell C2=190 (value) cell D2= M555 i wants to look the match value of cell D2 in cell B2 and wants the value of cell C2 like, M555=190 (M555, wanted to find from M2MEM555CFGL)

Hi Kaushik, How are you dude? Yup, really long time back, now a days stucked in heavy work load literally don't have time to have meal.... well, coming to the point, file is uploaded... https://hotfile.com/dl/178647957/5adf3b4/Dealer_Order_Forcasting.xlsx.html here in yellow...

Hi GGGGG, shift the data from both sheets to separate new excel sheets and apply vlookup formula, thnks, Ajinkya

Hi Faseeh, Meantime i have tried something but its not executing the exact output. Need some guidance...

Hi Faseeh, thanks, yup it can be possible with seasonal trend... can we get the suggetion with help of vba programme based template because this will give feeling like system based details or information... rgds, Ajinkya

Dear Friends, Could you please help me get vba based product order forcasting, which can give me suggetion on what product should i order and in how much qnty., in which colour, based on the last couple of years sales data and opening stock of the current month. pls help Rgds, Ajinkya

thanks a lot bobhc sir for sharing this stuff rgds, ajinkya

Thanks dude, it works also thanks for discription also :-)

Dear Friends, Please guide in formula... A2=N B2=C C2=L D2=-2 E2={=IF($A2="N",IF($B2="C",IF($C2="L",IF($D2<0,CHAR(252)," ")," ")))} Here i wanted to add one more condition for value of cell C2 because it is flexible, here some times "Null" aslo comes insted of "L" please suggest...

great, thanks a lot Ninja