Sir I want lowest tender rate given by firm come to First No and arrangement of Rest all the firms not a issue. Example given in excel sheet. Thanks for help to solve my problem.
Sir,
In attached workbook contain many sheets. I required a formula in "comparative" sheet.
my question is in the Yellow filled box. I have insert comment there. So please help me in this problem. I gave you some overview of my problem that i required a value after match three Columns.
with...
Hi Sir,
Please solve my problem
In my Job, i make salary bills of about 110 employee in excel
& also do the function of calculation of income Tax.
I use a bill file named "bill 1" in folder name "3" which relates to March Month
similarly In next month i use folder "4" i.e. April salary with...
My job is to make salary of employees. I want some formula which depend on time i.e
assume some employee name Captain have taken LIC policy. which have 12 installments. I want a formula which i give command to excel formula after every month it increment one step. for example No of installment...
https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!120
=OFFSET($A$1,(ROW()-ROW($A$1)+IF(ROW()=1,1,-1))*IF(ROW()=1,2,1),COLUMN($F$1)-COLUMN($A$1))
i want to understand this formula because i applied on various sheet
=OFFSET($A$1,(ROW()-ROW($A$1)+IF(ROW()=1,1,-1))*IF(ROW()=1,2,1),COLUMN($F$1)-COLUMN($A$1))
i upload a excel file in https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!118
SirJB7 solve my problem. but i want to understand his formula because i applied on different sheet
In Excel, if I copy a cell containing a formula down the column to copy to adjustment rows, i need formula increase sequentially for example if a1 = 5, a2=2, a3= 4 and then i use coloum no. m4 =a1 i.e. 5 but when i copy m4 paste it on m6 the result is m6=a3 i.e. 4 but i need m6=a2 how can i...