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

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

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

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

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

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)

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

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

Dear Friends, Could you suggest, How can I calculate what is the summation of all +ve numbers & all -ve numbers in the specific column. E.G. A1=20 A2=30 A3=-10 A4=-35 A5=54 A6=60 A7=-34 A8=85 C1=249 (Summation of all grater than zero numbers in column A) D1=-79 (Summation of all...

Hi Friends, I have forgot VBA Project Password, i have tried "Hex Editor Neo" in this replaced DPB sring to DPx but getting error "A Pattern was not found" Can somebody please help me in this Thanks

Dear Friends, I have, C4= 1 C5= 1.1 (=C4+0.1) C6= 1.2 (=C5+0.1) C13= 1.9 (=C12+0.1) C14=2 (=C13+0.1) C15=2.1 (=C14+0.1) but i need cell c14 should be 1.10 instead of 2 & cell c15 should be 1.11 instead of 2.1 Please suggest formula

Dear Chandoo Sir, Just wanted to know, if we have "Chandoo.org" in as android application. Thanks

Hi friends, I have a data sheet where i want "Select Data" button to select data by user form criteria EG: If im selecting following details with user form Brand: HCL Handset Type: IdeaPad Tablet K1 Handset Color: Black in data sheet data should show as per above selected criteria...

Dear Friends, Pls suggest in Conditional format: e.g. A6=0 Rule Type: Use a formula to determine which cells to format Edit the rule Description: =A6=0 Format: Fill "Blue" color applies to cell range =$B$6:$X$6 but only cell B6 got highlighted with Blue instead of selected...

Dear Friends, Could you please help to pick sheet name in a cell? Thanks.

Hi Friends, If i have 5 working days in a week then i can easily get net working days with the formula =NETWORKDAYS... but if i have 6 working days in a week and suppose 3 holidays are coming in the week, then how come i can get networking days for following period? 01-July-2012...

Hi Friends, I have been trying to get output as desired, tried maximum function as much as but hv not got exact output, Please help...sample file is uploaded on following link: https://docs.google.com/spreadsheet/ccc?key=0ArVSTeTslgqFdDR0NFZvdjB4SXEzWGNzbk01cDhkU1E i'm trying to get...

Hi, Im trying to get details from another sheet into report sheet with the help of following formula with the criteria but getting error...

Hi, I have a sales person names in cell range B3:B10 and his customer list in cell range C3:C10. from the sales person names any ones name is in the cell B12, I want his uniqe customer's total count in the cell C12 hence im trying to use formula as per below...

Hi, I have huge data, in that filter on Sales Person (Mr. John) and it shows me data of purchase qnty by party wise. with the help of formula (without help of advance filter), how can i get Mr. John has "#" unique parties? Consider data as per below...

Hi Friends, I have Analysis sheet where data is occurring from the two different sheets (Sales Data and Import Data) with the help of INDEX, MATCH and SUMPRODUCT formula. now I need help to build formula for following condition in the same "Analysis sheet" (excel file is uploaded...

Hi Friends, I have an excel workbook template, in that I wanted to know, from whose "login id or user name, dated when and at what time" last changes are happened in the workbook. Like.. Column A= Last changes by User Name/Login ID? Column B= Last changes on which date ? Column C= Last...

Hi Friends, While enjoying with excel work, I just got one thought/ challenge...i would like to share it.... How can hide/ unhide "Protection tab of the Format Cells dialog box" it should not appear in the sheet or worksheet. Thanks in advance Rgds, Ajinkya

Dear Masters, First of all i would like to thanks for your valuable guidance, because of ur direction i could able to learn new things. Also im very basic learner of excel VBA programming. With your guidance, i have prepared template based on VBA codes. Require ur more guidance, i have...

Hi Masters, Some one could please help me? i'm not able to take date or write a code for selection of date into Sheet name "Data" column "E" with the help userform3.calender1 sample data and file is uploaded....address is https://hotfile.com/dl/162557126/7b42acc/Data_Entry.xlsm.html...