ali

Dears, i need to limited the below formula and make it working automatically when i increase the column the row increasing after divided it i used the below formula =INDEX('[TESTSHeet.xlsx]Customers INFO'!$B$2:$B$201,ROWS('[TESTSHeet.xlsx]Customers...

Hi All Hope everyone is well I have the below data and i am trying to answer the question : what is the overall average length of days for open status for each manager ALi and MAX. <tbody> A B C D 1 Manager Start Date End Date status 2 Ali 15/02/2019 17/02/2019 Open 3 Ali 18/02/2019...

I have a series of worklist written in sheet 1 and sheet 2 as indicated below. What I want to happen is that at Sheet 3, I will have an input cell which is designated at A1 which when I type any word from column F of sheet 1 and 2, it will filter out that word and all information on the worlist...

Your support is request to guide can we count duplicate values just one time like as below Ali Zaib Idrees Ali The answer should be like = 3 as the "Ali" is show two time

I want to create a center wise duty list from an existing mixed center wise duty list Mixed center wise duty list <tbody> S.No Name Center 1 Gul Nisar Lahore-1 2 Jamil Ahmad Siddiqui Lahore-5 3 Muhammad Ashraf Lahore-2 4 Naeem Akhtar Lahore-4 5 Munir Ahmad Malik...

Hi, I am looking for formula that can split contact name properly. I have 1,000+ Contact names like below.. Jennifer Monroe Monroe, Jennifer Ali Talai Talai, Ali Kim Millman Millman, Kim Stephen E Wood Wood, Stephen E In above example person name is repeated 2 times with ",". Now I want...

hello guys , i have problem with Vlookup i have a sheet "board" like this B A yes Jack yes Ali no Sara yes Alex no Martin yes Tim and in another sheet i have a list for only Yes then i want list all the names with Yes in the "board" sheet in next sheet want like A...