Search results

Hi narayan your soln was wat i was hoping to get thank you. and to clear ur doubt yes narayan even if it is 9.6 mm , i should go for higher pipe dia. otherwise it will fail. thnks again

Narayan u r rite that formula doesnt work well. i will give u a real life data I am a piping engineer , we have a pipe standard to select for our calculation. ex: min dia required -12.1 Std. pipe dia 6.4 9.5 12.7 15.9 19.1 22.2 25.4 31.8 38.1 50.8 63.5 76.2 -now i have to...

Narayan thanks for d reply this data is just made up stuff i deal with all kind of inputs it can be anything 2.1, 2.22 or 2.22223 but it should take "greater than " value i am using very crude method like '=if(A_value>3,3,match(A_value,A_list,1)+1))'

Hi ppl I am facing this below problem from long time I have table A---X----Y----Z 1---10---20---30 2---20---40---60 3---30---60---90 if input for A is 2.5 and i want output of x or y or z then all built in formulas excel gives "less than value " like if i put =MATCH(A_value,A_list,1) it...

no sir .. i didnt see anything but printer will take input frm page layout if page preview itself showing small table then printer setup wont come into picture rite ?

Hi ppl, this problem might look simple but its eating my head please give soln or any releted links to learn it. I am unable to fix proper page layout to take printouts (this is very simple for many ppl :( ) say i have a table in spread sheet and i want to take print out of it in A3 size...

Hi ppl, i am trying to extract formula(polynomial eq) frm a graph curve say i have two tables 10---- 50 20---- 100 30---- 150 40---- 200 50---- 250 if i plot this and extract the formula i get "y=50x"(actually "y=5x") so it means that i have to give input as x=1,2,3,4,5 y...

@sajan : good one sajan it workd

thank u but if zero is there in range ex: "0,1,2,3" is there then i want formula to give value 1 i used =IF(MIN(xyz)=0,SMALL(xyz,2)) but want to understand why its giving error

HI ppl i know this question has been asked many times but my problem is bit different i have different values at different places say at "a1 c1 n1 " and i have to find minimum and above zero so i took these three cells and made a array using NAME A RANGE(named "xyz") so now wen i use...

thnks narayan it worked thank you very much

anyways thanks suresh for showing interest

thnks suresh i think it wont help wat i need is something like u 1st select the range then when you run it it should change sytax should be something like this 'activerange.select' 'for each cell in activerange' 'activecell.name=activecell.value' 'next i'

hi ppl , i try to use "name a range" very often now my problem is i have 10 ppl name and 4 branches they belong i want to save those 14 names in name manager i use this macro 'sub namemanager ActiveCell.Select acticecell.Name = ActiveCell.Value ActiveCell.Select end sub ' say if i...

thnks hui and SirJB7 , i thought i will excel itself now i avoided circles by using letter "O" i am doing macro like this if no rows = 4 no of tubes per row =4 no of inlets =4 then it should show O O O O O O O O / / / / O O O O O O O O my code is...

Hi Hui, I was talking abt userform prepared in VB sheet equidistant like this " O - O " Hui one more doubt =MATCH(13,{27,35,39,13}) its giving me an error #N/A thnks hui

hi ppl, i am preparing a macro which takes input X=10 and draws 10 equidistant circles of same size in userform thnks in advance

@narayan : thank you for suggestion watever you said is rite ..tats wat i wanted i solved it by creating a click button in userform that wil extract default values frm worksheet i have doubt where and how do i upload worksheet in this website ? thnk u guys

Hui thnks for helping me i preparing a macro where i have 20 inputs ..some are repetitive so i want input 2 take default value i dont want user to get frustrated while adding inputs so i have put some default values in inputs and give an option to change it if doesn't like it then save time...

hi ppl, i am created a following userform takes value of X and gives value of Y .. simple one and i did it X($A$1) =1 ($b$1) Y($a$2) =X+2 ($b$2) ' Private Sub CommandButton1_Click() Range("b1").Value = TextBox1.Value TextBox2.Value = Range("d3").Value End Sub ' but now my...