Search results

Noted. Will be mindful.

The requirement is to have the final view as depicted in the Required View. Sample data is not required in the final view. If possible with excel formula , it will be great.

Hi All, I need your help with below. I have a excel spreadsheet which look like below (attached ) : Service Id's are repeated across the various company id's. Requirement - To create a view : Total amount need to be splitted equally across the service id's ( for example if total amount is...

Sorry was using mobile hence used the table. Uploading the excel now. Thanks

Thanks however the view which is required is something like this : Company Id Service Id Amount 1001 100069 $300 100066 $300 100513 $300 100503 $300 100507 $300 1002 100069 $6300 100066 $6300 100513 $6300

Hi All, I need your help with below. I have a excel spreadsheet which look like below : Service Id's are repeated across the various company id's. Requirement - To create a view : Total amount need to be splitted equally across the service id's ( for example if total amount is $1000...

Thanks a lot Hui :)!!! It worked like a charm.

Thanks for the reply... But this is not what my output looks like. I have updated the attached spreadsheet with output example. One column for emp. id , second column for wagetype & third column for the amount for the corresponding employee id & wagetype. Sorry for confusing both of you...

Hi Hui , Thanks for your reply however I think I didn't explained the scenario correctly. Let me try again : I have to transpose the WT and associated amount with the employee code. There are 1000+ employees data needs to be transposed. Copying each row and transposing will take lot of...

Hello All, I have data for around 1000 employees arranged horizontally which needs to be transposed vertically to update the database. There are around 60 columns of data for each employee that need to be transposed. I am attaching a sample excel with this thread. Any help will be highly...

Thanks a lot Hui & Somendra . You guys are amazing. I just now need to tweak a formula a bit so that it do summation retrospectively. Thanks again!!! Regards, Aks

Thanks a lot Narayan & Syed however I don't want to change the data layout. I understand that changing the layout will solve but that is not an option.

Hi All, I have an excel file which is set up like below. My requirement is : If we input in cell B9 for example as April then in the summation of parameter A in cell C11 should have summation values of A parameter from Jan , Feb , March & April. Likewise for the other parameters C & FC. I...

Thanks a lot SM for the quick response!!!!!!!!!

Hi Guys , Need your help!!!! I have a huge spreadsheet(25000+ records ) which is arranged as below: However this data need to be re-arranged in below pattern. The blank cells will have the amount for the respective id & group. Is V lookup using Index/Match is the way out ...

Hi Kaushik, Thanks a lot ...It worked like charm!!!!!! Regards, Aks

Hi Nick & Bobhc, Thanks for your replies and insight. I should have mention in the query itself that I dont want to use pivot table method . Sorry about this!!! The way Nick represented in the formula version I was also able to achieve that however my desired output format is : Cities...

Hi, I have a range of data which is in below format : Cities February March April May London 4 6 0 9 Paris 3 3 2 4 New York 2 2 4 4 Tokyo 1 2 4 3 London 7 4 5 1 Paris 3 0 2 3 New Delhi 7 4 2 1 Manila 5 6 7 2 Tokyo 3...