Search results

Debraj thanks for your help can u explain your formula

Hi Sir JB7 Now you please consider attach file

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

Hi bobhc : https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!127 this is link Hi azumi : I check it your formula, I am unable to implement on my sheet Hi Sir JB7 : Sorry next time i keep in mind My problem is When i use vlookup function Each time it copies first value from multiple...

Please solve my problem in these link file https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!127

Hi SirJB7 a) As I told you earlier I have little knowledge about Excel and English also. I do practice on excel b) i) You really done a fantastic job for me. You have excellent skills in excel. ii) Don't say sorry. the fault is at my end. In your formula i don't understand the meaning of...

hi SirJB7 If you apply formula on sheet Form 16, Then it should be more helpful for me. Regards

Thanks a lot. I examined your file. It help very much. You done a great job and correctly say EXCEL is very powerful Software.

thanks & sorry sir, I delete this link file. Now i send you demo file https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!124 So please help

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (EDITED SirJB7) Fil name is Income tax and form 16 In this link i send you my original worksheet file Debraj Roy : This is not done by using drag. Sirjb7 : I am not good in excel as well as english. After starting work in excel...

Faseeh You see in my sheet there is gap between F3 to F6 only two box and where formula place gap is A1 to A7 is five box and formula work in your sending sheet gap between source and destination remain same. So try to understand my problem

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

Faseeh you're right Sir. I A13= 57 i.e f9. https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!120 will you tell me the meaning of thread.

https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!119 Faseeh follow this new link

Sorry I Send my Question in tommorow

=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

Because i apply it on huge number of sheet

Thanks Sir, It work Please sir explain it functionality.

Sir I want a Formula which i Want to place at Cell A1 When I copy formula from A1 to A7 the Value Come : f6 i.e 56 (Here I don't want to adopted dragged procedure) Your formula work on A7 but not work on A1.. So please give me proper Formula

https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!118 Check out this link. there is excel file. Please solve this problem

Thanks sir. It solve some of my problem. But can u solve this problem also https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!118 I shall be very thankful for this.

https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!115 sorry sir please use this link

https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!114&authkey=!AEc_8LRb-ZuMLOk Now please see this file and give me formula

Sir you are really genius, thanks a alot. Many many thanks. you are God of Excel

sir i does not work. i give you link for the question is : https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!114 2shared also require ID so i use skydrive. Sorry to disturb but i shall be very thankful for this