Search results

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

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

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

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

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

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