Recent content by manish.agrawal446@gmail.com

Hi, Greetings... I have the following data with me (sample, unfortunately I can't upload) A1- has a list (Fruits, vegetables, animals) a2 - list will be displayed based on selection in A1... for eg if i select Fruit in A1, it will display only apple, orange and so on a3. List should be displayed...

Please help me to create a dashboard based on the below criteria 1. resource name 2. Month 3. Work Order (Project is assigned to resource) 4. Expected work to come 5. Leave records Single resource can work multiple Work Order. And vice versa.

Please help me to create a dashboard based on the below criteria 1. resource name 2. Month 3. Work Order (Project is assigned to resource) 4. Expected work to come 5. Leave records Single resource can work multiple Work Order. And vice versa.

Please help me to create a dashboard based on the below criteria 1. resource name 2. Month 3. Work Order (Project is assigned to resource) 4. Expected work to come 5. Leave records

1. https://rapidshare.com/files/629784523/Sale CounterV00912.xls 2. https://rapidshare.com/files/683782091/LinkV0912.xls 3. https://rapidshare.com/files/735462845/PMCvPAA0912.xls 4. https://rapidshare.com/files/1551893013/LinkMthV0912.xls 5...

We are required a execl sheet in which following should be maintained:- 1. All distribution should be maintained on the basis of advance payment from distributors. So, Distributors Account. 2. Order received by the Distributors. 3. on the basis of adavnce & order received from the...

How to make olympics medal chart with each country ranking

The o/p is not matching with the data which I was getting from 1st formula which I have mentioned in the post

There is no data at all. I was just trying to learn vba on blank page And found system behaving differently when i use rows("4:4") and rows("6:6")

Sub Manish() 'Keyboard Shortcut: Ctrl+m Rows("5.5").Select Selection.AutoFilter End Sub Hi this is very simple macro I have written. Filter is getting displayed in 6th row instead of 5 Where as IF i write Rows("4.4").Filter is displayed in 4th row I am testing the above formula in...

https://rapidshare.com/files/2722280117/Imp Support Report.xlsm The formula is in defect workseet copied in A2

INDEX(CV2:CV21,SUMPRODUCT(COUNTIF(CU2,"*"&$CU$2:$CU$20&"*")*(ROW(CU2:CU20)-ROW(CU19)))) It is throwing error

hI, It went into indefinite loop

Hi, I have two worsheet 1>First worsheet contains all the dates in 1st row. Below each row there are few data 2>In second worsheet , I have only two columns In first row , we have only 2 dates.. one is yesterday's date and the next column is today's date Now I have to copy all the...

IF(ISNUMBER(SEARCH("APOLLO 8",N6)),"Apollo", IF(ISNUMBER(SEARCH("BFUB 1.6.4",N6)),"Apollo", IF(ISNUMBER(SEARCH("Fix Team",AB6)),"Defect fix team", IF(ISNUMBER(SEARCH("IMPL & SUPP",C6)),"Implementation Support", IF(ISNUMBER(SEARCH("BFUB15-MCP-Interface-Testing-Actinver",C6)),"Implementation...